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. How do you create an OS-Authenticated user?






2. How does select use Database Buffer Cache






3. What does the WITH ADMIN OPTION do?






4. What does the CREATE SESSION privilege do?






5. What SQL Would let you audit people creating tables?






6. What happens during a log switch operation? What causes the following: LGWR finishes writing to the current group






7. What information is NOT stored in redo logs






8. What is the SQL to grant an object privilege?






9. What are the 3 processes that are part of an instance?






10. What is the minimum number of redo log groups you must have?






11. What kinds of server processes are there?






12. What is a change vector?






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






14. What options can you add to audits?






15. How often should you switch log files






16. Which process writes to the Redo Log Files?






17. List the kinds of files used to run an Oracle Instance?






18. What uses the large pool?






19. What is a tempfile?






20. What physical structure does a tablespace correspond to?






21. What is the Database Buffer Cache


22. What are redo log files?






23. What SQL revokes user access to the database?






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






25. What is an Extent?






26. What is an OS Block?






27. The SGA is shared by what processes?






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






29. What views contain information about your DB Files?






30. What is the large pool?






31. What is Operating System Authentication?






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






33. What does process J000 do?






34. What is a segment






35. What is the library cache?






36. What is the highest privileged role?






37. What kind of objects can be in a segment






38. What is an instance?






39. What does process DIA0 do?






40. Which view helps you size memory properly






41. What does the server process do?






42. What does process CKPT do?






43. What are Archive log files?






44. What does process CJQ0 do?






45. How should log files be configured?






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






47. What is the dictionary cache?


48. What view lets you look at audits of system privileges






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






50. What does process LGWR do?