SQL Server Interview Questions
Questions Answers Views Company eMail

Is Sql non procedural query language?

Verifone,

1 868

Write a SQL command to insert and update only a particular field?

ADITI,

593

How efficient you are in oracle and SQL server?

CGI,

603

What are the steps to follow to configure SQL*Net?

Tech Mahindra,

539

What do you understand by SQL*Net?

Tech Mahindra,

586

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

IBM,

575

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

IBM,

548

When to use Inner join & when to use subquery?

IBM,

558

how many type of indexing in database?

IBM,

549

Difference between rowid and rownum in SQL?

Virtusa,

1 980

How can you swap values between two rows in a table using single- SQL statement?

Tavant Technologies, Virtusa,

1 1761

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

Amazon,

536

what is the difference between Delete and Truncate command in SQL

BirlaSoft,

598

What Is Rdbms?

Accenture,

642

How can you tell if a database object is invalid?

MCN Solutions,

587


Un-Answered Questions { SQL Server }

What are system databases into sql server (2005/2008)?

556


What does it mean to manipulate data?

526


Explain trigger classes i.e. Instead of and after trigger?

455


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

614


What is the recovery model?

526






Explain candidate key, alternate key, and composite key?

551


If a stored procedure is taking a table data type, how it looks?

5759


How do you implement session management in SQL Server mode?

525


Explain about builtinadministrator?

563


whats the maximum size of view state??

1681


What is table-valued sub query?

543


How to use group functions in the select clause in ms sql server?

508


What are commit and rollback in sql?

533


Describe different Processing Modes offered by SSRS?

161


Explain about system database?

554