Test your basic knowledge |

Oracle Database 11 G Administration

Subject : 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. In which Oracle Architecture is each connection handled by a dedicated Oracle process?






2. The very large __________ shared by all Oracle processes is the SGA - System Global Area






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






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






5. Core Features of any DBMS are: ___________ - Data Integrity - Security






6. Name the 6 Oracle Architectural Choices: Dedicated Server - Shared Server - ___________ - Real Application Clusters (RAC) - Standby DB - Maximum Available Architecture (MAA)






7. Commonly used block size of data blocks






8. In which log is a record written every time a user establishes a connection to the database?






9. When a set of shared Application Tier Processes handle all requests - each of which maintain a persistent connection to the Database - this is called ______________






10. In a UNIX or Linux environment - you will have to mount the _____ _____ and enable an X Windows environment for the use of _____.






11. Beginning Oracle 10g - it provides the most essential software in a bundle called an _______.






12. The files on the storage disks connected to the database host is the __________






13. In which log are events such as startup - shutdown - DDL operations and space shortages written?






14. The Many-To-One configuration of Instances per Database is called...* whereby the db lives on shared disks and instances on multiple computers attached to the DB






15. This is a queue of Undo and Redo entries.






16. Type of a SQL statement used to modify data






17. 3 Physical Operations of a Transaction: Index Updates - ___________ - Recursive Operations






18. A special _____ _____ can be created within the Buffer Cache to store data blocks from frequently used data tables - such as lookup tables.






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






20. This wakes up periodically and copies any accumulated Undo and Redo entries to the Redo Log File.






21. A _____ _____ can be created to store blocks within the Buffer Cache that are rarely reused.






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






23. 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.






24. Typical convention for naming data files






25. Data Files store your _____ & _____.






26. What describes the various computer processes resident in computer memory and memory areas shared by these processes?






27. To estimate the amount of space required for your Data Files - Estimate space required for Tables - then ________ the number to allow for Indexes - then Double the number again to allow for Overhead Space and White Space.






28. The location of backup copies of the data files is traditionally referred to as ________






29. When a redo log file fills up - an Oracle component called the _____ makes one of more copies of it.






30. These help ensure that the effects of a user's transaction are Durable (even in the event of a computer failure)






31. When Application Tier Processes communicate with a Connection Broker - which uses a Connection Pool - this is called _________________






32. 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.






33. A factor in the decision to assign a table or index to a particular tablespace is ___________






34. Transactions are Atomic or invisible from a logical perspective until the end of the transaction is indicated by an explicit instruction such as _______






35. Type of SQL statements used to create and modify objects






36. At frequent intervals - the contents of the Data Caches are synchronized with the Data Files. This is performed by a dedicated process called ____________






37. The location of the database software






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






39. The process responsible for making copies of the Redo Log Files when they fill up.






40. The 6 Background Processes: Database Writer (DBWWR) - Log Writer (LGWR) - Archiver (ARCH) - ___________ - Process Monitor (PMON) - System Monitor (SMON)






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






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






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






44. In a UNIX or Linux environment - you will also need to use the root account to perform a few tasks such as modifying the __________.






45. Oracle Provided Command-Line Tool - * used to automate tasks






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






47. What is produces every time certain severe errors occur?






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






49. A large component of the SGA - which is best-known for use in caching query execution plans is called _________






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