Sql server test questions - Sql server online test

Online tests assess the depth of your SQL knowledge. Taking SQL online practice test helps you judge your database proficiency. The online SQL test here comprises of theoritical and practical questions on SQL to find out your current status and help you prepare for the job interviews, cerrtification tests and other written tests. This is a set of 40 questions on SQL Server with some sample objective questions.

Online Practice Test > SQL Server online test

Click here to start SQL Server quiz/test
Here are few sample SQL Server  test/quiz questions

Which of the following statements is/are false for Declarative Management Framework (DMF) in sql server 2008?

System for managing the instances of SQL Server 2008
SQL Server does not enforce to define the policies by using Management Studio
Both b and d
A policy can be designed for allowing the usage of unauthorized applications


What is the purpose of MERGE in sql server 2008?

Merge statement allows a single statement for INSERT, DELETE and UPDATE a row that depends on a condition
Merge statement allows multiple statements for INSERT, DELETE and UPDATE a row that depends on a condition
Merge statement allows a single statement for INSERT, DELETE and UPDATE a row that is independant on a condition
Merge statement allows multiple statements for INSERT, DELETE and UPDATE a row that is independant on a condition


Which of the following statements is/are true for SQL server?

SQL Server has Logical Architecture and Physical Architecture.
Both a and c
SQL Server is compatible with structured query language and has rich support for XML
SQL Server is a DBMS, a complete database. 

Click here to start SQL Server quiz/test  

More Links
Describe in brief SQL Server monitoring ways.

Latest answer: SQL Profiler is a tool that stores events from the server. SQL Profiler saves the events in the trace file............

Define transaction and transaction isolation levels.

Latest answer: A transaction is a set of operations that works as a single unit. The ransactions can be categorized into explicit, autocommit, and implicit..........

SQL Server Optimization Tips

Latest answer: Restricting query result means return of required rows instead of all rows of the table. This helps in reducing network traffic............ 



Write your comment - Share Knowledge and Experience

Discussion Board
SQL server Test Questions - SQL Server Online Test

CPUs can dynamically be added to a running system, by using ____________ feature

Cold Add CPU
Hot Add CPU
Dynamic add CPU
Passive add CPU


SQL server Test Questions 05-11-2012 03:00 AM

SQL server Test Questions - SQL Server Online Test

Which of the following statements is/are false for Declarative Management Framework (DMF) in sql server 2008?

System for managing the instances of SQL Server 2008
SQL Server does not enforce to define the policies by using Management Studio
Both b and d
A policy can be designed for allowing the usage of unauthorized applications


SQL server Test Questions 05-11-2012 02:48 AM

SQL server Test Questions - SQL Server Online Test

Which of the following rules below are true to use the ROWGUIDCOL property to define a globally unique identifier column?

A table can have only one ROWGUIDCOL column
A ROWGUIDCOL column must not be defined by using the uniqueidentifier data type.
Both a and c
NEWID function to generate a globally unique value.


SQL server Test Questions 05-11-2012 02:48 AM

SQL server Test Questions - SQL Server Online Test

Which of the following statements is/are false for Extended events in sql server 2008?

Enhanced event handling system in SQL Server
Both b and c below
Used for problem identification or problem trouble shooting
An architecture that is not very scalable, highly configurable


SQL server Test Questions 05-11-2012 02:48 AM

More online test

.NET test
VB.NET test
ADO.NET test
C#.NET test
C#.NET practice test
Csharp.NET quiz
Sharepoint test
Sharepoint quiz
Java Programming Test
Java Online Exams
Java online quizzes
Java Mock Test
EJB Quiz
JDBC Quiz
Java Applet Quiz


Career 12-20-2011 03:50 AM

 


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