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 of all tablespaces






2. Description of all object tables accessible to the user






3. All grants on objects in the database






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






5. NLS parameters of the user session






6. NLS parameters of the instance






7. Version and status information for component products






8. Description of views accessible to the user






9. Comments on columns of accessible tables and views






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






11. Roles granted to users and roles






12. All triggers in the database






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






14. Triggers accessible to the current user






15. Information about all users of the database






16. Information about accessible columns in constraint definitions






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






18. Table privileges granted to roles






19. Information about all users of the database






20. Description of all views in the database






21. All objects in the database






22. All database links in the database






23. Global database name






24. COLUMNs comprising INDEXes on accessible TABLES






25. Permanent NLS parameters of the database






26. Objects accessible to the user






27. Tablespace quotas for all users






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






29. All Roles which exist in the database






30. All synonyms accessible to the user






31. Source of all stored objects in the database






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






33. Snapshots the user can access






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






35. Constraint definitions on accessible tables






36. Current errors on all stored objects in the database






37. Description of all updatable columns






38. Database compatible parameter set via init.ora






39. Database links accessible to the user






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






41. Description of SEQUENCEs accessible to the user






42. Description of relational tables accessible to the user






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






44. Description of types accessible to the user






45. Descriptions of indexes on tables accessible to the user






46. Description of columns in data dictionary tables and views






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






48. Comments on tables and views accessible to the user






49. Roles which the user currently has enabled.






50. Privileges which the user currently has set







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:



Major Subjects



Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Most popular tests