SQL Server Practice Test 1

1. Which of the following shortcut is used for displaying error list?

Ctrl + \

Ctrl + !

Ctrl + |

Ctrl + /

2. How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen'

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

CLEAR

REMOVE

DELETE

DROP

4. What is the meaning of LIKE '%0%0%'?

Feature has more than two 0's

Feature has two 0's in it, at any position

Feature begins with two 0's

Feature ends with two 0's

5. Which of the following statements is true concerning subqueries?

Involves the use of an inner and outer query

All of the mentioned

Does not start with the word SELECT

Cannot return the same result as a query that is not a subquery

6. Which SQL keyword is used to retrieve a maximum value?

MAX

MOST

TOP

UPPER

7. What is the purpose of the SQL AS clause?

The AS SQL clause is used to change the name of a column in the result set or to assign a name to a derived column

All of the mentioned

The AS clause is used with the JOIN clause only

The AS clause defines a search condition

8. With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" ends with an "a"?

SELECT * FROM Persons WHERE FirstName='a'

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

SELECT * FROM Persons WHERE FirstName LIKE '%a'

SELECT * FROM Persons WHERE FirstName='%a%'

9. The UPDATE SQL clause can _____________

delete more than one row at a time

delete only one row at a time

update more than one row at a time

update only one row at a time

10. __________ are used for supporting encryption, decryption, digital signing and their validation.

Configuration functions

Cursor functions

Cryptographic functions

None of the mentioned