SQL Server Interview Questions
Questions Answers Views Company eMail

How many databases Microsoft SQL server provides?

Abacus,

610

What does Master database contains?

Abacus,

630

What gets stored inside msdb database?

Abacus,

762

What is the use of tempdb? What values does it hold?

Abacus,

565

Why Master database is required?

Abacus,

601

Why SQL Agent is used?

Abacus,

596

Explain the types of indexes.

Accenture,

635

How network traffic be reduced by using the stored procedure?

Accenture,

582

What is a trigger? Why we need it?

Accenture,

531

What is the difference between functions and stored procedures?

Accenture,

616

How self join is different from outer join?

Blue Star,

603

What are the different types of indexes?

Blue Star,

611

What is meant by referential integrity?

Blue Star,

589

What new changes are being made in SQL Server?

Blue Star,

574

What are the disadvantages of primary key and foreign key in SQL?

Alcatel-Lucent,

630


Un-Answered Questions { SQL Server }

How to automatically create a log when an exception is being received into SQL Server?

735


What are data files?

579


What is the fastest way to permanently delete a 1 million row table named customers?

597


What is BLOCK statements in SQL?

806


on line cluster can we make if yes tell me the procedure

1514






explain databases and sql server databases architecture? : Sql server database administration

521


What are the different types of upgrades that can be performed in sql server?

689


What does the on delete cascade option do?

548


What’s the use of custom fields in report?

567


what's the maximum size of a row? : Sql server database administration

540


Explain primary key and foreign key constraints?

522


Tell me what is the order in which the sql query is executed?

528


How to access the inserted record of an event?

574


What type of Index will get created after executing the above statement?

643


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3370