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 relational tables accessible to the user






2. Tablespace quotas for all users






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






4. Database links accessible to the user






5. Description of all updatable columns






6. Description of all tablespaces






7. Table privileges granted to roles






8. Triggers accessible to the current user






9. Global database name






10. Permanent NLS parameters of the database






11. All synonyms accessible to the user






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






13. Information about all users of the database






14. Arguments in object accessible to the user






15. All database links in the database






16. Description of types accessible to the user






17. Comments on tables and views accessible to the user






18. NLS parameters of the instance






19. Roles granted to users and roles






20. Constraint definitions on accessible tables






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






22. All grants on objects in the database






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






24. Description of views accessible to the user






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






26. All Roles which exist in the database






27. Roles which the user currently has enabled.






28. Database compatible parameter set via init.ora






29. Information about all users of the database






30. Current errors on all stored objects in the database






31. Version and status information for component products






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






33. Descriptions of indexes on tables accessible to the user






34. Information about accessible columns in constraint definitions






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






36. All triggers in the database






37. Description of all object tables accessible to the user






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






39. Comments on columns of accessible tables and views






40. Description of data dictionary tables and views






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






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






43. Objects accessible to the user






44. Privileges which the user currently has set






45. Description of columns in data dictionary tables and views






46. Description of all views in the database






47. NLS parameters of the user session






48. COLUMNs comprising INDEXes on accessible TABLES






49. Snapshots the user can access






50. Description of SEQUENCEs accessible to the user