Sqlserver interview questions

Total available count: 38
Subject - Databases
Subsubject - Sqlserver

What is SQL Server Agent?

SQL Server agent plays an important role in the day-to-day tasks of a database administrator (DBA). It is often overlooked as one of the main tools for SQL Server management. It's purpose is to ease the implementation of tasks for the DBA, with its full- function scheduling engine, which allows you to schedule your own jobs and scripts.

Next 5 interview question(s)

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
What is the difference between a primary key and a unique key?
What is the difference between UNION and UNION ALL?
What is Unique key constraint?
When is the use of UPDATE_STATISTICS command?