Test your basic knowledge |

Oracle Views

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. Constraint definitions on accessible tables






2. Roles which the user currently has enabled.






3. Description of columns in data dictionary tables and views






4. Permanent NLS parameters of the database






5. Current errors on all stored objects in the database






6. All Roles which exist in the database






7. Description table for privilege (auditing option) type codes. Maps privilege (auditing option) type numbers to type names






8. Triggers accessible to the current user






9. Tablespace quotas for all users






10. Information about all users of the database






11. Description of types accessible to the user






12. All synonyms accessible to the user






13. Table privileges granted to roles






14. Source of all stored objects in the database






15. Description table for privilege type codes. Maps privilege type numbers to type names






16. Objects accessible to the user






17. Descriptions of indexes on tables accessible to the user






18. Snapshots the user can access






19. NLS parameters of the instance






20. Information about all users of the database






21. Current source on stored objects that user is allowed to create






22. Description of relational tables accessible to the user






23. Comments on columns of accessible tables and views






24. Roles granted to users and roles






25. Description of data dictionary tables and views






26. Information about accessible columns in constraint definitions






27. Description of all views in the database






28. Database compatible parameter set via init.ora






29. Description of all object tables accessible to the user






30. Description of views accessible to the user






31. Grants on objects for which the user is the grantor - grantee - owner - or an enabled role or PUBLIC is the grantee






32. Global database name






33. Database links accessible to the user






34. Current errors on stored objects that user is allowed to create






35. All objects in the database






36. Version and status information for component products






37. Column usage in user's triggers or in triggers on user's tables






38. Description of LOBs contained in tables accessible to the user






39. Description of all updatable columns






40. COLUMNs comprising INDEXes on accessible TABLES






41. NLS parameters of the user session






42. All triggers in the database






43. Description of SEQUENCEs accessible to the user






44. All tables - views - synonyms - sequences accessible to the user






45. Columns of user's tables - views and clusters






46. Columns of user's tables - views and clusters






47. Privileges which the user currently has set






48. Arguments in object accessible to the user






49. All grants on objects in the database






50. All database links in the database