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. Triggers accessible to the current user






2. Description of types accessible to the user






3. Roles granted to users and roles






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






5. Permanent NLS parameters of the database






6. Description of columns in data dictionary tables and views






7. COLUMNs comprising INDEXes on accessible TABLES






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






9. All grants on objects in the database






10. Description of relational tables accessible to the user






11. Database compatible parameter set via init.ora






12. Description of all object tables accessible to the user






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






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






15. Table privileges granted to roles






16. Current errors on all stored objects in the database






17. Comments on columns of accessible tables and views






18. NLS parameters of the user session






19. Description of all tablespaces






20. Tablespace quotas for all users






21. Information about all users of the database






22. Objects accessible to the user






23. Database links accessible to the user






24. All synonyms accessible to the user






25. Description of views accessible to the user






26. Description of all updatable columns






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






28. Information about all users of the database






29. Privileges which the user currently has set






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






31. All database links in the database






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






33. Description of data dictionary tables and views






34. Snapshots the user can access






35. Information about accessible columns in constraint definitions






36. Description of all views in the database






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






38. Version and status information for component products






39. NLS parameters of the instance






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






41. Descriptions of indexes on tables accessible to the user






42. All triggers in the database






43. All Roles which exist in the database






44. Arguments in object accessible to the user






45. Description of SEQUENCEs accessible to the user






46. Roles which the user currently has enabled.






47. Source of all stored objects in the database






48. Global database name






49. Comments on tables and views accessible to the user






50. Constraint definitions on accessible tables