C192 Advanced SQL

You can join tables by using a condition in the ____ clause.

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?

In a(n) ____ join, all rows from both tables are included regardless of whether they match rows from the other table.

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).

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.

The CREATE VIEW command includes the words CREATE VIEW, followed by the name of the view, the word ____, and then a query.

The main mechanism for providing access to a database is the ____ command.

The correct command to allow user Thompson to delete rows in the CUSTOMER table would be: GRANT ____ ON CUSTOMER TO THOMPSON.

The privilege ____ can be granted to retrieve data.

When you specify a foreign key, the table referenced by the foreign key is the ____.

The privilege ____ can be granted to change data.

The privilege ____ can be granted to change the table structure.

To create a stored procedure in Oracle, use the ____ command.

A(n) ____ is a procedure that is executed automatically in response to an associated database operation.