Sql server quiz - sql server quiz online

The SQL server candidates for a position are selected on the basis of their performance in timed online quiz. This online SQL quiz consists of 28 questions trying to assess your knowledge on various aspects of SQL. Take this quiz and measure your performance on the basis of your score & time you took to achieve it.

Online Practice Test > SQL Server quiz

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

Which of the below is the correct syntax for a VIEW?

Both b and d below
CREATE VIEW ViewName AS INSERT ...
CREATE VIEW ViewName AS UPDATE ...
CREATE VIEW ViewName AS SELECT ...


____________ is a set of graphical tools that allows you to transfer data between disparate sources into one or more destinations.

Data Transfer Services
Data Transformation Services
Data Disperse Services
Data transform Services


The _____________ option allows you to connect to another instance of SQL Server running on a different machine

Both b and d below
Link servers
Linking servers
Linked Servers 

Click here to start SQL Server quiz

More Links
Define data, entity, domain and referential integrity.

Latest answer: Data Integrity validates the data before getting stored in the columns of the table. SQL Server supports four type of data integrity............

Describe in brief exporting and importing utility?

Latest answer: The Bulk Copy is a command utility that transfer SQL data to or from a data file.
This utility mostly used to transfer huge data to SQL server from other database...........

Define Distributed Query and Linked Server?

Latest answer: Distributed Query is a query which can retrieve data from multiple data sources including distributed data............... 



Write your comment - Share Knowledge and Experience

Discussion Board
SQL server Quiz - SQL Server Quiz Online

A column with an optimized storage for null values is known as __________ column

spatial
optimum
dense
sparse


SQL server Quiz 05-11-2012 03:02 AM

SQL server Quiz - SQL Server Quiz Online

_______________ is a feature that is used for tracking the changes on a table

Change schema Capture
Change table Capture
Change Data Capture
Change database Capture


SQL server Quiz 05-11-2012 03:02 AM

SQL server Quiz - SQL Server Quiz Online

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


SQL server Quiz 05-11-2012 03:02 AM

SQL server Quiz - SQL Server Quiz Online

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.


SQL server Quiz 05-11-2012 03:02 AM

More online test

Java Web Services Quiz
Javascript Online Test
Business Intelligence
Cognos Online Test
Analysis services Test
Business object Test
OLAP Test
ReportNet Test
Microstrategy Test
Websphere Quiz
Solaris Quiz
SAS test
Weblogic certification test
SQL server Test


Career 12-20-2011 03:51 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