Sqlserver Interview questions


Total available count: 45
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)

1
What is SQL Profiler?
2
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
3
What is OLTP (Online Transaction Processing)?
4
What are different types of Collation Sensitivity?
5
What are the different index configurations a table can have?