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. Description table for privilege (auditing option) type codes. Maps privilege (auditing option) type numbers to type names






2. Database compatible parameter set via init.ora






3. Database links accessible to the user






4. Description of relational tables accessible to the user






5. Information about accessible columns in constraint definitions






6. Triggers accessible to the current user






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






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






9. All triggers in the database






10. Global database name






11. NLS parameters of the instance






12. Privileges which the user currently has set






13. All Roles which exist in the database






14. NLS parameters of the user session






15. Snapshots the user can access






16. Tablespace quotas for all users






17. Comments on tables and views accessible to the user






18. Current errors on all stored objects in the database






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






20. Objects accessible to the user






21. Description of all object tables accessible to the user






22. Comments on columns of accessible tables and views






23. Descriptions of indexes on tables accessible to the user






24. Arguments in object accessible to the user






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






26. Roles granted to users and roles






27. Constraint definitions on accessible tables






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






29. Description of all updatable columns






30. Description of views accessible to the user






31. Permanent NLS parameters of the database






32. Description of data dictionary tables and views






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






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






35. Table privileges granted to roles






36. Description of all views in the database






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






38. Description of all tablespaces






39. Version and status information for component products






40. All synonyms accessible to the user






41. Description of columns in data dictionary tables and views






42. COLUMNs comprising INDEXes on accessible TABLES






43. Information about all users of the database






44. Source of all stored objects in the database






45. All grants on objects in the database






46. All objects in the database






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






48. Description of types accessible to the user






49. Information about all users of the database






50. Description of SEQUENCEs accessible to the user