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. Information about accessible columns in constraint definitions






2. Description of all tablespaces






3. Privileges which the user currently has set






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






5. NLS parameters of the instance






6. Database compatible parameter set via init.ora






7. NLS parameters of the user session






8. Constraint definitions on accessible tables






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






10. Tablespace quotas for all users






11. Roles which the user currently has enabled.






12. Version and status information for component products






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






14. Description of data dictionary tables and views






15. Description of views accessible to the user






16. Arguments in object accessible to the user






17. Objects accessible to the user






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






19. Global database name






20. Information about all users of the database






21. Permanent NLS parameters of the database






22. Database links accessible to the user






23. COLUMNs comprising INDEXes on accessible TABLES






24. Description of all views in the database






25. Comments on tables and views accessible to the user






26. Descriptions of indexes on tables accessible to the user






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






28. Description of all updatable columns






29. All database links in the database






30. Description of SEQUENCEs accessible to the user






31. All Roles which exist in the database






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






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






34. Description of types accessible to the user






35. Current errors on all stored objects in the database






36. Description of all object tables accessible to the user






37. All objects in the database






38. Source of all stored objects in the database






39. Description of relational tables accessible to the user






40. All grants on objects in the database






41. Information about all users of the database






42. Triggers accessible to the current user






43. Description of columns in data dictionary tables and views






44. All triggers in the database






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






46. All synonyms accessible to the user






47. Roles granted to users and roles






48. Table privileges granted to roles






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






50. Snapshots the user can access