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 type codes. Maps privilege type numbers to type names
TABLE_PRIVILEGE_MAP
ALL_SNAPSHOTS
ALL_SEQUENCES
SYSTEM_PRIVILEGE_MAP
2. All Roles which exist in the database
DBA_ROLES
ROLE_TAB_PRIVS
ALL_TABLES
DICT_COLUMNS
3. NLS parameters of the user session
NLS_SESSION_PARAMETERS
DBA_ROLES
ALL_OBJECT_TABLES
SYSTEM_PRIVILEGE_MAP
4. Information about accessible columns in constraint definitions
ALL_CONS_COLUMNS
ALL_TAB_COLUMNS
NLS_INSTANCE_PARAMETERS
ALL_ARGUMENTS
5. Global database name
ALL_CATALOG
ALL_IND_COLUMNS
ALL_TAB_COMMENTS
GLOBAL_NAME
6. Description of all views in the database
DBA_VIEWS
ALL_TRIGGER_COLS
ALL_TAB_COL_STATISTICS
PRODUCT_COMPONENT_VERSION
7. Description of all tablespaces
ALL_TYPES
DBA_TRIGGERS
ALL_LOBS
DBA_TABLESPACES
8. COLUMNs comprising INDEXes on accessible TABLES
ALL_CONS_COLUMNS
GLOBAL_NAME
ALL_SEQUENCES
ALL_IND_COLUMNS
9. NLS parameters of the instance
GLOBAL_NAME
NLS_INSTANCE_PARAMETERS
ALL_VIEWS
ALL_CATALOG
10. Current source on stored objects that user is allowed to create
ALL_SOURCE
DBA_DB_LINKS
DICT_COLUMNS
PRODUCT_COMPONENT_VERSION
11. All database links in the database
DBA_DB_LINKS
ALL_UPDATABLE_COLUMNS
ROLE_TAB_PRIVS
DICT_COLUMNS
12. Triggers accessible to the current user
DBA_ERRORS
ALL_TRIGGERS
DATABASE_COMPATIBLE_LEVEL
DBA_DB_LINKS
13. Tablespace quotas for all users
ALL_LOBS
DBA_TS_QUOTAS
ALL_SEQUENCES
DBA_ERRORS
14. Current errors on stored objects that user is allowed to create
ALL_OBJECTS
ALL_ERRORS
ALL_DB_LINKS
DBA_ERRORS
15. Column usage in user's triggers or in triggers on user's tables
ALL_TRIGGER_COLS
ALL_SOURCE
DICTIONARY
ALL_IND_COLUMNS
16. Comments on tables and views accessible to the user
ALL_TAB_COMMENTS
DBA_ERRORS
DBA_ROLE_PRIVS
ALL_COL_COMMENTS
17. Description of relational tables accessible to the user
GLOBAL_NAME
ALL_OBJECTS
SYSTEM_PRIVILEGE_MAP
ALL_TABLES
18. Roles which the user currently has enabled.
DBA_ERRORS
ALL_TABLES
ALL_UPDATABLE_COLUMNS
SESSION_ROLES
19. Arguments in object accessible to the user
DBA_DB_LINKS
DBA_ROLES
ALL_ARGUMENTS
ALL_INDEXES
20. All synonyms accessible to the user
NLS_INSTANCE_PARAMETERS
ALL_SYNONYMS
ALL_CATALOG
ALL_TYPES
21. Descriptions of indexes on tables accessible to the user
ALL_INDEXES
ALL_ARGUMENTS
ALL_LOBS
ALL_COL_COMMENTS
22. Description of all object tables accessible to the user
DBA_OBJECTS
DBA_USERS
ALL_CONSTRAINTS
ALL_OBJECT_TABLES
23. Current errors on all stored objects in the database
ALL_OBJECT_TABLES
ALL_VIEWS
DBA_ERRORS
ALL_ERRORS
24. All grants on objects in the database
DBA_TAB_PRIVS
ALL_TAB_COLUMNS
ALL_OBJECTS
PRODUCT_COMPONENT_VERSION
25. Comments on columns of accessible tables and views
ALL_COL_COMMENTS
NLS_SESSION_PARAMETERS
DICT_COLUMNS
SYSTEM_PRIVILEGE_MAP
26. Description of all updatable columns
ALL_UPDATABLE_COLUMNS
TABLE_PRIVILEGES
ALL_SYNONYMS
DBA_ROLE_PRIVS
27. Columns of user's tables - views and clusters
ALL_ERRORS
DBA_ERRORS
ALL_CATALOG
ALL_TAB_COL_STATISTICS
28. All tables - views - synonyms - sequences accessible to the user
TABLE_PRIVILEGE_MAP
NLS_DATABASE_PARAMETERS
ALL_CATALOG
DBA_USERS
29. Version and status information for component products
PRODUCT_COMPONENT_VERSION
ALL_TAB_COLUMNS
ALL_SNAPSHOTS
DBA_VIEWS
30. Information about all users of the database
DBA_TS_QUOTAS
DBA_USERS
ALL_ARGUMENTS
ALL_TABLES
31. Objects accessible to the user
NLS_INSTANCE_PARAMETERS
ALL_OBJECTS
DICTIONARY
ALL_TAB_COMMENTS
32. Description of SEQUENCEs accessible to the user
ALL_SOURCE
ALL_SEQUENCES
ALL_INDEXES
NLS_INSTANCE_PARAMETERS
33. Snapshots the user can access
DBA_TAB_PRIVS
ALL_SNAPSHOTS
ALL_TAB_COL_STATISTICS
ALL_DB_LINKS
34. Description of views accessible to the user
ALL_SNAPSHOTS
DBA_USERS
DBA_OBJECTS
ALL_VIEWS
35. Database compatible parameter set via init.ora
ALL_USERS
DATABASE_COMPATIBLE_LEVEL
ALL_CATALOG
ALL_ERRORS
36. Table privileges granted to roles
DBA_DB_LINKS
ROLE_TAB_PRIVS
NLS_INSTANCE_PARAMETERS
ALL_DB_LINKS
37. Privileges which the user currently has set
ALL_LOBS
SESSION_PRIVS
TABLE_PRIVILEGES
DBA_DB_LINKS
38. All objects in the database
NLS_INSTANCE_PARAMETERS
DBA_USERS
DBA_OBJECTS
ALL_TYPES
39. Permanent NLS parameters of the database
DBA_ROLE_PRIVS
DBA_TAB_PRIVS
NLS_DATABASE_PARAMETERS
ALL_TABLES
40. Database links accessible to the user
ALL_DB_LINKS
NLS_INSTANCE_PARAMETERS
ALL_ERRORS
SESSION_PRIVS
41. Columns of user's tables - views and clusters
ALL_TABLES
ALL_TAB_COLUMNS
DBA_TAB_PRIVS
DATABASE_COMPATIBLE_LEVEL
42. Grants on objects for which the user is the grantor - grantee - owner - or an enabled role or PUBLIC is the grantee
NLS_SESSION_PARAMETERS
TABLE_PRIVILEGES
PRODUCT_COMPONENT_VERSION
ALL_TRIGGERS
43. Source of all stored objects in the database
PRODUCT_COMPONENT_VERSION
TABLE_PRIVILEGE_MAP
DBA_SOURCE
ALL_TAB_COL_STATISTICS
44. Information about all users of the database
ALL_USERS
ALL_ERRORS
ALL_TAB_COLUMNS
SYSTEM_PRIVILEGE_MAP
45. Description of LOBs contained in tables accessible to the user
ALL_LOBS
DBA_TABLESPACES
DBA_VIEWS
DATABASE_COMPATIBLE_LEVEL
46. Description of data dictionary tables and views
DBA_ERRORS
DBA_ROLE_PRIVS
DICTIONARY
TABLE_PRIVILEGE_MAP
47. Description of types accessible to the user
ALL_TYPES
DBA_VIEWS
ALL_COL_COMMENTS
ALL_TAB_COL_STATISTICS
48. Constraint definitions on accessible tables
NLS_INSTANCE_PARAMETERS
ALL_TAB_COL_STATISTICS
SYSTEM_PRIVILEGE_MAP
ALL_CONSTRAINTS
49. Description table for privilege (auditing option) type codes. Maps privilege (auditing option) type numbers to type names
ALL_SOURCE
TABLE_PRIVILEGE_MAP
NLS_SESSION_PARAMETERS
DICT_COLUMNS
50. Description of columns in data dictionary tables and views
DBA_TS_QUOTAS
DBA_TABLESPACES
ALL_ARGUMENTS
DICT_COLUMNS