SQL Server Interview Questions
Questions Answers Views Company eMail

What are different types of statement?

705

What is the difference between resultset and resultsetmetadata?

737

What the class forname () does?

736

Which is better statement or preparedstatement?

721

What are the main sources of data?

851

What are the types of resultset?

742

Does a server store data?

694

How do you create a data source?

690

What is the purpose of data source?

754

What is data source object?

749

Are resultset updatable?

737

What is data source in connection string?

684

What is resultset concur_updatable?

787

How do you delete a data source?

783

What are data resources?

696


Un-Answered Questions { SQL Server }

Can sql server 2016 run on windows 7?

713


What is the use of =,==,=== operators?

797


Explain sql delete command?

822


What is bcnf normalization form?

875


You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

781


How efficient you are in oracle and SQL server?

849


How to generate create procedure script on an existing stored procedure?

743


What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

987


What are extended events in sql server?

707


Explain the different types of backups available in sql server? : sql server database administration

709


Where do you find the default Index fill factor and how to change it?

845


Why do you want to join software field as you have done your BE in Electronics?

1923


How to get a list of columns in a view using the "sp_help" stored procedure?

845


Explain transaction isolation levels in sql server?

798


What are date and time data types in ms sql server?

769