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. At frequent intervals - the contents of the Data Caches are synchronized with the Data Files. This is performed by a dedicated process called ____________
The Shared Pool
Data blocks (or pages)
Checkpoint Process (CKPT)
Consistency
2. When a redo log file fills up - an Oracle component called the _____ makes one of more copies of it.
Process Monitor (PMON)
Recycle Pool
Archiver
Instance
3. What describes the various computer processes resident in computer memory and memory areas shared by these processes?
Redo Log Files
Instance
Checkpoint Process (CKPT)
Dedicated Account
4. What is produces every time certain severe errors occur?
tnsnames.ora.
Latches
Trace File
Standard Connection Pooling (Prior to 11g)
5. A unique part of a record is called__________
Candidate Key
Oracle Home
Listener.ora
The Buffer Cache
6. 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.
Instant Client
DISPLAY
On-Line Transaction Processing (OLTP)
Flashback Recovery Area
7. This process watches the progress of the database connections.
Listener
Process Monitor (PMON)
Consistency
Listener Log
8. Configuration file that contains location information for databases
Data Dictionary
tnsnames.ora
Cookies
Database Creation Assistant (DBCA)
9. 2 tablespaces which are always created by and whose names are mandated by Oracle
The Buffer Cache
Tablespaces
On-Line Transaction Processing (OLTP)
SYSTEM & SYSAUX
10. The engine that processes requests for data from the database is __________
The Oracle Instance
Keep Pool
DML - Database Manipulation Language
Standard Connection Pooling (Prior to 11g)
11. An important configuration file related to the users starting a database session is the __________
Latches
Listener
Listener.ora
SYSTEM / SYSAUX tablespaces
12. Which Oracle Architecture combines RAC and Standby technology?
Shared Server
Trace File
Oracle's Data Guard Technology
Maximum Available Architecture (MAA)
13. A _____ _____ can be created to store blocks within the Buffer Cache that are rarely reused.
Isolation
Recycle Pool
Log Writer (LGWR)
DELETE & MERGE
14. 3 Physical Operations of a Transaction: Index Updates - ___________ - Recursive Operations
DML - Database Manipulation Language
Standard Connection Pooling (Prior to 11g)
Trigger Operations
SQL Deficiencies
15. A large component of the SGA - which is best-known for use in caching query execution plans is called _________
Process Monitor (PMON)
The Shared Pool
Control File
SQL*Plus
16. A special _____ _____ can be created within the Buffer Cache to store data blocks from frequently used data tables - such as lookup tables.
Keep Pool
Database
Log Buffer
SQL Deficiencies
17. Name the 6 Oracle Architectural Choices: Dedicated Server - Shared Server - ___________ - Real Application Clusters (RAC) - Standby DB - Maximum Available Architecture (MAA)
Connection Pooling
SYSTEM & SYSAUX
Checkpoint Process (CKPT)
Net Configuration Assistant (NetCA)
18. The SYSTEM tablespace - which stores only tables containing information about the rest of the database - is called the ___________
Control File
Data Dictionary
Alert Log
Data Integrity Constraints
19. The simplest way to create a database is to use the __________.
Embedded SQL
DDL - Database Definition Language
Data Dictionary
Database Creation Assistant (DBCA)
20. Before you can create the first DB on a system - you must first configure a _____.
Listener
Control File
Alert Log
SGA - System Global Area
21. In which Oracle Architecture does the client communicate with an ODB Dispatcher Process which has a Request Queue and a Response Queue?
Standard Connection Pooling (Prior to 11g)
Net Configuration Assistant (NetCA)
DISPLAY
Shared Server
22. Type of SQL statements used to create and modify objects
Program Global Area
Data Dictionary
Real Application Clusters (RAC)
DDL - Database Definition Language
23. These help ensure that the effects of a user's transaction are Durable (even in the event of a computer failure)
Double
Tablespaces
The Oracle Instance
Redo Log Files
24. What is typically the largest portion of the SGA?
Atomic
Redo Log Files
The Buffer Cache
Oracle Data Guard
25. The files on the storage disks connected to the database host is the __________
Candidate Key
Database
SGA - System Global Area
Alert Log
26. Commonly used block size of data blocks
<tablespace><number>.dbf - or - <tablespace><number>.ora
Database
8KB
Product Disks - OUI (Oracle Universal Installer)
27. The location of backup copies of the data files is traditionally referred to as ________
Dedicated Server
Flashback Recovery Area
Database Writer (DBWR)
Memory area
28. 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.
Oracle Home
Listener.ora
Process Monitor (PMON)
29. This wakes up periodically and copies any accumulated Undo and Redo entries to the Redo Log File.
Program Global Area
Log Writer
Archiver
Process Monitor (PMON)
30. The _____ property ensures that results produces by concurrently executing transactions are serialized.
Isolation
Data Dictionary
Shared pool
Oracle Data Guard
31. In a UNIX or Linux environment - you will have to mount the _____ _____ and enable an X Windows environment for the use of _____.
RAC - Real Application Clusters
Program Global Area
Real Application Clusters (RAC)
Product Disks - OUI (Oracle Universal Installer)
32. Core Features of any DBMS are: ___________ - Data Integrity - Security
Keep Pool
Consistency
Transaction Management
Redo Log Group
33. Other things to consider when determining disk space are _____ & Undo / Temp space.
Consistency
Data Dictionary
SYSTEM / SYSAUX tablespaces
Net Configuration Assistant (NetCA)
34. The Oracle Instance is composed of: Foreground Processes - Background Processes - ___________
SGA - System Global Area
Database
Listener
Shared pool
35. What tool is used to automated the process of Redo information being shipped from the Main DB and applied to the Standby DB?
Oracle Data Guard
Redo Log Files
Maximum Available Architecture (MAA)
Checkpoint Process (CKPT)
36. When a set of shared Application Tier Processes handle all requests - each of which maintain a persistent connection to the Database - this is called ______________
Dedicated Server
System Monitor (SMON)
Trigger Operations
Standard Connection Pooling (Prior to 11g)
37. The SYSAUX tablespace is used to store ____________ - such as Statspack or Management Information.
Process Monitor (PMON)
Shared Server
Active Workload Repository (AWR)
Checkpoint Process (CKPT)
38. 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
RAC - Real Application Clusters
Archiver
Tables - Indexes
COMMIT.
39. 3 ___________: Redundancy - Nullable Data Items - Duplicate Data Records
Net Configuration Assistant (NetCA)
Redo Log Files
Block Size - * they should match
SQL Deficiencies
40. Oracle needs at least _____ redo log files and they should be the _____ _____.
Program Global Area
8KB
Tables - Indexes
2 - same size
41. A mirrored set of redo log files is called a ________
Redo Log Group
Database
Oracle's Data Guard Technology
Trace File
42. Beginning Oracle 10g - it provides the most essential software in a bundle called an _______.
Tables - Indexes
tnsnames.ora.
Durability
Instant Client
43. The very large __________ shared by all Oracle processes is the SGA - System Global Area
SYSTEM / SYSAUX tablespaces
Memory area
Log Writer
Listener.ora
44. A standby database - which is kept in a separate data center - is kept synchronized with the production DB using this.
45. SGA - System Global Area is divided into distinct areas such as the buffer cache - the ________ and the log buffer.
Shared pool
Redo Log Files
SYSTEM / SYSAUX tablespaces
Data blocks (or pages)
46. Which Oracle Architecture has two or more ODB Instances sharing access to the same set of disks and coordinating with each other over a fast network?
Atomic
Durability
Database Creation Assistant (DBCA)
Real Application Clusters (RAC)
47. This process is responsible for any cleanup activities necessary if the database is restarted after an abnormal shutdown resulting from system failure.
Double
Program Global Area
System Monitor (SMON)
8KB
48. In Connection Pooling the information generated by the autonomous tasks not preserved in RAM - but saved in _______ or in the DB itself
Listener
Cookies
Dedicated Account
Trigger Operations
49. What program is used to create a Listener?
Log Buffer
Oracle Data Guard
Net Configuration Assistant (NetCA)
Oracle's Data Guard Technology
50. Type of a SQL statement used to modify data
pfile/spfile
DML - Database Manipulation Language
SQL Deficiencies
DDL - Database Definition Language