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. Description of data dictionary tables and views






2. All synonyms accessible to the user






3. Database compatible parameter set via init.ora






4. Current errors on all stored objects in the database






5. Privileges which the user currently has set






6. Permanent NLS parameters of the database






7. Description of all views in the database






8. All triggers in the database






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






10. Version and status information for component products






11. Global database name






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






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






14. Triggers accessible to the current user






15. Description of SEQUENCEs accessible to the user






16. All database links in the database






17. Objects accessible to the user






18. Source of all stored objects in the database






19. Roles which the user currently has enabled.






20. Description of all updatable columns






21. Constraint definitions on accessible tables






22. Description of views accessible to the user






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






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






25. Arguments in object accessible to the user






26. Comments on tables and views accessible to the user






27. Information about accessible columns in constraint definitions






28. Description of types accessible to the user






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






30. Snapshots the user can access






31. Description of all tablespaces






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






33. All objects in the database






34. NLS parameters of the user session






35. Database links accessible to the user






36. Tablespace quotas for all users






37. Table privileges granted to roles






38. Description of relational tables accessible to the user






39. All Roles which exist in the database






40. Description of all object tables accessible to the user






41. Information about all users of the database






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






43. Information about all users of the database






44. Description of columns in data dictionary tables and views






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






46. Roles granted to users and roles






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






48. COLUMNs comprising INDEXes on accessible TABLES






49. Descriptions of indexes on tables accessible to the user






50. All grants on objects in the database