Sql server multiple choice questions

Home > Multiple choice questions > Sql server MCQs

Sql server part 1 (40 questions) Sql server part 2 (28 questions)
Database (48 questions) Database (20 questions)
SQL server DBA (15 questions) Data Warehousing
Biztalk (15 questions) Placement papers on Database - Set 1
Placement papers on Database - Set 2 Placement papers on Database - Set 3
Placement papers on Database - Set 4 Placement papers on Database - Set 5
Placement papers on SQL Server - Set 1 Placement papers on SQL Server - Set 2
Placement papers on SQL Server - Set 3 Placement papers on SQL Server - Set 4

These tests include sql server topics such as

SQL Server architecture SQL Server backup SQL Server DDL
SQL Server DML SQL Server DCL SQL Server data integrity
SQL Server subqueries SQL Server distributed queries SQL Server cursor
SQL Server replication Structured query language SQL Server DTS
SQL Server functions SQL Server indexes SQL Server joins
SQL Server locks SQL Server Net integration SQL Server optimization
SQL Server replication SQL reporting services SQL service broker
SQL Server stored procedures SQL Server table SQL Server transactions
SQL Server triggers SQL Server views SQL Server XML integration
Latest sql server interview questions and answers

What is a Trace frag? Where do we use it?
Describe how to use Linked Server.
Explain how to send email from database.
Difference between cross join and Full outer join.
Explain the purposes of OPENXML clause sql server stored procedure.
Explain how to store pdf file in sql server.  



Write your comment - Share Knowledge and Experience

Discussion Board
Find 3rd highest salary in sql server

SELECT TOP 1 Salary FROM (
SELECT TOP 3 Salary
FROM Salary_P
ORDER BY Salary DESC) AS sal
ORDER BY Salary ASC

Pankaj Kumar Vishwakarma 02-27-2015 05:16 AM

How to caluculate 2nd highest sal in emp table?...or any table...?

I am writing 5 type of answers ....frends try...send answers...


Satish 10-11-2012 01:49 AM

Which of the following is not an aggregate function in SQL Server 2005?

COUNT IS A SPECIAL FUNCTION...GROUP IS NO FUNCTION IN SQLSERVER2005.

Satish 10-11-2012 01:46 AM

How many clustered indexes can be created on single table?

256

Satish 10-11-2012 01:43 AM

More multiple choice questions

ASP.NET multiple choice questions
VB.NET multiple choice questions
XML multiple choice questions
HTML multiple choice questions
Networking multiple choice questions
Data structure multiple choice questions
JavaScript multiple choice questions
Servlets multiple choice questions
C multiple choice questions
EJB multiple choice questions


Career 12-19-2011 04:40 AM

More sql server multiple choice questions

Which of the following is not an aggregate function in SQL Server 2005?

Min
Group
SUM
COUNT
AVG
MAX


How many clustered indexes can be created on single table?
1
128
256
Upto number of columns in table

Nishi 11-5-2011 05:48 AM

Sql server multiple choice questions

SQL Server tests are fantastic. Questions are good, tricky and simple. Please post more questions on SQL Server 2008

Robo 11-4-2011 11:38 PM

 

 

 
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring