Write SQL statements to do the following:

(1) List the name and granted roles of the current user;
(2) List name and type of all objects owned by the current user;
(3) List table name and the tablespace name to which the table is assigned of all
tables owned by the current user;
(4) List the next value of the sequence Emp_Seq.

(1) SELECT USERNAME, GRANTED_ROLE
FROM USER_ROLE_PRIVS;
(2) SELECT OBJECT_NAME, OBJECT_TYPE
FROM USER_OBJECTS;
(3) SELECT TABLE_NAME, TABLSPACE_NAME
FROM USER_TABLES;
(4) SELECT Emp_Seq.NEXTVAL
FROM SYS.DUAL;

Computer Science & Information Technology

You might also like to view...

Which of the following network component interfaces with a Telco T1 line at the demarcation point?

A. ISDN adapter B. Modem C. NIC D. CSU / DSU

Computer Science & Information Technology

The normalization process involves converting tables into various types of ____.

A. tuples B. relations C. normal forms D. diagrams

Computer Science & Information Technology