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. 3 ______________: Check - Uniqueness - Referential
Block Size - * they should match
Data Integrity Constraints
Real Application Clusters (RAC)
Tablespaces
2. Configuration file that contains location information for databases
Data blocks (or pages)
tnsnames.ora
Shared Server
Dedicated Server
3. What is the private work area in computer memory which each Oracle server process uses to hold intermediate results (temp files) called?
COMMIT.
System Monitor (SMON)
Program Global Area
Candidate Key
4. In a UNIX or Linux environment - you will also need to use the root account to perform a few tasks such as modifying the __________.
Program Global Area
Data blocks (or pages)
Kernel Settings
Oracle Home
5. Data Files store your _____ & _____.
Keep Pool
DML - Database Manipulation Language
Tables - Indexes
tnsnames.ora.
6. What is typically the largest portion of the SGA?
The Buffer Cache
DML - Database Manipulation Language
Listener.ora
Control File
7. Type of SQL statements used to create and modify objects
Maximum Available Architecture (MAA)
DDL - Database Definition Language
tnsnames.ora.
Transaction Management
8. The various Oracle processes coordinate their access to the areas of the SGA by using IPC - Interprocess Communication mechanisms called _______
Checkpoint Process (CKPT)
Tablespaces
Shared pool
Latches
9. A special _____ _____ can be created within the Buffer Cache to store data blocks from frequently used data tables - such as lookup tables.
DDL - Database Definition Language
On-Line Transaction Processing (OLTP)
Embedded SQL
Keep Pool
10. The _____ property of a transaction ensures that the transaction does not compromise the integrity of the database.
Consistency
Foreground Process
SQL*Plus
Net Configuration Assistant (NetCA)
11. When a redo log file fills up - an Oracle component called the _____ makes one of more copies of it.
DML - Database Manipulation Language
Real Application Clusters (RAC)
Archiver
Real Application Clusters (RAC)
12. The SYSTEM tablespace - which stores only tables containing information about the rest of the database - is called the ___________
The Oracle Instance
Data Dictionary
Log Buffer
Real Application Clusters (RAC)
13. When Application Tier Processes communicate with a Connection Broker - which uses a Connection Pool - this is called _________________
Database Writer (DBWR)
<tablespace><number>.dbf - or - <tablespace><number>.ora
Product Disks - OUI (Oracle Universal Installer)
Database Resident Connection Pooling (DRCP) (11g Only)
14. A Dedicated _____ _____ is typically started whenever a user connects to the database.
Maximum Available Architecture (MAA)
Oracle Data Guard
Foreground Process
Shared Server
15. The engine that processes requests for data from the database is __________
Memory area
Tablespaces
The Oracle Instance
Database Resident Connection Pooling (DRCP) (11g Only)
16. The process responsible for transferring all Undo and Redo entries in the Log Buffer to the Redo Log Files.
Instance
Archiver
Log Writer (LGWR)
Process Monitor (PMON)
17. An important configuration file related to the users starting a database session is the __________
DELETE & MERGE
Log Buffer
Isolation
Listener.ora
18. What tool is used to automated the process of Redo information being shipped from the Main DB and applied to the Standby DB?
Memory area
SQL Deficiencies
Database
Oracle Data Guard
19. What is produces every time certain severe errors occur?
Trace File
Cookies
Listener.ora
Redo Log Files
20. The process responsible for making copies of the Redo Log Files when they fill up.
Log Writer (LGWR)
Connection Pooling
<tablespace><number>.dbf - or - <tablespace><number>.ora
Archiver (ARCH)
21. 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?
Redo Log Files
Listener
Atomic
Real Application Clusters (RAC)
22. The very large __________ shared by all Oracle processes is the SGA - System Global Area
Latches
Durability
Memory area
Keep Pool
23. In which Oracle Architecture does the client communicate with an ODB Dispatcher Process which has a Request Queue and a Response Queue?
Shared Server
Trace File
Product Disks - OUI (Oracle Universal Installer)
Durability
24. These help ensure that the effects of a user's transaction are Durable (even in the event of a computer failure)
Redo Log Files
Consistency
<tablespace><number>.dbf - or - <tablespace><number>.ora
Trigger Operations
25. 2 tablespaces which are always created by and whose names are mandated by Oracle
Trace File
tnsnames.ora
Data Dictionary
SYSTEM & SYSAUX
26. A _____ _____ can be created to store blocks within the Buffer Cache that are rarely reused.
RAC - Real Application Clusters
tnsnames.ora.
Recycle Pool
Atomic
27. A unique part of a record is called__________
2 - same size
RAC - Real Application Clusters
Candidate Key
Redo Log Group
28. 3 ___________: Redundancy - Nullable Data Items - Duplicate Data Records
PL/SQL
SQL Deficiencies
Net Configuration Assistant (NetCA)
Product Disks - OUI (Oracle Universal Installer)
29. A mirrored set of redo log files is called a ________
DELETE & MERGE
Shared pool
Database Creation Assistant (DBCA)
Redo Log Group
30. 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.
DML - Database Manipulation Language
Kernel Settings
DISPLAY
Connection Pooling
31. The Oracle Instance is composed of: Foreground Processes - Background Processes - ___________
Data blocks (or pages)
COMMIT.
SGA - System Global Area
Shared Server
32. This process is responsible for any cleanup activities necessary if the database is restarted after an abnormal shutdown resulting from system failure.
Instant Client
Listener Log
System Monitor (SMON)
Cookies
33. In which Oracle Architecture is each connection handled by a dedicated Oracle process?
Dedicated Server
Cookies
Isolation
tnsnames.ora
34. Oracle Provided Command-Line Tool - * used to automate tasks
Candidate Key
SQL*Plus
Tables - Indexes
Alert Log
35. Applications developed to communicate with Oracle DBs use what type of SQL?
SYSTEM & SYSAUX
Embedded SQL
Data blocks (or pages)
tnsnames.ora
36. The location of backup copies of the data files is traditionally referred to as ________
Transaction Management
DML - Database Manipulation Language
Database Creation Assistant (DBCA)
Flashback Recovery Area
37. 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
38. At frequent intervals - the contents of the Data Caches are synchronized with the Data Files. This is performed by a dedicated process called ____________
Foreground Process
Dedicated Account
Checkpoint Process (CKPT)
SQL*Plus
39. SGA - System Global Area is divided into distinct areas such as the buffer cache - the ________ and the log buffer.
Process Monitor (PMON)
Product Disks - OUI (Oracle Universal Installer)
Shared pool
Transaction Management
40. Data files are logically grouped into _____ and are usually given descriptive names such as DATA - INDEX - UNDO & TEMP.
System Monitor (SMON)
Tablespaces
Double
DISPLAY
41. In a UNIX or Linux environment - you will need to install and run Oracle using a __________.
Isolation
DDL - Database Definition Language
Dedicated Account
Database Writer (DBWR)
42. Name the 6 Oracle Architectural Choices: Dedicated Server - Shared Server - ___________ - Real Application Clusters (RAC) - Standby DB - Maximum Available Architecture (MAA)
Data Integrity Constraints
Cookies
The Oracle Instance
Connection Pooling
43. The process responsible for transferring all modified data blocks in the Data Caches to the Data Files.
Database Writer (DBWR)
Kernel Settings
Real Application Clusters (RAC)
Process Monitor (PMON)
44. Which Oracle Architecture combines RAC and Standby technology?
Shared pool
Maximum Available Architecture (MAA)
Control File
Redo Log Group
45. INSERT - UPDATE - ________ are examples of DML - Database Manipulation Language
Listener Log
Log Writer (LGWR)
DELETE & MERGE
Net Configuration Assistant (NetCA)
46. 3 Physical Operations of a Transaction: Index Updates - ___________ - Recursive Operations
System Monitor (SMON)
Tables - Indexes
Trigger Operations
Control File
47. Programs that can be stored in an Oracle Database are written in
Transaction Management
Standard Connection Pooling (Prior to 11g)
Trigger Operations
PL/SQL
48. This wakes up periodically and copies any accumulated Undo and Redo entries to the Redo Log File.
SQL*Plus
Log Writer
Standard Connection Pooling (Prior to 11g)
Flashback Recovery Area
49. Beginning Oracle 10g - it provides the most essential software in a bundle called an _______.
Instant Client
Program Global Area
Database
Foreground Process
50. This is a queue of Undo and Redo entries.
SQL Deficiencies
Log Buffer
Connection Pooling
Database