SQL Server Practice Test 1

1. Which was the first version of SQL Server to introduce in-memory capability?

SQL Server 2014

SQL Server 2008

SQL Server 2005

SQL Server 2012

2. DecryptByKeyAutoCert is ________________ type function.

Asymmetric Encryption and decryption

Encryption Hashing

Symmetric Encryption and decryption

Symmetric decryption with Automatic key handling

3. 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 LIKE '%a'

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

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

SELECT * FROM Persons WHERE FirstName='a'

4. You can delete a view with ___________ command.

REMOVE VIEW

DELETE VIEW

TRUNCATE VIEW

DROP VIEW

5. Which of the following is a large object data type?

nvarchar(max)

varchar(max)

varbinary(max)

image

6. The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID?

Equi-join

Cartesian join

Natural join

Outer join

7. Which TCL command undo all the updates performed by the SQL in the transaction?

TRUNCATE

DELETE

COMMIT

ROLLBACK

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

The AS clause defines a search condition

All of the mentioned

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

The AS clause is used with the JOIN clause only

9. ___________removes all rows from a table without logging the individual row deletions.

DELETE

REMOVE

DROP

TRUNCATE

10. Which of the following tool is used for designing schema of the database in SSMS?

Table designer

Query Designer

Query Editor

Database Diagrams