SQL Server Interview Questions
Questions Answers Views Company eMail

Equi join and non equi join is possible with sql server?

575

What are the different acid properties?

708

When multiple after triggers are attached to sql table, how to control the order of execution?

623

How to find out the list schema name and table name for the database?

624

What is serializable?

747

What is save transaction and save point?

708

Explain transaction isolation levels in sql server?

636

Explain multiserver query

629

How to remove duplicate rows from table?

711

What is a hint?

656

What is global temp table?

671

What is nonclustered index with included columns ?

623

What is service broker?

684

What is the difference between varchar and nvarchar datatypes?

657

How can I track the changes or identify the latest insert-update-delete from a table?

624


Un-Answered Questions { SQL Server }

How to write a query with an inner join in ms sql server?

646


What is cursors? And what are the different types of cursor?

648


Do you know the isolation level that sql server support?

607


What is function of CUBE ?

685


What is a transact-sql statement batch in ms sql server?

579






What happens on checkpoint?

687


How to list all triggers in the database with sys.triggers in ms sql server?

633


What is a not null constraint?

675


Can you roll back the ddl statement in a trigger?

598


What is difference statement and preparedstatement?

632


What is a matrix in ssrs?

105


What is sub-query in sql server?

764


What does truncate do?

624


What are the difference between clustered and a non-clustered index?

674


How to use subqueries in the from clause in ms sql server?

664