SQL Server Interview Questions
Questions Answers Views Company eMail

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

2 8525

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

5 6546

how to dispaly a particular row details from a given table

2 3903




What is a transaction and what are ACID properties?

3 4869

Explain different isolation levels?

4 7684

What's the maximum size of a row?

4 7781

Explain Active/Active and Active/Passive cluster configurations?

1 3140

Explain the architecture of SQL Server?

HP, Oracle, ABC,

2 33790




What is lock escalation?

1 5434

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

9 13017

Explain the storage models of OLAP?

1 5653

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

Accenture,

1228

What are constraints? Explain different types of constraints?

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

26 118553

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

2 7988

what operator performs pattern matching?

2 8804


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How much memory that we are using in Logshipping Concept?

775


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

928


Scalability, Availability, Integration with internet, etc.)?

1740


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

875


on line cluster can we make if yes tell me the procedure

911






Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1418


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

935


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.

2751


What is Lock table in SQL?

354


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

947


If the job running very slow what is the action you do

780


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

911


Delete duplicate rows without using rowid.

267


If we delete pack Spec what will be the status of pack Body ?

252


what are the Prerequisites for Replication?

8748