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;
You might also like to view...
How can refine a text search by using modifier characters?
What will be an ideal response?
Keeping track of e-mail addresses is much easier when you use the ________ component of Outlook
A) Contacts B) Calendar C) Navigation D) Reading Pane
The Windows Server 2008 tool that utilizes the built-in Reliability Analysis Component (RAC) to provide a trend analysis of your server's stability over time is ________________ Monitor
a. Resource b. Performance c. Server d. Reliability
There are some specialized tools that allow an investigator to dig out certain types of files from unallocated space by identifying the header of that file type and copying all of the information between the head and a valid end of file marker. What is the name for this technique?
a. File imaging b. Data carving c. File reconciliation d. Magic number recovery