SQL Server Interview Questions
Questions Answers Views Company eMail

Which command executes the contents of a specified file?

ABC, InfoMedia,

2 5028

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

TCS,

3 7799

Which system tables contain information on privileges granted and privileges obtained

1 5327




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

2 5103

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

7 9613

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

2 7369

What is the use of CASCADE CONSTRAINTS?

3 8013

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,

1026




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

6 5620

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

ivan, Getit,

1 3388

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 38691

how to find nth highest salary

IBM, Oracle, Cognizant, NexGen,

103 126563

About types of indexes in SQL server ?

Cognizant,

2 5172

Difference between writing SQL query and stored procedure ?

TCS, Infosys, Cognizant, Veritas,

15 63374

About DTS usage ?

Wipro, Cognizant,

2 5358


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

what is difference between view and Dip.

1283


How you trouble shoot when any job fails

793


If a stored procedure is taking a table data type, how it looks?

4806


What is RMS migrations?

1047


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

917






sql database suspect We have a sql database that is showing as suspect. How can we recover?

799


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

263


How much memory that we are using in Logshipping Concept?

786


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

961


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1324


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

938


where the connection string store in the database

910


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

971


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.

1652


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

749