Test your basic knowledge |

Oracle 11g

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. What is stored in the library cache






2. What kind of server process does a DBA connection get?






3. What do control files contain?






4. What is a database






5. How does a shared server architecture work?






6. What is an OS Block?






7. How do you create an OS-Authenticated user?






8. What is a tempfile?






9. What prefix must precede the OS username for an OS-Authenticated user?






10. What is the Program Global Area -- PGA?






11. What physical structure does a tablespace correspond to?






12. What happens if you are missing an archive log?






13. What is the Redo Log Buffer






14. What uses the large pool?






15. What view lets you look at audits of objects?






16. What is a change vector?






17. What are redo log files?






18. What does the CREATE SESSION privilege do?






19. What does process CJQ0 do?






20. What is the library cache?






21. What is the block header?






22. What is an object privilege?






23. How does updating use Database Buffer Cache






24. What does process DIA0 do?






25. What is a password profile






26. What is an instance?






27. What kinds of objects are not segments -but are pieces of code in the SYSTEM tablespace.






28. How do you assign a password profile to a user






29. What is the first file read when a database starts?






30. What SQL gives a user the ability to grant object privileges to another user?






31. What options do you have for auditing?






32. Where does auditing data go by default






33. What kinds of server processes are there?






34. What is a system privilege?






35. What SQL allows a user access to the database?






36. What SQL gives a user the ability to grant system privileges to another user?






37. What is Virtual Private Database?






38. What does a database role do?






39. What is the SYSAUX tablespace used for?






40. What is a database block?






41. What does the WITH GRANT OPTION do?






42. What does the Program Global Area (PGA) contain?






43. How many databases can an instance mount to?






44. What does the server process do?






45. What view lets you look at audits of privileges






46. What is the PL/SQL function result cache?






47. What is the first level of logical organization of your physical storage?






48. What is an Oracle Block?






49. What information is NOT stored in redo logs






50. What is Operating System Authentication?