SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Oracle Database 11 G Administration
Start Test
Study First
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 _______________
Listener Log
SYSTEM & SYSAUX
On-Line Transaction Processing (OLTP)
Log Writer
2. The very large __________ shared by all Oracle processes is the SGA - System Global Area
The Buffer Cache
pfile/spfile
Memory area
Foreground Process
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 __________.
Keep Pool
Kernel Settings
Data blocks (or pages)
Listener Log
4. Oracle needs at least _____ redo log files and they should be the _____ _____.
SQL*Plus
Keep Pool
Recycle Pool
2 - same size
5. 3 Physical Operations of a Transaction: Index Updates - ___________ - Recursive Operations
Trigger Operations
DISPLAY
DELETE & MERGE
Data Integrity Constraints
6. SGA - System Global Area is divided into distinct areas such as the buffer cache - the ________ and the log buffer.
Oracle's Data Guard Technology
Kernel Settings
Database Creation Assistant (DBCA)
Shared pool
7. A factor in the decision to assign a table or index to a particular tablespace is ___________
Keep Pool
Checkpoint Process (CKPT)
DDL - Database Definition Language
Block Size - * they should match
8. A special _____ _____ can be created within the Buffer Cache to store data blocks from frequently used data tables - such as lookup tables.
The Shared Pool
DML - Database Manipulation Language
Keep Pool
Dedicated Account
9. Beginning Oracle 10g - it provides the most essential software in a bundle called an _______.
DISPLAY
Keep Pool
Instant Client
Latches
10. A DBMS ensures transactions are: _______ - Consistent - Isolated - Durable
Atomic
Product Disks - OUI (Oracle Universal Installer)
Real Application Clusters (RAC)
Database
11. A Dedicated _____ _____ is typically started whenever a user connects to the database.
DML - Database Manipulation Language
System Monitor (SMON)
Listener
Foreground Process
12. These help ensure that the effects of a user's transaction are Durable (even in the event of a computer failure)
Real Application Clusters (RAC)
SQL*Plus
Log Buffer
Redo Log Files
13. When a redo log file fills up - an Oracle component called the _____ makes one of more copies of it.
DISPLAY
Tables - Indexes
Shared Server
Archiver
14. The SYSTEM tablespace - which stores only tables containing information about the rest of the database - is called the ___________
Foreground Process
Data Dictionary
Standard Connection Pooling (Prior to 11g)
Database
15. In which log are events such as startup - shutdown - DDL operations and space shortages written?
Alert Log
Redo Log Files
Connection Pooling
Latches
16. The Oracle Instance is composed of: Foreground Processes - Background Processes - ___________
SGA - System Global Area
DISPLAY
Kernel Settings
The Shared Pool
17. The process responsible for transferring all modified data blocks in the Data Caches to the Data Files.
Latches
Database Writer (DBWR)
Real Application Clusters (RAC)
Oracle's Data Guard Technology
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.
Control File
Log Buffer
Standard Connection Pooling (Prior to 11g)
tnsnames.ora.
19. What is produces every time certain severe errors occur?
Connection Pooling
Trace File
Data Dictionary
Dedicated Account
20. The SYSAUX tablespace is used to store ____________ - such as Statspack or Management Information.
Listener Log
Shared Server
Candidate Key
Active Workload Repository (AWR)
21. In which Oracle Architecture does the client communicate with an ODB Dispatcher Process which has a Request Queue and a Response Queue?
SYSTEM & SYSAUX
Kernel Settings
Shared Server
Control File
22. Other things to consider when determining disk space are _____ & Undo / Temp space.
SYSTEM / SYSAUX tablespaces
PL/SQL
Memory area
Database Resident Connection Pooling (DRCP) (11g Only)
23. In which Oracle Architecture can additional Instances be added to the cluster to scale out instead of scaling up?
Listener.ora
Checkpoint Process (CKPT)
Real Application Clusters (RAC)
Log Writer (LGWR)
24. Oracle Provided Command-Line Tool - * used to automate tasks
SQL*Plus
Isolation
Archiver (ARCH)
Data Dictionary
25. The engine that processes requests for data from the database is __________
The Oracle Instance
SQL Deficiencies
Dedicated Server
DDL - Database Definition Language
26. The _____ property ensures that results produces by concurrently executing transactions are serialized.
Isolation
SGA - System Global Area
Block Size - * they should match
Database Resident Connection Pooling (DRCP) (11g Only)
27. In Connection Pooling the information generated by the autonomous tasks not preserved in RAM - but saved in _______ or in the DB itself
Cookies
Connection Pooling
COMMIT.
Alert Log
28. In a UNIX or Linux environment - you will have to mount the _____ _____ and enable an X Windows environment for the use of _____.
Product Disks - OUI (Oracle Universal Installer)
DML - Database Manipulation Language
Real Application Clusters (RAC)
Instance
29. Configuration file that contains location information for databases
Tables - Indexes
Active Workload Repository (AWR)
DISPLAY
tnsnames.ora
30. An important configuration file related to the users starting a database session is the __________
Listener.ora
DELETE & MERGE
Recycle Pool
Redo Log Group
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.
tnsnames.ora.
The Oracle Instance
The Shared Pool
Log Writer
32. This process watches the progress of the database connections.
The Shared Pool
Checkpoint Process (CKPT)
Process Monitor (PMON)
Connection Pooling
33. The space within data files is organized into
The Oracle Instance
Log Buffer
8KB
Data blocks (or pages)
34. At frequent intervals - the contents of the Data Caches are synchronized with the Data Files. This is performed by a dedicated process called ____________
Log Writer
Checkpoint Process (CKPT)
On-Line Transaction Processing (OLTP)
DELETE & MERGE
35. Which Oracle Architecture combines RAC and Standby technology?
Latches
Redo Log Files
Maximum Available Architecture (MAA)
Data Integrity Constraints
36. Name the 6 Oracle Architectural Choices: Dedicated Server - Shared Server - ___________ - Real Application Clusters (RAC) - Standby DB - Maximum Available Architecture (MAA)
Connection Pooling
tnsnames.ora
Transaction Management
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?
2 - same size
Latches
Shared Server
Oracle Data Guard
38. 2 tablespaces which are always created by and whose names are mandated by Oracle
Instance
Memory area
SQL Deficiencies
SYSTEM & SYSAUX
39. Data files are logically grouped into _____ and are usually given descriptive names such as DATA - INDEX - UNDO & TEMP.
PL/SQL
Foreground Process
Tablespaces
SYSTEM / SYSAUX tablespaces
40. Core Features of any DBMS are: ___________ - Data Integrity - Security
Trace File
Checkpoint Process (CKPT)
Transaction Management
Data Integrity Constraints
41. The files on the storage disks connected to the database host is the __________
Shared pool
Database
Kernel Settings
DDL - Database Definition Language
42. The _____ property ensures that once all the steps in a transaction have been competed successfully - the results are considered permanent.
Listener
COMMIT.
Standard Connection Pooling (Prior to 11g)
Durability
43. Programs that can be stored in an Oracle Database are written in
Connection Pooling
Latches
Database Writer (DBWR)
PL/SQL
44. A unique part of a record is called__________
Real Application Clusters (RAC)
Archiver (ARCH)
Block Size - * they should match
Candidate Key
45. The location of backup copies of the data files is traditionally referred to as ________
8KB
Log Writer
Flashback Recovery Area
Block Size - * they should match
46. In which log is a record written every time a user establishes a connection to the database?
Listener Log
Redo Log Files
Database Creation Assistant (DBCA)
Shared Server
47. The process responsible for making copies of the Redo Log Files when they fill up.
On-Line Transaction Processing (OLTP)
RAC - Real Application Clusters
Listener
Archiver (ARCH)
48. Type of a SQL statement used to modify data
Double
Data blocks (or pages)
The Oracle Instance
DML - Database Manipulation Language
49. 3 ______________: Check - Uniqueness - Referential
<tablespace><number>.dbf - or - <tablespace><number>.ora
Database
Data Integrity Constraints
RAC - Real Application Clusters
50. Before you can create the first DB on a system - you must first configure a _____.
Redo Log Files
Memory area
Listener
Foreground Process