SQL Server Interview Questions
Questions Answers Views Company eMail

Which command executes the contents of a specified file?

ABC, InfoMedia,

2 4773

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

TCS,

3 7199

Which system tables contain information on privileges granted and privileges obtained

1 5145




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

2 4910

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

7 9300

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

2 7160

What is the use of CASCADE CONSTRAINTS?

3 7743

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,

911




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

6 5364

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

ivan, Getit,

1 3252

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 36364

how to find nth highest salary

IBM, Oracle, Cognizant, NexGen,

103 123460

About types of indexes in SQL server ?

Cognizant,

2 4973

Difference between writing SQL query and stored procedure ?

TCS, Infosys, Cognizant, Veritas,

15 61833

About DTS usage ?

Wipro, Cognizant,

2 5099


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

plss anybody specify tha constrian management system in dbms

788


whats new about truncate in sql server 2008?

1281


Which is the best place or learning center for MS SQL?????In Bangladesh?????

848


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

813


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

683






what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

4722


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.

2649


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?

835


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

337


application server is slow what may be the problem

1065


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

1271


How we create SQL Server 2005 Reporting Services ? Give me Sample

887


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

682


OPTIMIZATION OF SP,CURSOR,TRIGGERS

1479


How to restore performance issues and how to check?

813