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. Privileges which the user currently has set






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






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






4. Global database name






5. Snapshots the user can access






6. Source of all stored objects in the database






7. All Roles which exist in the database






8. NLS parameters of the instance






9. Description of data dictionary tables and views






10. Description of all views in the database






11. Triggers accessible to the current user






12. Objects accessible to the user






13. Permanent NLS parameters of the database






14. Table privileges granted to roles






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






16. Description of SEQUENCEs accessible to the user






17. All objects in the database






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






19. Description of columns in data dictionary tables and views






20. Roles which the user currently has enabled.






21. Description of views accessible to the user






22. Comments on tables and views accessible to the user






23. Description of all object tables accessible to the user






24. Description of types accessible to the user






25. Description of all tablespaces






26. COLUMNs comprising INDEXes on accessible TABLES






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






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






29. Information about all users of the database






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






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






32. All triggers in the database






33. Information about all users of the database






34. Roles granted to users and roles






35. All synonyms accessible to the user






36. Information about accessible columns in constraint definitions






37. Version and status information for component products






38. Current errors on all stored objects in the database






39. Arguments in object accessible to the user






40. Database compatible parameter set via init.ora






41. All grants on objects in the database






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






43. Description of relational tables accessible to the user






44. All database links in the database






45. NLS parameters of the user session






46. Descriptions of indexes on tables accessible to the user






47. Tablespace quotas for all users






48. Constraint definitions on accessible tables






49. Comments on columns of accessible tables and views






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