SQL Server Interview Questions
Questions Answers Views Company eMail

Which command executes the contents of a specified file?

ABC, InfoMedia,

2 4921

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

TCS,

3 7565

Which system tables contain information on privileges granted and privileges obtained

1 5259




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

2 5038

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

7 9490

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

2 7294

What is the use of CASCADE CONSTRAINTS?

3 7880

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,

974




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

6 5509

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

ivan, Getit,

1 3336

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

Temenos, Patni, Wipro, SAP Labs, NetCore,

34 37689

how to find nth highest salary

IBM, Oracle, Cognizant, NexGen,

103 125291

About types of indexes in SQL server ?

Cognizant,

2 5097

Difference between writing SQL query and stored procedure ?

TCS, Infosys, Cognizant, Veritas,

15 62801

About DTS usage ?

Wipro, Cognizant,

2 5274


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How to trouble shoot if unable to connect SQL Server

810


Tell about MOM Tool(Microsoft Operator Manager)?

719


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

2779


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

701


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.

1388






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

432


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

872


How do use Having,Group by,Group function in SQL?

707


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1316


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

980


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1621


If user is owning any SQL Objects, can we drop that user

884


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

877


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1180


whats new about truncate in sql server 2008?

1345