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. All grants on objects in the database






2. All synonyms accessible to the user






3. Permanent NLS parameters of the database






4. Database compatible parameter set via init.ora






5. Source of all stored objects in the database






6. NLS parameters of the instance






7. Comments on tables and views accessible to the user






8. Triggers accessible to the current user






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






10. Database links accessible to the user






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






12. Descriptions of indexes on tables accessible to the user






13. Comments on columns of accessible tables and views






14. Roles which the user currently has enabled.






15. All objects in the database






16. All database links in the database






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






18. NLS parameters of the user session






19. Description of all tablespaces






20. Arguments in object accessible to the user






21. Description of columns in data dictionary tables and views






22. Constraint definitions on accessible tables






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






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






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






26. Description of relational tables accessible to the user






27. Table privileges granted to roles






28. Description of types accessible to the user






29. Information about all users of the database






30. Privileges which the user currently has set






31. Description of data dictionary tables and views






32. COLUMNs comprising INDEXes on accessible TABLES






33. Description of all updatable columns






34. Roles granted to users and roles






35. Description of all object tables accessible to the user






36. Snapshots the user can access






37. Current errors on all stored objects in the database






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






39. Global database name






40. Description of SEQUENCEs accessible to the user






41. All Roles which exist in the database






42. Version and status information for component products






43. All triggers in the database






44. Description of all views in the database






45. Tablespace quotas for all users






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






47. Objects accessible to the user






48. Information about all users of the database






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






50. Information about accessible columns in constraint definitions