What are difference between truncate and delete?

Write a sample query for self join?

What is BCP? When does it used?

Can SQL Servers linked to other servers like Oracle?

What is DataWarehousing?

What’s the use of custom fields in report?

What is Nested Trigger?

What is OLTP (Online Transaction Processing)?

What are different types of Collation Sensitivity?

What is the function of SQL Server Agent Windows service?

When is the UPDATE_STATISTICS command used?

What are the properties of the Relational tables?