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. Current source on stored objects that user is allowed to create






2. Description of columns in data dictionary tables and views






3. Comments on columns of accessible tables and views






4. Description of all tablespaces






5. Triggers accessible to the current user






6. All grants on objects in the database






7. NLS parameters of the user session






8. Snapshots the user can access






9. Information about accessible columns in constraint definitions






10. Roles which the user currently has enabled.






11. All database links in the database






12. Table privileges granted to roles






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






14. Tablespace quotas for all users






15. Database compatible parameter set via init.ora






16. All Roles which exist in the database






17. Current errors on all stored objects in the database






18. COLUMNs comprising INDEXes on accessible TABLES






19. All triggers in the database






20. Description of types accessible to the user






21. Information about all users of the database






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






23. Permanent NLS parameters of the database






24. Arguments in object accessible to the user






25. Information about all users of the database






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






27. Description of all updatable columns






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






29. Description of SEQUENCEs accessible to the user






30. Description of data dictionary tables and views






31. Objects accessible to the user






32. Description of relational tables accessible to the user






33. NLS parameters of the instance






34. Constraint definitions on accessible tables






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






36. Description of views accessible to the user






37. Global database name






38. Version and status information for component products






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






40. All synonyms accessible to the user






41. Source of all stored objects in the database






42. Database links accessible to the user






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






44. All objects in the database






45. Description of all object tables accessible to the user






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






47. Description of all views in the database






48. Comments on tables and views accessible to the user






49. Roles granted to users and roles






50. Descriptions of indexes on tables accessible to the user