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. Objects accessible to the user






2. NLS parameters of the instance






3. Database compatible parameter set via init.ora






4. All synonyms accessible to the user






5. NLS parameters of the user session






6. Description of all tablespaces






7. Description of all object tables accessible to the user






8. Information about all users of the database






9. Description of views accessible to the user






10. Tablespace quotas for all users






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






12. Snapshots the user can access






13. Roles which the user currently has enabled.






14. Comments on columns of accessible tables and views






15. All triggers in the database






16. Constraint definitions on accessible tables






17. Database links accessible to the user






18. Description of all views in the database






19. Comments on tables and views accessible to the user






20. Description of relational tables accessible to the user






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






22. Version and status information for component products






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






24. Privileges which the user currently has set






25. Triggers accessible to the current user






26. Description of all updatable columns






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






28. All database links in the database






29. Information about accessible columns in constraint definitions






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






31. All grants on objects in the database






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






33. Current errors on all stored objects in the database






34. Table privileges granted to roles






35. Description of SEQUENCEs accessible to the user






36. All Roles which exist in the database






37. Roles granted to users and roles






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






39. Arguments in object accessible to the user






40. Descriptions of indexes on tables accessible to the user






41. Source of all stored objects in the database






42. Description of types accessible to the user






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






44. COLUMNs comprising INDEXes on accessible TABLES






45. Information about all users of the database






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






47. Description of data dictionary tables and views






48. Description of columns in data dictionary tables and views






49. Global database name






50. All objects in the database