1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


SQL Server Interview Questions
Questions Answers Views Company eMail

What is database replicaion? What are the different types of replication you can set up in SQL Server?

Aptech, HCL, Perpetual, SAIC,

5 23545

How to determine the service pack currently installed on SQL Server?

HCL,

4 8898

Can you have a nested transaction?

HCL,

4 10271

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

HCL,

3 11381

What is the system function to get the current user's user id?

HCL,

2 12274

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

HCL,

1 4605

What is the datatype returned by count(*)

247Customer, Asian CERC,

22 32127

how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

 1656

Can I remove the default constraint columns in SQL SERVER?

Value Labs,

5 13487

What is the difference between distinct clause and group by clause?

HHH, Value Labs,

2 15301

can we call stored Procedure in Function in Sql Server 2000 and vice versa.

C3I, eSoft, iPRO Solutions, Wipro,

3 18092

What is an extended Stored Procedure?

 1 5903

What is Trigger?

Misys,

3 9306

What is a view? is View updatable?

IBM, L&T,

17 30449

What is the difference between having and where clause?

 4 9019

Un-Answered Questions { SQL Server }

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

588

Do you know what is difference between index seek vs. Index scan?

507

What is bit data type?

608

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

511

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?

1616




How to insert stored procedure result into temporary table?

566

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

548

How can I create a new template for import ? : sql server management studio

584

What is service broker?

569

What is difference between inner join and join?

526

Can we hide the definition of a stored procedure from a use?

641

What is tempdb database? : SQL Server Architecture

587

Is it possible in sql table to have more than one foreign key?

598

What is public role in sql server?

526

How to insert multiple rows with one insert statement in ms sql server?

574

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