Answer Posted / ravi

sunil is correct...

Explain the disadvantages of cursors?

1213

---

What is deploy, process and build? : sql server analysis services, ssas

1158

---

Is the log file is a part of file group?

1099

---

What do you mean by SQL injection attack?

1129

---

What is the difference between inner join and equi join?

1044

---

What is partition, how will you implement it? : sql server analysis services, ssas

1103

---

What is a with(nolock)?

1027

---

What's the information that can be stored inside a bit column?

1074

---

What are the two modes of authentication in sql server?

1139

---

Why use sub query in sql server and list out types of sub queries?

1061

---

is it important for a database administrator to understand the operating system and file access? : Sql server administration

1078

---

How to get a list of columns in a view using the "sp_columns" stored procedure?

1089

---

What is sleeping status in sql server?

1080

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

1666

---

What is difference between primary key and foreign key?

955

---