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__________
<tablespace><number>.dbf - or - <tablespace><number>.ora
Trace File
Latches
Candidate Key
2. The very large __________ shared by all Oracle processes is the SGA - System Global Area
Memory area
Log Writer (LGWR)
Embedded SQL
DISPLAY
3. The files on the storage disks connected to the database host is the __________
Instant Client
Database
RAC - Real Application Clusters
pfile/spfile
4. Data Files store your _____ & _____.
Double
Oracle's Data Guard Technology
DML - Database Manipulation Language
Tables - Indexes
5. Data files are logically grouped into _____ and are usually given descriptive names such as DATA - INDEX - UNDO & TEMP.
Control File
On-Line Transaction Processing (OLTP)
RAC - Real Application Clusters
Tablespaces
6. In which Oracle Architecture can additional Instances be added to the cluster to scale out instead of scaling up?
System Monitor (SMON)
Real Application Clusters (RAC)
Consistency
Database Creation Assistant (DBCA)
7. A DBMS ensures transactions are: _______ - Consistent - Isolated - Durable
On-Line Transaction Processing (OLTP)
Listener.ora
COMMIT.
Atomic
8. In which Oracle Architecture is each connection handled by a dedicated Oracle process?
DELETE & MERGE
pfile/spfile
Dedicated Server
DDL - Database Definition Language
9. In the Shared Server the State Information is kept in the SGA for _______________
Oracle's Data Guard Technology
Listener Log
Latches
On-Line Transaction Processing (OLTP)
10. 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
DML - Database Manipulation Language
SYSTEM & SYSAUX
Instance
pfile/spfile
11. Commonly used block size of data blocks
Checkpoint Process (CKPT)
PL/SQL
8KB
Data Integrity Constraints
12. 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
Archiver
pfile/spfile
8KB
RAC - Real Application Clusters
13. 3 ___________: Redundancy - Nullable Data Items - Duplicate Data Records
SQL Deficiencies
Transaction Management
Trace File
SYSTEM / SYSAUX tablespaces
14. Which Oracle Architecture combines RAC and Standby technology?
Block Size - * they should match
Maximum Available Architecture (MAA)
DML - Database Manipulation Language
Transaction Management
15. SGA - System Global Area is divided into distinct areas such as the buffer cache - the ________ and the log buffer.
Shared pool
Flashback Recovery Area
Process Monitor (PMON)
Oracle Data Guard
16. Configuration file that contains location information for databases
Tablespaces
Trigger Operations
tnsnames.ora
SGA - System Global Area
17. The 6 Background Processes: Database Writer (DBWWR) - Log Writer (LGWR) - Archiver (ARCH) - ___________ - Process Monitor (PMON) - System Monitor (SMON)
Listener.ora
Tables - Indexes
Checkpoint Process (CKPT)
Latches
18. Type of a SQL statement used to modify data
Candidate Key
SGA - System Global Area
DML - Database Manipulation Language
Process Monitor (PMON)
19. The _____ property ensures that results produces by concurrently executing transactions are serialized.
Isolation
Net Configuration Assistant (NetCA)
Tablespaces
Data Integrity Constraints
20. INSERT - UPDATE - ________ are examples of DML - Database Manipulation Language
The Shared Pool
Tablespaces
Latches
DELETE & MERGE
21. When a redo log file fills up - an Oracle component called the _____ makes one of more copies of it.
Durability
Redo Log Files
Archiver
DML - Database Manipulation Language
22. A factor in the decision to assign a table or index to a particular tablespace is ___________
Control File
Block Size - * they should match
Maximum Available Architecture (MAA)
DISPLAY
23. An important configuration file related to the users starting a database session is the __________
Candidate Key
COMMIT.
Flashback Recovery Area
Listener.ora
24. Programs that can be stored in an Oracle Database are written in
DELETE & MERGE
Archiver
Log Writer
PL/SQL
25. When Application Tier Processes communicate with a Connection Broker - which uses a Connection Pool - this is called _________________
Candidate Key
Shared Server
Database Resident Connection Pooling (DRCP) (11g Only)
Memory area
26. Oracle Provided Command-Line Tool - * used to automate tasks
SQL*Plus
Listener Log
Trigger Operations
Dedicated Account
27. In a UNIX or Linux environment - you will also need to use the root account to perform a few tasks such as modifying the __________.
Kernel Settings
Flashback Recovery Area
Alert Log
Data Dictionary
28. The Oracle Instance is composed of: Foreground Processes - Background Processes - ___________
SGA - System Global Area
Candidate Key
Transaction Management
Data Integrity Constraints
29. A standby database - which is kept in a separate data center - is kept synchronized with the production DB using this.
30. This is a queue of Undo and Redo entries.
Consistency
DDL - Database Definition Language
Database
Log Buffer
31. The _____ property of a transaction ensures that the transaction does not compromise the integrity of the database.
Trace File
The Oracle Instance
Listener Log
Consistency
32. What is typically the largest portion of the SGA?
The Buffer Cache
SYSTEM / SYSAUX tablespaces
Log Writer (LGWR)
Memory area
33. Core Features of any DBMS are: ___________ - Data Integrity - Security
Transaction Management
Standard Connection Pooling (Prior to 11g)
RAC - Real Application Clusters
Trace File
34. What describes the various computer processes resident in computer memory and memory areas shared by these processes?
Real Application Clusters (RAC)
DISPLAY
Instance
Database Creation Assistant (DBCA)
35. What program is used to create a Listener?
Foreground Process
Log Writer (LGWR)
Oracle Home
Net Configuration Assistant (NetCA)
36. The process responsible for making copies of the Redo Log Files when they fill up.
Active Workload Repository (AWR)
Keep Pool
Archiver (ARCH)
Listener
37. The process responsible for transferring all modified data blocks in the Data Caches to the Data Files.
Database Writer (DBWR)
Net Configuration Assistant (NetCA)
Database
Listener.ora
38. In a UNIX or Linux environment - you will need to install and run Oracle using a __________.
Shared pool
Atomic
Dedicated Account
Oracle Data Guard
39. 2 tablespaces which are always created by and whose names are mandated by Oracle
Atomic
Checkpoint Process (CKPT)
SQL*Plus
SYSTEM & SYSAUX
40. In Connection Pooling the information generated by the autonomous tasks not preserved in RAM - but saved in _______ or in the DB itself
RAC - Real Application Clusters
Standard Connection Pooling (Prior to 11g)
Real Application Clusters (RAC)
Cookies
41. The SYSAUX tablespace is used to store ____________ - such as Statspack or Management Information.
Active Workload Repository (AWR)
Durability
Oracle's Data Guard Technology
Connection Pooling
42. Transactions are Atomic or invisible from a logical perspective until the end of the transaction is indicated by an explicit instruction such as _______
Keep Pool
8KB
Consistency
COMMIT.
43. This process is responsible for any cleanup activities necessary if the database is restarted after an abnormal shutdown resulting from system failure.
PL/SQL
Shared Server
System Monitor (SMON)
Active Workload Repository (AWR)
44. The engine that processes requests for data from the database is __________
Data blocks (or pages)
Kernel Settings
The Oracle Instance
Active Workload Repository (AWR)
45. The simplest way to create a database is to use the __________.
Database Creation Assistant (DBCA)
On-Line Transaction Processing (OLTP)
Log Writer (LGWR)
Connection Pooling
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?
Real Application Clusters (RAC)
Data Integrity Constraints
Tables - Indexes
Redo Log Files
47. 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.
Process Monitor (PMON)
DISPLAY
On-Line Transaction Processing (OLTP)
PL/SQL
48. A large component of the SGA - which is best-known for use in caching query execution plans is called _________
Listener Log
The Shared Pool
tnsnames.ora
Log Writer (LGWR)
49. A special _____ _____ can be created within the Buffer Cache to store data blocks from frequently used data tables - such as lookup tables.
Database Creation Assistant (DBCA)
Checkpoint Process (CKPT)
SYSTEM / SYSAUX tablespaces
Keep Pool
50. 3 ______________: Check - Uniqueness - Referential
System Monitor (SMON)
Data Integrity Constraints
Latches
8KB