SQL Server Mock Test 1

10%

Question 1 of 10

1. Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79.

SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79

SELECT * FROM weather WHERE humidity NOT IN (63 AND 79)

SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79

SELECT * FROM weather WHERE humidity IN (63 to 79)

Question 1 of 10

Question 2 of 10

2. Data types in SQL Server are organized into how many categories?

Question 2 of 10

Question 3 of 10

3. Which of the following is not a DDL command?

ALTER

UPDATE

None of the Mentioned

TRUNCATE

Question 3 of 10

Question 4 of 10

4. ___________ is stored only in the Master database.

None of the mentioned

Catalog View

Complex View

Database-scoped Dynamic Management View

Question 4 of 10

Question 5 of 10

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

REMOVE

DELETE

DROP

TRUNCATE

Question 5 of 10

Question 6 of 10

6. _________ is free database software running free SQL Server technology.

SQL Server Workgroup

SQL Server Express

SQL Server Enterprise

SQL Server Web

Question 6 of 10

Question 7 of 10

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

smallmoney

ntext

date

sql_variant

Question 7 of 10

Question 8 of 10

8. The command to remove rows from a table 'CUSTOMER' is __________________

UPDATE FROM CUSTOMER

REMOVE FROM CUSTOMER

DROP FROM CUSTOMER

DELETE FROM CUSTOMER WHERE

Question 8 of 10

Question 9 of 10

9. 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?

Natural join

Equi-join

Outer join

Cartesian join

Question 9 of 10

Question 10 of 10

10. How many tables may be included with a join?

Three

One

All of the Mentioned

Two

Question 10 of 10