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


SQL Server Interview Questions
Questions Answers Views Company eMail

Which command executes the contents of a specified file?

ABC, InfoMedia,

2 6906

Which command displays the SQL command in the SQL buffer, and then executes it?

TCS,

3 17251

Which system tables contain information on privileges granted and privileges obtained

 1 6381

Which system table contains information on constraints on all the tables created?

 2 6350

what command is used to create a table by copying the structure of another table?

 7 12589

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

 2 8643

What is the use of CASCADE CONSTRAINTS?

 3 9845

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

Crown Solutions,

1563

What are the type of Indexes? which one is best, why?

 6 7909

How to work on DTS?what is the main requirement?

Getit, ivan,

1 4518

I have student marks in a student table. I need second highest mark .Then what will the query for this?

NetCore, Patni, SAP Labs, Temenos, Wipro,

37 59160

how to find nth highest salary

Cognizant, IBM, NexGen, Oracle,

103 158009

About types of indexes in SQL server ?

Cognizant,

2 6703

Difference between writing SQL query and stored procedure ?

Cognizant, Infosys, TCS, Veritas,

15 71653

About DTS usage ?

Cognizant, Wipro,

2 7056

Un-Answered Questions { SQL Server }

What is table level trigger?

568

What is thr feature of change data capture?

496

What is serializable?

652

Define Joins?

598

What are the advantages of partitioning?

627




Where are sql server user names and passwords stored in sql server?

517

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

578

How do I view a script in sql server?

523

How will you make an attribute not process? : sql server analysis services, ssas

570

Can coalesce return null?

526

What are the methods used to protect against sql injection attack?

554

What happens if null values are involved in bitwise operations?

591

What is clr ddl trigger?

537

Does partitioning improve performance sql server?

477

Does an index slow down updates on indexed columns?

569

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