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