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. Privileges which the user currently has set






2. NLS parameters of the user session






3. All triggers in the database






4. Tablespace quotas for all users






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






6. NLS parameters of the instance






7. Description of views accessible to the user






8. Permanent NLS parameters of the database






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






10. Global database name






11. Information about all users of the database






12. Description of all tablespaces






13. Information about all users of the database






14. Comments on columns of accessible tables and views






15. Description of columns in data dictionary tables and views






16. Description of all updatable columns






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






18. Descriptions of indexes on tables accessible to the user






19. Description of types accessible to the user






20. Roles granted to users and roles






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






22. Roles which the user currently has enabled.






23. Description of SEQUENCEs accessible to the user






24. All database links in the database






25. All objects in the database






26. Snapshots the user can access






27. Database links accessible to the user






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






29. Table privileges granted to roles






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






31. Current errors on all stored objects in the database






32. Description of data dictionary tables and views






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






34. Description of all views in the database






35. Description of relational tables accessible to the user






36. Constraint definitions on accessible tables






37. Source of all stored objects in the database






38. All synonyms accessible to the user






39. COLUMNs comprising INDEXes on accessible TABLES






40. Information about accessible columns in constraint definitions






41. All grants on objects in the database






42. Objects accessible to the user






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






44. Comments on tables and views accessible to the user






45. All Roles which exist in the database






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






47. Arguments in object accessible to the user






48. Description of all object tables accessible to the user






49. Version and status information for component products






50. Triggers accessible to the current user







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:

Browse all subjects

Browse all tests

Most popular tests



Major Subjects

Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Browse all subjects

Browse all tests

Most popular tests