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