SQL Server interview questions – page 2

What is the difference between Varchar and Varchar2?

How do you optimize stored procedures ?

How to remove duplicate records from a table?

What is the difference between the full, simple and bulk log recovery models?

What is different between int and bint?

Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employye table and department table with employee having department no.

How functional dependency is related to database table design?

What is SQL*Loader? Difference between

What is a dirty page and dirty report?

What is merging?

What is the pivot operator in MS SQL Server2005? What is the use of it and how do we use it

How many types of system privileges are there, Can we add or delete privileges?

What are DTS subroutines? What is their use and How do you write them?

What is the Disadvantage of StoredProcedure?

Explain open SQL vs native SQL?

When do you get constraint violation? What are the types of constraints?

Difference between "ORACLE" and "MICROSOFT ACCESS" databases.

I was asked in an interview..."Suppose u have a field with UNIQUE KEY. can u leave two or more cells NULL in SQL Server 2005...If Yes then Why...if NOT then Why...

What is the use of Analyzing the tables?

Give some examples of Analytical functions.

How to create a database link?

Difference - Primary Key and Aggregate Key

Which of the following modules within SQL Server 2005 cannot be signed with a digital signature?

What are data objects?

Where does Profiler store its temporary data in SQL Server 2005?

What is Extended Stored Procedure in SQL Server 2000?

What does this return? select (1324 & 1024)

What is the difference between Inner join and full outer join in terms of the Number of rows return

How to get the list of tables in Sybase?

What is the difference between Inner join and full outer join in terms of the Number of rows returned?