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 the Program Global Area -- PGA?






2. How does select use Database Buffer Cache






3. What does process CJQ0 do?






4. How many datafiles does a tablespace organize?






5. What can you configure in the parameter files?






6. What is dynamic privilege management?






7. What are Archive log files?






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






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






10. What does process CKPT do?






11. What does the server process do?






12. Which SGA Structures are required






13. What does process PMON do?






14. What kinds of blocks do data files have?






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






16. What naming convention should you use for your PFILE






17. How does a dedicated server process work?






18. What is a dirty buffer?






19. What uses the large pool?






20. The SGA is shared by what processes?






21. What does process J000 do?






22. What is the library cache?






23. What SQL allows you to create role and grant privileges to a user






24. What is an Oracle Block?






25. What does the WITH GRANT OPTION do?






26. What does process VKTM do?






27. What does process SMON do






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






29. What is the SYSTEM tablespace used for?






30. What kinds of server processes are there?






31. What triggers a block write and therefore a dirty block?






32. How does updating use Database Buffer Cache






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






34. What is the dictionary cache?

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


35. What is Operating System Authentication?






36. What is audited by default in Oracle 11g?






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






38. What is stored in the library cache






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






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






41. What are the names of the parameter files?






42. What is Advanced Security Option






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






44. What is a tempfile?






45. What is the UNDO tablespace used for?






46. What is the SYSAUX tablespace used for?






47. What is the SQL for creating a password profile






48. Which view helps you size memory properly






49. Where does auditing data go by default






50. Which process writes to the Redo Log Files?