Answer Posted / poornima k

create table &t_name(&f_name1 &datatype1);

What is the xml datatype?

805

---

What are the differences between lost updates and uncommitted dependencies?

747

---

What is the syntax for encrypting a column in SQL Server?

756

---

What is sqlservr.exe - process - sql server (sqlex?press)?

789

---

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

666

---

---

What is the full meaning of dml?

717

---

wat wil hapn if we give the both read and deny read permission to user?

1859

---

How to create a new schema in a database?

743

---

What is the difference between NOROW and LOCKROW?

2476

---

What is the correct order of the logical query processing phases?

688

---

List the advantages of using stored procedures?

740

---

Do you think BCNF is better than 2NF & 3NF? Why?

997

---

How to name query output columns in ms sql server?

713

---

Does server sql treat char as a variable-length or fixed-length column?

784

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

745

---