SQLPLUS

1. For which column would you create an index?

a. a column that is small

b. a column that is updated frequently

c. a column containing a wide range of values

d. a column with a small number of null values

2. You issue this command:

GRANT update ON inventory TO joe

WITH GRANT OPTION;

Which task has been accomplished?

a. Only a system privilege was given to user JOE.

b. Only an object privilege was given to user JOE.

c. User JOE was granted all privileges on the object.

d. Both an object privilege and a system privilege were given to user JOE.

3. With which option could a view be created to prevent a user from updating rows in the base table

that are not accessible to the view?

a. group function

b. GROUP BY clause

c. DISTINCT command

d. WITH CHECK OPTION

4. Evaluate this SQL statement:

SELECT *

FROM USER_CATALOG;

What might be displayed by this statement?

a. names of all the views that you own

b. names of all the views you can query

c. names of all the views in the database

d. names of all the data dictionary views

5. In which two statements would you typically use the CURRVAL pseudo column? (Choose two.)

a. SELECT list of a view

b. SET clause of an UPDATE statement

c. subquery in an UPDATE statement

d. VALUES clause of an INSERT statement

e. SELECT statement with the HAVING clause