SQL Server Practice Test 2

1. To delete a database ___________ command is used.

2. Which of the following is the simplest ranking function?

3. Aggregate functions are functions that take a ___________ as input and return a single value.

4. Point out the wrong statement.

5. Point out the wrong statement.

6. Select * from employee where salary>10000 and dept_id=101;
Which of the following fields are displayed as output?

7. The ________________ is essentially used to search for patterns in target string.

8. We can test for the nonexistence of tuples in a subquery by using the __________ construct.

9. Which is the duplication of computer operations and routine backups to combat any unforeseen problems?

10. The query given below will give an error. Which one of the following has to be replaced to get the desired output?

Select ID, name from 1_Order where instructor=1;