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. A unique part of a record is called__________
Consistency
Standard Connection Pooling (Prior to 11g)
Transaction Management
Candidate Key
2. These help ensure that the effects of a user's transaction are Durable (even in the event of a computer failure)
Redo Log Files
Oracle Home
Isolation
Latches
3. The process responsible for transferring all modified data blocks in the Data Caches to the Data Files.
Database Writer (DBWR)
Process Monitor (PMON)
Foreground Process
Dedicated Server
4. A _____ _____ can be created to store blocks within the Buffer Cache that are rarely reused.
DML - Database Manipulation Language
Listener
PL/SQL
Recycle Pool
5. A factor in the decision to assign a table or index to a particular tablespace is ___________
The Oracle Instance
Standard Connection Pooling (Prior to 11g)
Redo Log Files
Block Size - * they should match
6. Beginning Oracle 10g - it provides the most essential software in a bundle called an _______.
The Shared Pool
Data Dictionary
SGA - System Global Area
Instant Client
7. At frequent intervals - the contents of the Data Caches are synchronized with the Data Files. This is performed by a dedicated process called ____________
Connection Pooling
Checkpoint Process (CKPT)
Data Dictionary
Memory area
8. The location of the database software
Database
Atomic
Oracle Home
Real Application Clusters (RAC)
9. The _____ property ensures that once all the steps in a transaction have been competed successfully - the results are considered permanent.
8KB
Durability
System Monitor (SMON)
SYSTEM / SYSAUX tablespaces
10. A mirrored set of redo log files is called a ________
2 - same size
Trace File
PL/SQL
Redo Log Group
11. This process is responsible for any cleanup activities necessary if the database is restarted after an abnormal shutdown resulting from system failure.
SYSTEM & SYSAUX
System Monitor (SMON)
Program Global Area
Isolation
12. In a UNIX or Linux environment - you will also need to use the root account to perform a few tasks such as modifying the __________.
The Buffer Cache
Kernel Settings
Database
2 - same size
13. Which Oracle Architecture combines RAC and Standby technology?
pfile/spfile
Instance
Maximum Available Architecture (MAA)
Candidate Key
14. The most important database configuration file - which contains the settings used during database startup: _______ - * comes in 2 forms; text and binary - * pfile is aka init.ora
DISPLAY
SYSTEM / SYSAUX tablespaces
pfile/spfile
SYSTEM & SYSAUX
15. A large component of the SGA - which is best-known for use in caching query execution plans is called _________
The Shared Pool
Connection Pooling
PL/SQL
Atomic
16. The process responsible for transferring all Undo and Redo entries in the Log Buffer to the Redo Log Files.
Dedicated Server
COMMIT.
Log Writer
Log Writer (LGWR)
17. When a redo log file fills up - an Oracle component called the _____ makes one of more copies of it.
Database Writer (DBWR)
Recycle Pool
Archiver
Listener.ora
18. SGA - System Global Area is divided into distinct areas such as the buffer cache - the ________ and the log buffer.
2 - same size
SQL*Plus
Shared pool
Checkpoint Process (CKPT)
19. Commonly used block size of data blocks
Kernel Settings
8KB
Standard Connection Pooling (Prior to 11g)
SYSTEM / SYSAUX tablespaces
20. 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?
The Buffer Cache
Control File
Keep Pool
Real Application Clusters (RAC)
21. Typical convention for naming data files
Log Writer (LGWR)
Candidate Key
<tablespace><number>.dbf - or - <tablespace><number>.ora
Trace File
22. In which Oracle Architecture is each connection handled by a dedicated Oracle process?
Listener.ora
tnsnames.ora
Trigger Operations
Dedicated Server
23. The files on the storage disks connected to the database host is the __________
Instance
RAC - Real Application Clusters
Database
PL/SQL
24. The very large __________ shared by all Oracle processes is the SGA - System Global Area
The Buffer Cache
pfile/spfile
Memory area
Database
25. In which Oracle Architecture can additional Instances be added to the cluster to scale out instead of scaling up?
SGA - System Global Area
Product Disks - OUI (Oracle Universal Installer)
Real Application Clusters (RAC)
Latches
26. When a set of shared Application Tier Processes handle all requests - each of which maintain a persistent connection to the Database - this is called ______________
Standard Connection Pooling (Prior to 11g)
pfile/spfile
Database Writer (DBWR)
tnsnames.ora
27. The simplest way to create a database is to use the __________.
The Buffer Cache
The Oracle Instance
The Shared Pool
Database Creation Assistant (DBCA)
28. 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.
Trigger Operations
Foreground Process
Database Writer (DBWR)
Double
29. What describes the various computer processes resident in computer memory and memory areas shared by these processes?
Redo Log Files
Instance
Checkpoint Process (CKPT)
Real Application Clusters (RAC)
30. The _____ property ensures that results produces by concurrently executing transactions are serialized.
Shared pool
Isolation
2 - same size
pfile/spfile
31. Data Files store your _____ & _____.
PL/SQL
Data blocks (or pages)
Trigger Operations
Tables - Indexes
32. A standby database - which is kept in a separate data center - is kept synchronized with the production DB using this.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
33. A Dedicated _____ _____ is typically started whenever a user connects to the database.
Maximum Available Architecture (MAA)
Candidate Key
Recycle Pool
Foreground Process
34. The space within data files is organized into
Instance
DELETE & MERGE
Redo Log Files
Data blocks (or pages)
35. What is the private work area in computer memory which each Oracle server process uses to hold intermediate results (temp files) called?
Shared Server
Embedded SQL
DDL - Database Definition Language
Program Global Area
36. The Oracle Instance is composed of: Foreground Processes - Background Processes - ___________
SGA - System Global Area
Checkpoint Process (CKPT)
Tables - Indexes
Data blocks (or pages)
37. What is typically the largest portion of the SGA?
DELETE & MERGE
The Buffer Cache
Archiver
Data Dictionary
38. Programs that can be stored in an Oracle Database are written in
Database
PL/SQL
Tables - Indexes
Redo Log Group
39. This process watches the progress of the database connections.
Active Workload Repository (AWR)
Archiver
System Monitor (SMON)
Process Monitor (PMON)
40. When Application Tier Processes communicate with a Connection Broker - which uses a Connection Pool - this is called _________________
Oracle's Data Guard Technology
Database
Database Resident Connection Pooling (DRCP) (11g Only)
Atomic
41. Type of a SQL statement used to modify data
Redo Log Files
Maximum Available Architecture (MAA)
DML - Database Manipulation Language
On-Line Transaction Processing (OLTP)
42. In a UNIX or Linux environment - you will need to install and run Oracle using a __________.
Listener.ora
Real Application Clusters (RAC)
Dedicated Account
Cookies
43. 3 ___________: Redundancy - Nullable Data Items - Duplicate Data Records
Real Application Clusters (RAC)
Oracle Data Guard
SQL Deficiencies
Database Creation Assistant (DBCA)
44. Other things to consider when determining disk space are _____ & Undo / Temp space.
Flashback Recovery Area
Foreground Process
DISPLAY
SYSTEM / SYSAUX tablespaces
45. Name the 6 Oracle Architectural Choices: Dedicated Server - Shared Server - ___________ - Real Application Clusters (RAC) - Standby DB - Maximum Available Architecture (MAA)
2 - same size
DISPLAY
Durability
Connection Pooling
46. 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
Durability
RAC - Real Application Clusters
Real Application Clusters (RAC)
Log Writer
47. Data files are logically grouped into _____ and are usually given descriptive names such as DATA - INDEX - UNDO & TEMP.
Tablespaces
Real Application Clusters (RAC)
Instant Client
Product Disks - OUI (Oracle Universal Installer)
48. A DBMS ensures transactions are: _______ - Consistent - Isolated - Durable
Atomic
Archiver (ARCH)
Maximum Available Architecture (MAA)
Database Creation Assistant (DBCA)
49. 3 Physical Operations of a Transaction: Index Updates - ___________ - Recursive Operations
Trigger Operations
Atomic
Listener
The Buffer Cache
50. The engine that processes requests for data from the database is __________
DML - Database Manipulation Language
The Oracle Instance
Checkpoint Process (CKPT)
Log Buffer