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