Answer Posted / sapna

select,insert,update ,delete

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

977

---

Explain the working of sql privileges?

1143

---

What are the different authentication modes in sql server?

1167

---

What is an identity column in insert statements?

1074

---

What is triggers in ms sql server?

1181

---

What is a collation?

1131

---

Mention the 3 ways to get a count of the number of records in a table.

1025

---

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

997

---

Explain Geometry datatype in sql server 2008 with example

1049

---

what is hash nonclustered index

1022

---

How to use subqueries in the from clause in ms sql server?

1208

---

How do we synchronize On-Premise SQL server with SQL Azure?

124

---

How is sql used in sql server?

1056

---

explain different types of cursors? : Sql server database administration

1146

---

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

1014

---