SQL Server Online Test

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:


The Microsoft Access wildcards are ____ and ____ .


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


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


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


The HAVING clause does which of the following?


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


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


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


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


The command to eliminate a table from a database is:


A view is which of the following?


The wildcard in a WHERE clause is useful when?


The SQL WHERE clause:


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


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


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


What mode of authentication does SQL Server NOT provide?


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


What will be the output of the following statement?

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


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


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


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


What will be the result of the following statement?

SELECT ROUND(123.89, 0, 2)


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?


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

1909 days 3 hours 8 minutes ago

Ankit

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

1909 days 3 hours 9 minutes ago

13 Followers
Tests: 3

Your Facebook Friends on WizIQ

More Tests By Author

C#.Net
20 Questions | 2028 Attempts

C#.Net Test
6 Questions | 1856 Attempts