SQL Server Interview Questions
Questions Answers Views Company eMail

What are different types of statements that are supported by sql?

568

Characterize join and name diverse sorts of joins?

501

Why would you use sql agent?

712

What are the different types of backups avaialabe in sql server 2005?

605

What is set nocount on?

477

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

671

What does null mean?

581

What is the difference between truncate and delete commands?

540

What is normalization? What number of normalization shapes are there?

579

What is collation?

694

What are the operating modes in which database mirroring runs?

583

Define self join?

605

Does transparent data encryption provide encryption when transmitting data across the network?

605

What are transactions and its controls?

594

What is the cartesian product of table?

529


Un-Answered Questions { SQL Server }

How can you ensure that the database and sql server based application perform well?

609


Mention the uses of stored procedures.

550


Explain what is the use of custom fields in report?

482


can any body tell me how to know the password of current user in sql server

1554


How can we determine what objects a user-defined function depends upon?

498






Explain data warehousing in sql server?

584


What is the difference between a "where" clause and a "having" clause?

591


When to use Inner join & when to use subquery?

564


What happens if we shrink log file in sql server?

495


What is the dbcc command and why is it used?

550


what are isolation levels? : Sql server database administration

477


What is executereader?

532


what is the system function to get the current user's user id? : Sql server database administration

533


when you create a database how is it stored? : Sql server database administration

473


How many types of cursor type are there?

566