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. All synonyms accessible to the user






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






3. Database compatible parameter set via init.ora






4. Information about all users of the database






5. All objects in the database






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






7. Description of all object tables accessible to the user






8. Permanent NLS parameters of the database






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






10. Current errors on all stored objects in the database






11. Comments on columns of accessible tables and views






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






13. Descriptions of indexes on tables accessible to the user






14. Privileges which the user currently has set






15. Version and status information for component products






16. Description of types accessible to the user






17. Constraint definitions on accessible tables






18. Source of all stored objects in the database






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






20. Description of SEQUENCEs accessible to the user






21. Roles granted to users and roles






22. Information about all users of the database






23. Description of views accessible to the user






24. Description of data dictionary tables and views






25. All triggers in the database






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






27. Description of all views in the database






28. Comments on tables and views accessible to the user






29. All grants on objects in the database






30. NLS parameters of the instance






31. Information about accessible columns in constraint definitions






32. Description of relational tables accessible to the user






33. Objects accessible to the user






34. Triggers accessible to the current user






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






36. COLUMNs comprising INDEXes on accessible TABLES






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






38. Description of all tablespaces






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






40. Table privileges granted to roles






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






42. NLS parameters of the user session






43. Roles which the user currently has enabled.






44. All database links in the database






45. Snapshots the user can access






46. Description of columns in data dictionary tables and views






47. Description of all updatable columns






48. Tablespace quotas for all users






49. All Roles which exist in the database






50. Database links accessible to the user