SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Oracle Views
Start Test
Study First
Subjects
:
oracle
,
it-skills
Instructions:
Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can
study here
.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.
This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. Description table for privilege (auditing option) type codes. Maps privilege (auditing option) type numbers to type names
SESSION_ROLES
TABLE_PRIVILEGE_MAP
ALL_SEQUENCES
NLS_INSTANCE_PARAMETERS
2. Columns of user's tables - views and clusters
ALL_UPDATABLE_COLUMNS
ALL_TAB_COLUMNS
ALL_TRIGGERS
ALL_OBJECT_TABLES
3. Grants on objects for which the user is the grantor - grantee - owner - or an enabled role or PUBLIC is the grantee
DBA_DB_LINKS
SYSTEM_PRIVILEGE_MAP
TABLE_PRIVILEGES
ROLE_TAB_PRIVS
4. Descriptions of indexes on tables accessible to the user
ALL_INDEXES
PRODUCT_COMPONENT_VERSION
DBA_TS_QUOTAS
ALL_COL_COMMENTS
5. Description table for privilege type codes. Maps privilege type numbers to type names
ALL_LOBS
DBA_TRIGGERS
ALL_TAB_COMMENTS
SYSTEM_PRIVILEGE_MAP
6. Column usage in user's triggers or in triggers on user's tables
ALL_OBJECTS
ALL_TRIGGER_COLS
ALL_TAB_COLUMNS
SESSION_ROLES
7. Description of columns in data dictionary tables and views
ALL_CONS_COLUMNS
ALL_TRIGGERS
ALL_VIEWS
DICT_COLUMNS
8. All triggers in the database
DBA_TRIGGERS
ALL_OBJECT_TABLES
ALL_TAB_COL_STATISTICS
ALL_TYPES
9. Information about accessible columns in constraint definitions
DBA_ROLES
ALL_CONSTRAINTS
ALL_TYPES
ALL_CONS_COLUMNS
10. All synonyms accessible to the user
NLS_DATABASE_PARAMETERS
ALL_CONSTRAINTS
ALL_SYNONYMS
DICT_COLUMNS
11. Current errors on all stored objects in the database
ALL_ARGUMENTS
NLS_INSTANCE_PARAMETERS
DBA_TRIGGERS
DBA_ERRORS
12. Constraint definitions on accessible tables
ALL_TAB_COLUMNS
ALL_CONS_COLUMNS
ALL_CONSTRAINTS
SYSTEM_PRIVILEGE_MAP
13. Current source on stored objects that user is allowed to create
ALL_SOURCE
DBA_TAB_PRIVS
ALL_UPDATABLE_COLUMNS
ALL_CONS_COLUMNS
14. Current errors on stored objects that user is allowed to create
ALL_ERRORS
NLS_SESSION_PARAMETERS
ALL_CONS_COLUMNS
ALL_TABLES
15. Description of LOBs contained in tables accessible to the user
SYSTEM_PRIVILEGE_MAP
ALL_TAB_COLUMNS
SESSION_PRIVS
ALL_LOBS
16. All tables - views - synonyms - sequences accessible to the user
ALL_TAB_COL_STATISTICS
DBA_ERRORS
ALL_CATALOG
SYSTEM_PRIVILEGE_MAP
17. Arguments in object accessible to the user
DBA_OBJECTS
DBA_TS_QUOTAS
DBA_ROLES
ALL_ARGUMENTS
18. Snapshots the user can access
ALL_TAB_COMMENTS
GLOBAL_NAME
ALL_SNAPSHOTS
DBA_VIEWS
19. Description of relational tables accessible to the user
ALL_CONSTRAINTS
ALL_TAB_COLUMNS
ALL_SYNONYMS
ALL_TABLES
20. Information about all users of the database
ALL_USERS
DICTIONARY
NLS_SESSION_PARAMETERS
ALL_OBJECTS
21. Columns of user's tables - views and clusters
ALL_TAB_COL_STATISTICS
ALL_TAB_COLUMNS
ALL_USERS
ALL_SOURCE
22. Table privileges granted to roles
ALL_TYPES
DBA_TAB_PRIVS
ROLE_TAB_PRIVS
DBA_USERS
23. Database links accessible to the user
ALL_TABLES
DBA_SOURCE
DBA_VIEWS
ALL_DB_LINKS
24. Roles granted to users and roles
ALL_LOBS
DBA_ROLE_PRIVS
ALL_ARGUMENTS
DBA_TS_QUOTAS
25. All database links in the database
NLS_DATABASE_PARAMETERS
DBA_DB_LINKS
DICTIONARY
ALL_LOBS
26. Description of types accessible to the user
TABLE_PRIVILEGE_MAP
ALL_SNAPSHOTS
ALL_TYPES
NLS_SESSION_PARAMETERS
27. Version and status information for component products
PRODUCT_COMPONENT_VERSION
DICT_COLUMNS
ALL_SOURCE
ALL_OBJECTS
28. Description of all tablespaces
ALL_OBJECTS
DBA_TABLESPACES
DBA_SOURCE
TABLE_PRIVILEGE_MAP
29. Description of all views in the database
DBA_VIEWS
ALL_CATALOG
NLS_INSTANCE_PARAMETERS
ALL_SNAPSHOTS
30. Description of views accessible to the user
SYSTEM_PRIVILEGE_MAP
ALL_VIEWS
ALL_CONSTRAINTS
DBA_SOURCE
31. Source of all stored objects in the database
DBA_ROLE_PRIVS
DBA_SOURCE
ALL_INDEXES
ALL_LOBS
32. Privileges which the user currently has set
NLS_INSTANCE_PARAMETERS
ALL_TRIGGER_COLS
DBA_TAB_PRIVS
SESSION_PRIVS
33. NLS parameters of the instance
NLS_INSTANCE_PARAMETERS
DBA_TS_QUOTAS
ALL_CONSTRAINTS
ALL_TRIGGER_COLS
34. Objects accessible to the user
ALL_TAB_COL_STATISTICS
DATABASE_COMPATIBLE_LEVEL
ALL_OBJECTS
ALL_INDEXES
35. Roles which the user currently has enabled.
ALL_TYPES
DBA_VIEWS
SESSION_ROLES
ALL_CONSTRAINTS
36. Comments on tables and views accessible to the user
SESSION_ROLES
ALL_TAB_COMMENTS
SESSION_PRIVS
DATABASE_COMPATIBLE_LEVEL
37. Database compatible parameter set via init.ora
ALL_TYPES
ALL_INDEXES
DATABASE_COMPATIBLE_LEVEL
SESSION_PRIVS
38. Information about all users of the database
DBA_ROLES
DBA_USERS
DBA_ROLE_PRIVS
ALL_OBJECT_TABLES
39. NLS parameters of the user session
ALL_SOURCE
NLS_SESSION_PARAMETERS
ALL_TRIGGERS
SESSION_ROLES
40. Comments on columns of accessible tables and views
SESSION_PRIVS
DBA_ROLES
ALL_TAB_COL_STATISTICS
ALL_COL_COMMENTS
41. Global database name
DBA_TAB_PRIVS
GLOBAL_NAME
DBA_ERRORS
ALL_SNAPSHOTS
42. Permanent NLS parameters of the database
ALL_LOBS
NLS_DATABASE_PARAMETERS
ALL_SOURCE
ALL_INDEXES
43. All grants on objects in the database
DBA_TAB_PRIVS
DBA_DB_LINKS
DBA_ERRORS
ALL_TABLES
44. Description of all updatable columns
DBA_ROLES
ALL_SYNONYMS
ALL_SOURCE
ALL_UPDATABLE_COLUMNS
45. Description of data dictionary tables and views
DICTIONARY
SESSION_PRIVS
ALL_IND_COLUMNS
TABLE_PRIVILEGES
46. Triggers accessible to the current user
ALL_TRIGGER_COLS
ALL_TRIGGERS
ALL_ARGUMENTS
ALL_COL_COMMENTS
47. Description of SEQUENCEs accessible to the user
SYSTEM_PRIVILEGE_MAP
DBA_OBJECTS
ALL_SEQUENCES
SESSION_PRIVS
48. All Roles which exist in the database
DBA_ROLES
ALL_TABLES
DBA_VIEWS
ALL_CATALOG
49. Tablespace quotas for all users
ALL_TRIGGERS
DICT_COLUMNS
DBA_VIEWS
DBA_TS_QUOTAS
50. Description of all object tables accessible to the user
DBA_ROLES
DBA_OBJECTS
DBA_ERRORS
ALL_OBJECT_TABLES