SQL Server Interview Questions
Questions Answers Views Company eMail

What is data source document?

551

Can two tables share the same primary key?

522

Can a table have 2 foreign keys?

511

What is meant by datasource?

527

How do I make a resultset scrollable?

528

Is resultset an interface?

562

What is the meaning of resultset type_scroll_insensitive?

571

What is difference between createstatement and preparedstatement?

567

Which is faster statement or preparedstatement?

546

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

529

What is the return type of executeupdate ()?

533

What is create statement?

541

What program is used to store the data source file?

515

What is a data source file?

505

What is difference statement and preparedstatement?

555


Un-Answered Questions { SQL Server }

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

586


What is cached report?

106


List out what other servers you can use with ssrs?

93


What are the hotfixes and patches in sql server?

552


List types of tables in SQL Azure?

104






How to how to convert numeric expression data types using the convert() function??

556


Explain about SQLOS?

596


What is the syntax to execute the sys.dm_db_missing_index_details?

590


Explain trigger and trigger types?

563


How to execute a stored procedure in ms sql server?

560


Define right outer join in sql server joins?

530


What is used to replicate sessions between instances in coldfusion clusters?

590


How do you delete a data source?

566


Explain Normalization and DE normalization

613


What will be the maximum number of indexes per table?

543