What is the default schema of your login session in ms sql server?

0 Answers  

---

Define Foreign Key?

3 Answers   ADP, College School Exams Tests,

---

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

1 Answers  

---

How do I partition a table in sql server?

0 Answers  

---

How can you check the level of fragmentation on a table?

0 Answers  

---

Explain the first normal form(1nf)?

0 Answers  

---

What is BLOCK statements in SQL?

0 Answers   HCL,

---

Can you explain the types of Joins that we can have with Sql Server?

2 Answers  

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

0 Answers  

---

What is buffer cash and log cache in sql server?

0 Answers  

---

Is BCNF better than 2NF & 3NF? Why?

0 Answers   Akamai Technologies,

---