SQL STATEMENTS NEEDED

FROM : SELECT * FROM dictionary;

1. How many indexes are defined on DVSYS.RULE_SET_RULE$ table? (Hint: all views have meaningful name, just search the page)

2. Describe the purpose of V$THREAD . Use V$THREAD to find enable time and las redo time.

3. Describe the purpose of V$BACKUP . Use V$BACKUP to find details about backups.

4. Find V$... view that will tell you what size of the following data types: DOUBLE, FLOAT, BOOLEAN

5. Use V$...stat views to find information about "free memory" and "DB time"

Hint: DB time is system parameter

free memory is SGA (System Global Area) parameter

Start Page )Lab 6-1 x Worksheet Query Builder SELECT FRON DBA ROLES: Query Result x SQL Fetched 50 rows in 0.027 seconds PASSWORD REQUIREDAUTHENTICATION TYPE NO NO NO NO NO NO NO NO ROLE COMMONORACLE MAINTAINED NONE CONNECT 2 RESOURCE 3 DBA AUDIT _ADMI AUDIT_VIEWER 6 SELECT CATALOG ROLE 7 EXECUTE CATALOG ROLE 8 DELETE_CATALOG_ROLE NONE | Line 1 Column 25 Insert Modified Windows: CR/LF Editing