SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

Can you name a few encryption mechanisms in sql server?

906

What are subqueries in sql server?

1074

What is the purpose of update statistics and scope_identity() function?

1062

what do you understand by change data capture?

951

Mention the different types of triggers?

1029

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

1111

Explain the properties of subqueries in sql server?

1033

How do you start single user mode in clustered installations?

910

What are the differences between sql server and mysql.

1045

Mention the different types of replication in sql server.

973

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

933

What do you understand by triggers?

872

mention different types of relationships in the dbms?

976

What is the command used to check locks in microsoft sql server?

987

What do you understand by recursive stored procedure?

885

Un-Answered Questions { SQL Server }

Name few endpoints exposed by ssrs 2012?

349

List out different types of normalizations in sql server and explain each of them?

897

If a stored procedure is taking a table data type, how it looks?

6366

What is a unique index?

891

What is the maximum size per database for sql server express?

988

What happens if null values are involved in datetime operations?

919

How many types of keys are there?

979

how you can list all the tables in a database?

978

Does any body please help me what question's have asked for SSRS in the interview?

2102

What are different types of raid levels?

1086

What is a cursor, index in sql?

1031

What is difference between group by and having?

919

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

908

What is cached report?

139

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2891

For More Un-Answered { SQL Server } Questions Click Here