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






2. Description of all updatable columns






3. Privileges which the user currently has set






4. Constraint definitions on accessible tables






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






6. Roles granted to users and roles






7. Global database name






8. Description of all views in the database






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






10. All triggers in the database






11. Descriptions of indexes on tables accessible to the user






12. Information about all users of the database






13. Version and status information for component products






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






15. Comments on tables and views accessible to the user






16. Description of relational tables accessible to the user






17. Arguments in object accessible to the user






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






19. Description of data dictionary tables and views






20. Snapshots the user can access






21. All objects in the database






22. All Roles which exist in the database






23. Table privileges granted to roles






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






25. Triggers accessible to the current user






26. Roles which the user currently has enabled.






27. Objects accessible to the user






28. NLS parameters of the instance






29. Description of types accessible to the user






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






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






32. Current errors on all stored objects in the database






33. Database compatible parameter set via init.ora






34. Database links accessible to the user






35. Information about all users of the database






36. Comments on columns of accessible tables and views






37. COLUMNs comprising INDEXes on accessible TABLES






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






39. Permanent NLS parameters of the database






40. NLS parameters of the user session






41. Source of all stored objects in the database






42. Tablespace quotas for all users






43. Description of views accessible to the user






44. Description of SEQUENCEs accessible to the user






45. Description of all tablespaces






46. Description of columns in data dictionary tables and views






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






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






49. Description of all object tables accessible to the user






50. All database links in the database