SQL Server Interview Questions
Questions Answers Views Company eMail

What is data source document?

780

Can two tables share the same primary key?

697

Can a table have 2 foreign keys?

687

What is meant by datasource?

697

How do I make a resultset scrollable?

728

Is resultset an interface?

736

What is the meaning of resultset type_scroll_insensitive?

745

What is difference between createstatement and preparedstatement?

819

Which is faster statement or preparedstatement?

727

What is the difference between executequery () and executeupdate ()?

732

What is the return type of executeupdate ()?

708

What is create statement?

690

What program is used to store the data source file?

700

What is a data source file?

716

What is difference statement and preparedstatement?

738


Un-Answered Questions { SQL Server }

Explain how you can configure a running aggregate in SSRS?

131


Explain the steps to create and execute a user-defined function in the sql server?

728


Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

752


What is ddl and dml commands?

676


how you can get the list of largest tables in a database? : Sql server administration

742


Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

767


We need to perform what steps in the following order to work with a cursor?

925


What is a field name?

724


What is the difference between locking and multi-versioning?

743


How do I setup a local sql server database?

723


What happens if you delete a table that is used by a view?

779


What are the differences between having and where clause.

730


What is a transact-sql statement?

728


what is a deadlock? : Sql server database administration

706


How to defragment indexes with alter index ... Reorganize?

800