You can join tables by using a condition in the ____ clause.
FROM
WHERE
SELECT
JOIN
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?
inner
outer
nested
product
In a(n) ____ join, all rows from both tables are included regardless of whether they match rows from the other table.
normal
full outer
combined
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).
left inner join
left outer join
right inner join
right outer join
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.
AC
SA
AS
IN
The main mechanism for providing access to a database is the ____ command.
PERMIT
ACCESS
GRANT
REVOKE
The correct command to allow user Thompson to delete rows in the CUSTOMER table would be: GRANT ____ ON CUSTOMER TO THOMPSON.
DROP
REMOVE
UPDATE
DELETE
The privilege ____ can be granted to retrieve data.
RETRIEVE
READ
When you specify a foreign key, the table referenced by the foreign key is the ____.
super
sibling
parent
child
The privilege ____ can be granted to change data.
WRITE
ALTER
READ AND WRITE
The privilege ____ can be granted to change the table structure.
MODIFY
To create a stored procedure in Oracle, use the ____ command.
CREATE ROUTINE
CREATE SCRIPT
CREATE PROCEDURE
CREATE EXECUTABLE
A(n) ____ is a procedure that is executed automatically in response to an associated database operation.
cursor
trigger
waypoint
fetchpoint
