Sql server multiple choice questions

 

Sql server multiple choice questions

<<Previous   Next>>

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)

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.  

<<Previous   Next>>

Write your comment - Share Knowledge and Experience

Discussion Board
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

 

 

 
Interview questions
 
Home | Want a Job? Submit Key Skills | Employer login | My key skills | About us | Sitemap | Contact us