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. Other things to consider when determining disk space are _____ & Undo / Temp space.
SYSTEM / SYSAUX tablespaces
DISPLAY
Real Application Clusters (RAC)
Database Writer (DBWR)
2. The _____ property ensures that results produces by concurrently executing transactions are serialized.
Control File
DML - Database Manipulation Language
Process Monitor (PMON)
Isolation
3. The engine that processes requests for data from the database is __________
2 - same size
Isolation
The Oracle Instance
Control File
4. The process responsible for making copies of the Redo Log Files when they fill up.
Database Creation Assistant (DBCA)
RAC - Real Application Clusters
Flashback Recovery Area
Archiver (ARCH)
5. The SYSAUX tablespace is used to store ____________ - such as Statspack or Management Information.
On-Line Transaction Processing (OLTP)
The Buffer Cache
Active Workload Repository (AWR)
DDL - Database Definition Language
6. In a UNIX or Linux environment - you will also need to use the root account to perform a few tasks such as modifying the __________.
Data Integrity Constraints
Dedicated Account
Kernel Settings
2 - same size
7. The SYSTEM tablespace - which stores only tables containing information about the rest of the database - is called the ___________
Data Dictionary
Program Global Area
Connection Pooling
tnsnames.ora
8. Oracle needs at least _____ redo log files and they should be the _____ _____.
Isolation
The Oracle Instance
2 - same size
Embedded SQL
9. In which log is a record written every time a user establishes a connection to the database?
Double
DISPLAY
Listener Log
Alert Log
10. SGA - System Global Area is divided into distinct areas such as the buffer cache - the ________ and the log buffer.
SYSTEM & SYSAUX
Log Writer (LGWR)
Trace File
Shared pool
11. What program is used to create a Listener?
Net Configuration Assistant (NetCA)
Listener.ora
Maximum Available Architecture (MAA)
SQL Deficiencies
12. When a set of shared Application Tier Processes handle all requests - each of which maintain a persistent connection to the Database - this is called ______________
Log Buffer
Alert Log
The Buffer Cache
Standard Connection Pooling (Prior to 11g)
13. 3 ______________: Check - Uniqueness - Referential
Data Integrity Constraints
DELETE & MERGE
Program Global Area
tnsnames.ora
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
Recycle Pool
RAC - Real Application Clusters
Memory area
Maximum Available Architecture (MAA)
15. A special _____ _____ can be created within the Buffer Cache to store data blocks from frequently used data tables - such as lookup tables.
SQL Deficiencies
Net Configuration Assistant (NetCA)
Keep Pool
Isolation
16. Configuration file that contains location information for databases
SQL*Plus
Product Disks - OUI (Oracle Universal Installer)
Block Size - * they should match
tnsnames.ora
17. The very large __________ shared by all Oracle processes is the SGA - System Global Area
Archiver (ARCH)
Memory area
Checkpoint Process (CKPT)
Durability
18. Commonly used block size of data blocks
Listener
Atomic
Database Writer (DBWR)
8KB
19. The files on the storage disks connected to the database host is the __________
pfile/spfile
Oracle's Data Guard Technology
Dedicated Account
Database
20. The location of backup copies of the data files is traditionally referred to as ________
Flashback Recovery Area
Product Disks - OUI (Oracle Universal Installer)
Log Writer
Instant Client
21. The process responsible for transferring all Undo and Redo entries in the Log Buffer to the Redo Log Files.
The Shared Pool
Trigger Operations
Log Writer (LGWR)
Oracle Data Guard
22. 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
Embedded SQL
PL/SQL
Net Configuration Assistant (NetCA)
pfile/spfile
23. 3 Physical Operations of a Transaction: Index Updates - ___________ - Recursive Operations
Keep Pool
DML - Database Manipulation Language
Archiver
Trigger Operations
24. Type of a SQL statement used to modify data
DML - Database Manipulation Language
Log Buffer
SQL*Plus
SYSTEM & SYSAUX
25. What describes the various computer processes resident in computer memory and memory areas shared by these processes?
Database Creation Assistant (DBCA)
Instance
Log Writer (LGWR)
Listener Log
26. In which Oracle Architecture is each connection handled by a dedicated Oracle process?
Process Monitor (PMON)
Flashback Recovery Area
Dedicated Server
Tables - Indexes
27. Name the 6 Oracle Architectural Choices: Dedicated Server - Shared Server - ___________ - Real Application Clusters (RAC) - Standby DB - Maximum Available Architecture (MAA)
Block Size - * they should match
tnsnames.ora.
Tables - Indexes
Connection Pooling
28. Data files are logically grouped into _____ and are usually given descriptive names such as DATA - INDEX - UNDO & TEMP.
Tablespaces
Log Buffer
The Buffer Cache
Trigger Operations
29. Beginning Oracle 10g - it provides the most essential software in a bundle called an _______.
Data Integrity Constraints
Memory area
Candidate Key
Instant Client
30. When Application Tier Processes communicate with a Connection Broker - which uses a Connection Pool - this is called _________________
Database Resident Connection Pooling (DRCP) (11g Only)
Listener
Embedded SQL
Oracle Data Guard
31. In the Shared Server the State Information is kept in the SGA for _______________
Instant Client
RAC - Real Application Clusters
SYSTEM & SYSAUX
On-Line Transaction Processing (OLTP)
32. When a redo log file fills up - an Oracle component called the _____ makes one of more copies of it.
Trigger Operations
Memory area
Redo Log Group
Archiver
33. The simplest way to create a database is to use the __________.
Oracle Home
Maximum Available Architecture (MAA)
Program Global Area
Database Creation Assistant (DBCA)
34. What is the private work area in computer memory which each Oracle server process uses to hold intermediate results (temp files) called?
Program Global Area
DISPLAY
Instant Client
2 - same size
35. 3 ___________: Redundancy - Nullable Data Items - Duplicate Data Records
Database Resident Connection Pooling (DRCP) (11g Only)
Checkpoint Process (CKPT)
The Oracle Instance
SQL Deficiencies
36. This process watches the progress of the database connections.
DDL - Database Definition Language
Shared pool
Standard Connection Pooling (Prior to 11g)
Process Monitor (PMON)
37. In a UNIX or Linux environment - you will have to mount the _____ _____ and enable an X Windows environment for the use of _____.
Oracle's Data Guard Technology
Block Size - * they should match
Product Disks - OUI (Oracle Universal Installer)
The Shared Pool
38. What is typically the largest portion of the SGA?
DISPLAY
pfile/spfile
Embedded SQL
The Buffer Cache
39. A factor in the decision to assign a table or index to a particular tablespace is ___________
Latches
Real Application Clusters (RAC)
Block Size - * they should match
RAC - Real Application Clusters
40. In which Oracle Architecture can additional Instances be added to the cluster to scale out instead of scaling up?
Real Application Clusters (RAC)
Database Writer (DBWR)
Shared pool
Log Writer (LGWR)
41. 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
42. Core Features of any DBMS are: ___________ - Data Integrity - Security
Archiver (ARCH)
Standard Connection Pooling (Prior to 11g)
Listener.ora
Transaction Management
43. Before you can create the first DB on a system - you must first configure a _____.
Listener
Standard Connection Pooling (Prior to 11g)
Real Application Clusters (RAC)
tnsnames.ora.
44. The _____ property ensures that once all the steps in a transaction have been competed successfully - the results are considered permanent.
Maximum Available Architecture (MAA)
Database Resident Connection Pooling (DRCP) (11g Only)
Listener
Durability
45. 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.
Keep Pool
Atomic
DISPLAY
System Monitor (SMON)
46. 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.
Net Configuration Assistant (NetCA)
DML - Database Manipulation Language
Data blocks (or pages)
47. 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.
Double
Redo Log Files
Consistency
SYSTEM & SYSAUX
48. At frequent intervals - the contents of the Data Caches are synchronized with the Data Files. This is performed by a dedicated process called ____________
Database Resident Connection Pooling (DRCP) (11g Only)
Data Integrity Constraints
DML - Database Manipulation Language
Checkpoint Process (CKPT)
49. The _____ property of a transaction ensures that the transaction does not compromise the integrity of the database.
Consistency
Redo Log Files
Log Writer
RAC - Real Application Clusters
50. This process is responsible for any cleanup activities necessary if the database is restarted after an abnormal shutdown resulting from system failure.
Control File
Redo Log Files
SQL Deficiencies
System Monitor (SMON)