SQLPLUS 16. Which data dictionary view could you query to display the names of t

Question

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

Explanation / Answer

16 . select table_name from user_tables; Therfore b.

17.

18.

c. ALTER TABLE table  

DISABLE CONSTRAINT PRIMARY KEY CASCADE;  

19.

c. the system crashes  

20. b. USER_VIEWS  

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.