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 the Shared Server the State Information is kept in the SGA for _______________






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






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






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






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






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






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






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






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






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






11. A Dedicated _____ _____ is typically started whenever a user connects to the database.






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






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






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






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






16. The Oracle Instance is composed of: Foreground Processes - Background Processes - ___________






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






18. This file contains info about the rest of the DB - like names and locations of data files - redo log files and is used by Oracle while starting the DB.






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






20. The SYSAUX tablespace is used to store ____________ - such as Statspack or Management Information.






21. In which Oracle Architecture does the client communicate with an ODB Dispatcher Process which has a Request Queue and a Response Queue?






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






23. In which Oracle Architecture can additional Instances be added to the cluster to scale out instead of scaling up?






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






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






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






27. In Connection Pooling the information generated by the autonomous tasks not preserved in RAM - but saved in _______ or in the DB itself






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






29. Configuration file that contains location information for databases






30. An important configuration file related to the users starting a database session is the __________






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






32. This process watches the progress of the database connections.






33. The space within data files is organized into






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






35. Which Oracle Architecture combines RAC and Standby technology?






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






37. What tool is used to automated the process of Redo information being shipped from the Main DB and applied to the Standby DB?






38. 2 tablespaces which are always created by and whose names are mandated by Oracle






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






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






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






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






43. Programs that can be stored in an Oracle Database are written in






44. A unique part of a record is called__________






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






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






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






48. Type of a SQL statement used to modify data






49. 3 ______________: Check - Uniqueness - Referential






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