SQL Server Interview Questions
Questions Answers Views Company eMail

Is it possible in sql table to have more than one foreign key?

606

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

660

What are number line correlation administrators will use while working with a subquery?

621

What is view in sql?

557

What purpose does the model database server?

650

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

585

What is a primary key?

534

What is the difference function and stored procedure?

560

How do you trace the traffic hitting a sql server?

614

What is an identity?

563

What do we have to check in database testing?

578

Why would you call update statistics?

576

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

543

How many types of triggers are there?

568

What are page splits?

577


Un-Answered Questions { SQL Server }

Why Master database is required?

596


What are the types of table?

542


How can we rewrite sub-queries into simple select statements or with joins?

519


Explain how many types of relationship?

567


What is constraints and its types?

495






What is the difference between a fill factor of 100 and 0?

524


What do you mean by the term 'normalization'?

662


How many replicas are maintained for each SQL Azure database?

128


How to receive output values from stored procedures?

475


What is the difference between clustered index and primary key?

498


What is join query?

494


How do I find information about the install locations for the various instances running on a computer?

548


Explain about Normalization?

559


I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

573


What are the differences between local and global temporary tables?

546