C192 Practice Test - Advanced SQL PDF

Preview

Summary

Download C192 Practice Test - Advanced SQL PDF

Description

C192 Practice Test - Advanced SQL Multiple Choice Identify the choice that best completes the statement or answers the question. ____

1. You can join tables by using a condition in the ____ clause. a. FROM c. SELECT b. WHERE d. JOIN

____

2. Which of the following joins compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause? a. inner c. nested b. outer d. product

____

3. In a(n) ____ join, all rows from both tables are included regardless of whether they match rows from the other table. a. normal c. full outer b. inner d. combined

____

4. In a ____, all rows from the table on the left (the table listed first in the query) will be included regardless of whether they match rows from the table on the right (the table listed second in the query). a. left inner join c. right inner join b. left outer join d. right outer join

____

5. In a ____, all rows from the table on the right will be included regardless of whether they match rows from the table on the left. a. left inner join c. right outer join b. left outer join d. right inner join

____

6. The CREATE VIEW command includes the words CREATE VIEW, followed by the name of the view, the word ____, and then a query. a. AC c. AS b. SA d. IN

____

7. The main mechanism for providing access to a database is the ____ command. a. PERMIT c. GRANT b. ACCESS d. REVOKE

____

8. The correct command to allow user Thompson to delete rows in the CUSTOMER table would be: GRANT ____ ON CUSTOMER TO THOMPSON. a. DROP c. UPDATE b. REMOVE d. DELETE

____

9. The privilege ____ can be granted to retrieve data. a. SELECT c. RETRIEVE b. UPDATE d. READ

____ 10. When you specify a foreign key, the table referenced by the foreign key is the ____. a. super c. parent b. sibling d. child ____ 11. The privilege ____ can be granted to change data. a. WRITE c. ALTER

b. UPDATE

d. READ AND WRITE

____ 12. The privilege ____ can be granted to change the table structure. a. WRITE c. ALTER b. UPDATE d. MODIFY ____ 13. To create a stored procedure in Oracle, use the ____ command. a. CREATE ROUTINE c. CREATE PROCEDURE b. CREATE SCRIPT d. CREATE EXECUTABLE ____ 14. A(n) ____ is a procedure that is executed automatically in response to an associated database operation. a. cursor c. waypoint b. trigger d. fetchpoint

C192 Practice Test - Advanced SQL Answer Section MULTIPLE CHOICE 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14.

B A C B C C C D A C B C C B...