SQL Server Interview Questions
Questions Answers Views Company eMail

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

2 8324

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

5 6303

how to dispaly a particular row details from a given table

2 3732




What is a transaction and what are ACID properties?

3 4717

Explain different isolation levels?

4 7435

What's the maximum size of a row?

4 7534

Explain Active/Active and Active/Passive cluster configurations?

1 3007

Explain the architecture of SQL Server?

HP, Oracle, ABC,

2 33313




What is lock escalation?

1 5292

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

9 12688

Explain the storage models of OLAP?

1 5360

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

Accenture,

1124

What are constraints? Explain different types of constraints?

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

26 116676

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

2 7782

what operator performs pattern matching?

2 8511


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How do you Implement SSIS Packages in your Project?

809


what is difference between view and Dip.

1165


what exactly sql injuction.how to overcome.....

1285


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1016


what is isolation level at dead lock?

988






how can you attach more than 20 ldf files in sql server

801


what is checksum in sql server.........???

357


1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

1273


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

2649


how to use DTS package in 2000,2005,2008 in sql server

756


last function used in MS Access to convert sql what function will use in sql

825


how to do partition in sqlserver

1279


How we create SQL Server 2005 Reporting Services ? Give me Sample

887


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

871


how to overcome kernel isssues

446