Test your basic knowledge |

Oracle Database 11 G Administration

Subject : it-skills
Instructions:
  • Answer 25 questions in 10 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. A _____ _____ can be created to store blocks within the Buffer Cache that are rarely reused.






2. The _____ property ensures that once all the steps in a transaction have been competed successfully - the results are considered permanent.






3. Data files are logically grouped into _____ and are usually given descriptive names such as DATA - INDEX - UNDO & TEMP.






4. A standby database - which is kept in a separate data center - is kept synchronized with the production DB using this.


5. The space within data files is organized into






6. The engine that processes requests for data from the database is __________






7. In UNIX - to use the dbca and netca executables in /bin/ - you have to point the _____ variable to any available X-server such as Xvnc.






8. The 4 Steps involved in installing the Instant Client: Download from OTN (Oracle Technology Network). - Unzip into directory of choice. - Create __________ - Add location of software to PATH and TNS_ADMIN.






9. Applications developed to communicate with Oracle DBs use what type of SQL?






10. Other things to consider when determining disk space are _____ & Undo / Temp space.






11. In the Shared Server the State Information is kept in the SGA for _______________






12. Oracle needs at least _____ redo log files and they should be the _____ _____.






13. What program is used to create a Listener?






14. The SYSTEM tablespace - which stores only tables containing information about the rest of the database - is called the ___________






15. The _____ property ensures that results produces by concurrently executing transactions are serialized.






16. SGA - System Global Area is divided into distinct areas such as the buffer cache - the ________ and the log buffer.






17. Before you can create the first DB on a system - you must first configure a _____.






18. INSERT - UPDATE - ________ are examples of DML - Database Manipulation Language






19. The process responsible for transferring all Undo and Redo entries in the Log Buffer to the Redo Log Files.






20. This process is responsible for any cleanup activities necessary if the database is restarted after an abnormal shutdown resulting from system failure.






21. The various Oracle processes coordinate their access to the areas of the SGA by using IPC - Interprocess Communication mechanisms called _______






22. The _____ property of a transaction ensures that the transaction does not compromise the integrity of the database.






23. A DBMS ensures transactions are: _______ - Consistent - Isolated - Durable






24. The process responsible for transferring all modified data blocks in the Data Caches to the Data Files.






25. 3 ___________: Redundancy - Nullable Data Items - Duplicate Data Records