SQLPLUS

16. Which data dictionary view could you query to display the names of tables you have access to?

a. USER_VIEWS

b. USER_TABLES

c. ALL_OBJECTS

d. USER_OBJECTS

17. Which script will you execute to create new user DAVE and give him the ability to connect to the

database and the ability to create tables, sequences, and procedures?

a. CREATE USER dave IDENTIFIED BY dave18;

GRANT create table, create sequence, create procedure TO dave;

b. CREATE USER dave IDENTIFIED BY dave18;

GRANT create session, create table, create sequence, create procedure TO dave;

c. CREATE dave IDENTIFIED BY dave18;

GRANT create connect, table, sequence, procedure TO dave;

d. CREATE OR REPLACE USER dave IDENTIFIED BY dave18;

GRANT create session, table, sequence, procedure;

18. What is the syntax for removing a primary key constraint and all its dependent constraints?

a. ALTER TABLE table

DROP PRIMARY KEY CASCADE;

b. ALTER TABLE table

REMOVE CONSTRAINT PRIMARY KEY CASCADE;

c. ALTER TABLE table

DISABLE CONSTRAINT PRIMARY KEY CASCADE;

d. A primary key constraint cannot be removed.

19. Which action will cause an automatic rollback?

a. a GRANT command

b. a CREATE command

c. the system crashes

d. exiting from SQL*Plus without first issuing a COMMIT command

20. Which data dictionary view would you query to list only the views you own?

a. ALL_VIEWS

b. USER_VIEWS

c. ALL_OBJECTS

d. USER_OBJECTS