Answer Posted / shweta sharma

inserted and updated are the rite answer

How do I start sql server 2017?

1024

---

Can one drop a column from a table?

1098

---

What is normalization and what are the advantages of it?

1067

---

Can we shrink data file in sql server?

1135

---

What is an indexed view?

1030

---

What are the properties of the transaction?

1084

---

what is spatial nonclustered index

1066

---

What is self contained sub query?

1148

---

What is acid mean in sql server?

1257

---

What is subquery? Explain the properties of a subquery?

1070

---

Can we do dml on views?

1042

---

How to convert character strings into numeric values?

1196

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1032

---

How can I check that whether automatic statistic update is enabled or not?

1120

---

What kind of problems occurs if we do not implement proper locking strategy?

1508

---