SQL Server Mock Test 1

10%

Question 1 of 10

1. A column of type __________ may contain rows of different data types.

date

sql_variant

ntext

smallmoney

Question 1 of 10

Question 2 of 10

2. @@NESTLEVEL function falls under which of the following category?

Configuration functions

Date and Time Data Functions

Mathematical functions

Cursor functions

Question 2 of 10

Question 3 of 10

3. Which of the following SQL clauses is used to DELETE tuples from a database table?

CLEAR

DELETE

DROP

REMOVE

Question 3 of 10

Question 4 of 10

4. Find all the tuples having a temperature greater than 'Paris'.

SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = 'Paris')

SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = 'Paris'

SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris')

SELECT * FROM weather WHERE temperature > 'Paris' temperature

Question 4 of 10

Question 5 of 10

5. Ctrl+K+K shortcut refers to ___________

Refresh IntelliSense

Enable all bookmarks

Move to the next bookmark

Add or remove a bookmark

Question 5 of 10

Question 6 of 10

6. If you don't specify ASC or DESC after a SQL ORDER BY clause, the following is used by default ______________

None of the mentioned

DESC

There is no default value

ASC

Question 6 of 10

Question 7 of 10

7. Which SQL statement is used to return only different values?

SELECT UNIQUE

SELECT ALL

SELECT DIFFERENT

SELECT DISTINCT

Question 7 of 10

Question 8 of 10

8. What does the ALTER TABLE clause do?

The SQL ALTER TABLE clause is used to delete a database table

The SQL ALTER TABLE clause is used to insert data into database table

THE SQL ALTER TABLE deletes data from database table

The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints

Question 8 of 10

Question 9 of 10

9. Which of the data type has a storage size of 8 bytes?

smallmoney

uniqueidentifier

real

timestamp

Question 9 of 10

Question 10 of 10

10. Codename for SQL Server 2012 is __________

Denali

Hekaton

Katmai

Kilimanjaro

Question 10 of 10