Answer Posted / mobin sathupally

When we install SQL SERVER totally we got six databases.
Among six four are system databases and remaining two are
user defined databases,
The system databases are 1.Master
2.Model
3.Msdb and
4.Tempdb.
The user defined databases are 1.Northwind and
2.Pubs.

How except clause is differs from not in clause?

893

---

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1011

---

Explain what is lock escalation?

987

---

What is the difference between functions and stored procedures?

1089

---

How much space does sql server 2016 take?

908

---

What is user-defined multi-statement table-valued function?

995

---

What is 3nf normalization form?

1019

---

How sql server enhances scalability of the database system?

1108

---

What is cube dimension? : sql server analysis services, ssas

951

---

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

992

---

What is identity?

947

---

Call by value and call by reference in procedure and function, with NOCOPY.

1244

---

What is sql server profiler trace data file?

1046

---

What is a benefit of using an after insert trigger over using a before insert trigger?

928

---

What authentication modes does sql server support?

1014

---