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. Snapshots the user can access






2. Arguments in object accessible to the user






3. All triggers in the database






4. Descriptions of indexes on tables accessible to the user






5. NLS parameters of the user session






6. Database compatible parameter set via init.ora






7. Tablespace quotas for all users






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






9. Permanent NLS parameters of the database






10. Current errors on all stored objects in the database






11. Description of all tablespaces






12. All Roles which exist in the database






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






14. Description of all updatable columns






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






16. Roles granted to users and roles






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






18. Information about accessible columns in constraint definitions






19. COLUMNs comprising INDEXes on accessible TABLES






20. All grants on objects in the database






21. Triggers accessible to the current user






22. Global database name






23. Privileges which the user currently has set






24. Table privileges granted to roles






25. Comments on tables and views accessible to the user






26. Description of all views in the database






27. Version and status information for component products






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






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






30. Information about all users of the database






31. Comments on columns of accessible tables and views






32. Description of types accessible to the user






33. Information about all users of the database






34. Database links accessible to the user






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






36. Source of all stored objects in the database






37. Description of SEQUENCEs accessible to the user






38. Description of data dictionary tables and views






39. Objects accessible to the user






40. All synonyms accessible to the user






41. Roles which the user currently has enabled.






42. All database links in the database






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






44. Description of all object tables accessible to the user






45. Description of columns in data dictionary tables and views






46. Description of relational tables accessible to the user






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






48. NLS parameters of the instance






49. Description of views accessible to the user






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