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

If there is failure during updation of certain rows, what will be the state?

2 11015

What is the difference between Userdefined function and stored procedure? Explain and give the example also

5 10821

how to dispaly a particular row details from a given table

2 6313

What is a transaction and what are ACID properties?

3 7946

Explain different isolation levels?

4 11080

What's the maximum size of a row?

IBM,

4 11962

Explain Active/Active and Active/Passive cluster configurations?

1 5032

Explain the architecture of SQL Server?

ABC, HP, Oracle,

2 37512

What is lock escalation?

1 7219

What's the difference between DELETE TABLE and TRUNCATE TABLE commands?

9 19472

Explain the storage models of OLAP?

1 7461

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

Accenture,

1 2416

What are constraints? Explain different types of constraints?

Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro,

26 140606

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

2 10761

what operator performs pattern matching?

2 11808

Un-Answered Questions { SQL Server }

How raid can influence database performance?

1093

How can we solve concurrency problems?

1110

Why we use the openxml clause?

1059

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1200

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2285

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

1134

How to connect php with different port numbers?

1159

How to provide default values to function parameters?

1235

How to enter binary string literals in ms sql server?

1231

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1015

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

1277

What are wait types?

1219

What is the primary use of the model database?

1141

What is an indexed view?

1013

Can one drop a column from a table?

1075

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