SQL Server Online Test

Which of the following is a reserved keyword in SQL Server 2008 and therefore cannot be used as an object name or as a column name in a table unless delimited?


What will be the result of the following statement?

SELECT ROUND(123.89, 0, 2)


What's the maximum length that can be specified in an NVARCHAR data type in SQL Server 2008?


Which of the following is NOT true about the TRUNCATE TABLE command?


Which of the following is NOT true about the SMALLDATETIME data type?


What will be the output of the following statement?

SELECT CHARINDEX('is','Missississippi', -1)


Using SQL Server 2008, which of the following symbols is used to indicate parameters in stored procedures?


What mode of authentication does SQL Server NOT provide?


Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?


You can add a row using SQL in a database with which of the following?


The command to remove rows from a table 'CUSTOMER' is:


The SQL WHERE clause:


The wildcard in a WHERE clause is useful when?


A view is which of the following?


The command to eliminate a table from a database is:


SQL data definition commands make up a(n) ________ .


The SQL keyword(s) ________ is used with wildcards.


The result of a SQL SELECT statement is a(n) ________ .


Which of the following are the five built-in functions provided by SQL?


The HAVING clause does which of the following?


To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.


Which of the following do you need to consider when you make a table in SQL?


When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):


The Microsoft Access wildcards are ____ and ____ .


Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';


To define what columns should be displayed in an SQL SELECT statement:


SQL can be used to:


The SQL statement that queries or reads data from a table is ________ .


A subquery in an SQL SELECT statement:


A ________ is a stored program that is attached to a table or a view.









































































Description:

How well do you know SQL Server? Find out here by taking this free test assessment.

You will be given a series of SQL Server related questions that are randomly selected. Since the questions are randomly selected, you will receive a different set of questions each time you start a test. At the end of the last question, you will be given your score. You can then start a new test session if you like.

Keep coming back because new questions are added every now and then.

Good Luck!!!

Discussion

Ankit

The maximum length of nvarchar is 8000 in Sql Server 2008

2127 days 7 hours 7 minutes ago

Ankit

the date and datetime are also reserved keywords in sql server.(first question).

2127 days 7 hours 7 minutes ago

13 Followers
Tests: 3

Your Facebook Friends on WizIQ

More Tests By Author

C#.Net
20 Questions | 2032 Attempts

C#.Net Test
6 Questions | 1857 Attempts