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 table for privilege type codes. Maps privilege type numbers to type names






2. All Roles which exist in the database






3. NLS parameters of the user session






4. Information about accessible columns in constraint definitions






5. Global database name






6. Description of all views in the database






7. Description of all tablespaces






8. COLUMNs comprising INDEXes on accessible TABLES






9. NLS parameters of the instance






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






11. All database links in the database






12. Triggers accessible to the current user






13. Tablespace quotas for all users






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






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






16. Comments on tables and views accessible to the user






17. Description of relational tables accessible to the user






18. Roles which the user currently has enabled.






19. Arguments in object accessible to the user






20. All synonyms accessible to the user






21. Descriptions of indexes on tables accessible to the user






22. Description of all object tables accessible to the user






23. Current errors on all stored objects in the database






24. All grants on objects in the database






25. Comments on columns of accessible tables and views






26. Description of all updatable columns






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






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






29. Version and status information for component products






30. Information about all users of the database






31. Objects accessible to the user






32. Description of SEQUENCEs accessible to the user






33. Snapshots the user can access






34. Description of views accessible to the user






35. Database compatible parameter set via init.ora






36. Table privileges granted to roles






37. Privileges which the user currently has set






38. All objects in the database






39. Permanent NLS parameters of the database






40. Database links accessible to the user






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






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






43. Source of all stored objects in the database






44. Information about all users of the database






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






46. Description of data dictionary tables and views






47. Description of types accessible to the user






48. Constraint definitions on accessible tables






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






50. Description of columns in data dictionary tables and views