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 database links in the database






2. Snapshots the user can access






3. Comments on columns of accessible tables and views






4. Privileges which the user currently has set






5. Descriptions of indexes on tables accessible to the user






6. Database links accessible to the user






7. Source of all stored objects in the database






8. Information about all users of the database






9. Description of types accessible to the user






10. Tablespace quotas for all users






11. Description of data dictionary tables and views






12. Table privileges granted to roles






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






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






15. Description of all views in the database






16. Triggers accessible to the current user






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






18. Constraint definitions on accessible tables






19. Description of SEQUENCEs accessible to the user






20. Roles granted to users and roles






21. Version and status information for component products






22. Description of columns in data dictionary tables and views






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






24. NLS parameters of the user session






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






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






27. All objects in the database






28. Objects accessible to the user






29. COLUMNs comprising INDEXes on accessible TABLES






30. Current errors on all stored objects in the database






31. Arguments in object accessible to the user






32. Comments on tables and views accessible to the user






33. Database compatible parameter set via init.ora






34. Description of views accessible to the user






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






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






37. Description of all updatable columns






38. All Roles which exist in the database






39. Description of all object tables accessible to the user






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






41. Permanent NLS parameters of the database






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






43. Description of all tablespaces






44. Roles which the user currently has enabled.






45. All grants on objects in the database






46. Global database name






47. NLS parameters of the instance






48. Description of relational tables accessible to the user






49. Information about all users of the database






50. All synonyms accessible to the user