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. Typical convention for naming data files
Latches
DISPLAY
Dedicated Server
<tablespace><number>.dbf - or - <tablespace><number>.ora
2. 2 tablespaces which are always created by and whose names are mandated by Oracle
Archiver (ARCH)
Isolation
SYSTEM & SYSAUX
Alert Log
3. Type of a SQL statement used to modify data
2 - same size
DML - Database Manipulation Language
PL/SQL
<tablespace><number>.dbf - or - <tablespace><number>.ora
4. Beginning Oracle 10g - it provides the most essential software in a bundle called an _______.
Instant Client
Block Size - * they should match
Listener
Alert Log
5. What program is used to create a Listener?
Durability
Shared Server
Listener
Net Configuration Assistant (NetCA)
6. A unique part of a record is called__________
Candidate Key
SYSTEM & SYSAUX
8KB
Database
7. Type of SQL statements used to create and modify objects
tnsnames.ora.
DDL - Database Definition Language
Real Application Clusters (RAC)
Latches
8. Before you can create the first DB on a system - you must first configure a _____.
Log Buffer
tnsnames.ora.
Real Application Clusters (RAC)
Listener
9. In the Shared Server the State Information is kept in the SGA for _______________
Tablespaces
Alert Log
On-Line Transaction Processing (OLTP)
Data blocks (or pages)
10. The process responsible for transferring all modified data blocks in the Data Caches to the Data Files.
Database Writer (DBWR)
COMMIT.
Database Creation Assistant (DBCA)
Database Resident Connection Pooling (DRCP) (11g Only)
11. A factor in the decision to assign a table or index to a particular tablespace is ___________
Cookies
Real Application Clusters (RAC)
Flashback Recovery Area
Block Size - * they should match
12. The SYSAUX tablespace is used to store ____________ - such as Statspack or Management Information.
Control File
Candidate Key
Active Workload Repository (AWR)
Instant Client
13. Name the 6 Oracle Architectural Choices: Dedicated Server - Shared Server - ___________ - Real Application Clusters (RAC) - Standby DB - Maximum Available Architecture (MAA)
The Oracle Instance
Connection Pooling
Alert Log
Dedicated Account
14. An important configuration file related to the users starting a database session is the __________
Oracle Home
Candidate Key
Cookies
Listener.ora
15. What is typically the largest portion of the SGA?
tnsnames.ora.
Flashback Recovery Area
The Buffer Cache
The Oracle Instance
16. A _____ _____ can be created to store blocks within the Buffer Cache that are rarely reused.
Checkpoint Process (CKPT)
Recycle Pool
Oracle's Data Guard Technology
2 - same size
17. 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.
Listener.ora
Double
Data blocks (or pages)
RAC - Real Application Clusters
18. Other things to consider when determining disk space are _____ & Undo / Temp space.
SQL Deficiencies
System Monitor (SMON)
SYSTEM / SYSAUX tablespaces
PL/SQL
19. This is a queue of Undo and Redo entries.
Instant Client
Alert Log
DDL - Database Definition Language
Log Buffer
20. In which log are events such as startup - shutdown - DDL operations and space shortages written?
Foreground Process
Alert Log
Shared pool
tnsnames.ora
21. 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
pfile/spfile
Log Buffer
Net Configuration Assistant (NetCA)
Transaction Management
22. 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
23. Which Oracle Architecture combines RAC and Standby technology?
Maximum Available Architecture (MAA)
8KB
RAC - Real Application Clusters
Database Writer (DBWR)
24. 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)
Cookies
Database
Foreground Process
25. The _____ property of a transaction ensures that the transaction does not compromise the integrity of the database.
Maximum Available Architecture (MAA)
SYSTEM / SYSAUX tablespaces
Keep Pool
Consistency
26. What tool is used to automated the process of Redo information being shipped from the Main DB and applied to the Standby DB?
Database Creation Assistant (DBCA)
Oracle Data Guard
Transaction Management
Log Writer
27. INSERT - UPDATE - ________ are examples of DML - Database Manipulation Language
DISPLAY
Data blocks (or pages)
DELETE & MERGE
SQL Deficiencies
28. In which Oracle Architecture does the client communicate with an ODB Dispatcher Process which has a Request Queue and a Response Queue?
Latches
Shared Server
SYSTEM / SYSAUX tablespaces
Standard Connection Pooling (Prior to 11g)
29. The 6 Background Processes: Database Writer (DBWWR) - Log Writer (LGWR) - Archiver (ARCH) - ___________ - Process Monitor (PMON) - System Monitor (SMON)
Database Writer (DBWR)
Checkpoint Process (CKPT)
Process Monitor (PMON)
Durability
30. 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
DISPLAY
Database Writer (DBWR)
Trigger Operations
31. What is the private work area in computer memory which each Oracle server process uses to hold intermediate results (temp files) called?
The Buffer Cache
Redo Log Files
Trigger Operations
Program Global Area
32. In Connection Pooling the information generated by the autonomous tasks not preserved in RAM - but saved in _______ or in the DB itself
Cookies
Kernel Settings
Recycle Pool
DML - Database Manipulation Language
33. The process responsible for transferring all Undo and Redo entries in the Log Buffer to the Redo Log Files.
Embedded SQL
tnsnames.ora.
Maximum Available Architecture (MAA)
Log Writer (LGWR)
34. The various Oracle processes coordinate their access to the areas of the SGA by using IPC - Interprocess Communication mechanisms called _______
DDL - Database Definition Language
Latches
DELETE & MERGE
The Shared Pool
35. The Oracle Instance is composed of: Foreground Processes - Background Processes - ___________
Shared Server
SYSTEM / SYSAUX tablespaces
Memory area
SGA - System Global Area
36. The very large __________ shared by all Oracle processes is the SGA - System Global Area
Memory area
Dedicated Account
Log Buffer
DDL - Database Definition Language
37. The _____ property ensures that once all the steps in a transaction have been competed successfully - the results are considered permanent.
Durability
DISPLAY
DELETE & MERGE
The Shared Pool
38. In which Oracle Architecture can additional Instances be added to the cluster to scale out instead of scaling up?
PL/SQL
Recycle Pool
Real Application Clusters (RAC)
Archiver
39. In which log is a record written every time a user establishes a connection to the database?
Oracle Home
Listener Log
Database Creation Assistant (DBCA)
DML - Database Manipulation Language
40. The location of backup copies of the data files is traditionally referred to as ________
Listener
SGA - System Global Area
8KB
Flashback Recovery Area
41. In a UNIX or Linux environment - you will have to mount the _____ _____ and enable an X Windows environment for the use of _____.
SQL*Plus
Durability
Product Disks - OUI (Oracle Universal Installer)
Double
42. Applications developed to communicate with Oracle DBs use what type of SQL?
Embedded SQL
Isolation
Tablespaces
pfile/spfile
43. This process is responsible for any cleanup activities necessary if the database is restarted after an abnormal shutdown resulting from system failure.
Log Writer
Listener Log
Atomic
System Monitor (SMON)
44. A mirrored set of redo log files is called a ________
Redo Log Group
8KB
Double
Program Global Area
45. What describes the various computer processes resident in computer memory and memory areas shared by these processes?
SYSTEM / SYSAUX tablespaces
Log Writer
pfile/spfile
Instance
46. These help ensure that the effects of a user's transaction are Durable (even in the event of a computer failure)
Redo Log Files
Net Configuration Assistant (NetCA)
DELETE & MERGE
Durability
47. In which Oracle Architecture is each connection handled by a dedicated Oracle process?
Product Disks - OUI (Oracle Universal Installer)
Dedicated Server
Memory area
Instance
48. A Dedicated _____ _____ is typically started whenever a user connects to the database.
Foreground Process
Control File
Log Writer
Memory area
49. In a UNIX or Linux environment - you will need to install and run Oracle using a __________.
System Monitor (SMON)
Dedicated Account
Product Disks - OUI (Oracle Universal Installer)
DML - Database Manipulation Language
50. Data Files store your _____ & _____.
Shared pool
Instant Client
Tables - Indexes
Standard Connection Pooling (Prior to 11g)