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. In a UNIX or Linux environment - you will also need to use the root account to perform a few tasks such as modifying the __________.
Consistency
Kernel Settings
2 - same size
Process Monitor (PMON)
2. An important configuration file related to the users starting a database session is the __________
DISPLAY
Listener.ora
Keep Pool
Archiver (ARCH)
3. Typical convention for naming data files
SQL Deficiencies
<tablespace><number>.dbf - or - <tablespace><number>.ora
tnsnames.ora
Oracle's Data Guard Technology
4. A mirrored set of redo log files is called a ________
Archiver (ARCH)
Dedicated Server
Redo Log Group
Flashback Recovery Area
5. The Oracle Instance is composed of: Foreground Processes - Background Processes - ___________
DELETE & MERGE
SGA - System Global Area
Listener
Shared Server
6. Core Features of any DBMS are: ___________ - Data Integrity - Security
Transaction Management
Redo Log Files
The Buffer Cache
Latches
7. What program is used to create a Listener?
Redo Log Group
Foreground Process
Standard Connection Pooling (Prior to 11g)
Net Configuration Assistant (NetCA)
8. 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.
The Shared Pool
Oracle's Data Guard Technology
Memory area
9. The SYSTEM tablespace - which stores only tables containing information about the rest of the database - is called the ___________
Kernel Settings
Data Dictionary
DISPLAY
Shared Server
10. 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
11. This wakes up periodically and copies any accumulated Undo and Redo entries to the Redo Log File.
Maximum Available Architecture (MAA)
tnsnames.ora
Log Writer
Archiver (ARCH)
12. In the Shared Server the State Information is kept in the SGA for _______________
The Oracle Instance
DDL - Database Definition Language
On-Line Transaction Processing (OLTP)
Log Buffer
13. What tool is used to automated the process of Redo information being shipped from the Main DB and applied to the Standby DB?
SYSTEM & SYSAUX
Consistency
Durability
Oracle Data Guard
14. 3 ______________: Check - Uniqueness - Referential
Durability
On-Line Transaction Processing (OLTP)
Data Integrity Constraints
8KB
15. A DBMS ensures transactions are: _______ - Consistent - Isolated - Durable
Block Size - * they should match
Isolation
Trigger Operations
Atomic
16. Other things to consider when determining disk space are _____ & Undo / Temp space.
Latches
RAC - Real Application Clusters
SYSTEM / SYSAUX tablespaces
Log Writer
17. At frequent intervals - the contents of the Data Caches are synchronized with the Data Files. This is performed by a dedicated process called ____________
Log Writer (LGWR)
Connection Pooling
Checkpoint Process (CKPT)
Real Application Clusters (RAC)
18. The simplest way to create a database is to use the __________.
Listener.ora
Database Creation Assistant (DBCA)
Active Workload Repository (AWR)
tnsnames.ora
19. In a UNIX or Linux environment - you will need to install and run Oracle using a __________.
DML - Database Manipulation Language
Dedicated Account
Oracle Data Guard
Data Integrity Constraints
20. 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.
Data Integrity Constraints
DISPLAY
COMMIT.
8KB
21. In Connection Pooling the information generated by the autonomous tasks not preserved in RAM - but saved in _______ or in the DB itself
DML - Database Manipulation Language
Flashback Recovery Area
Cookies
Database Writer (DBWR)
22. A large component of the SGA - which is best-known for use in caching query execution plans is called _________
The Shared Pool
Log Writer (LGWR)
Log Buffer
Isolation
23. Programs that can be stored in an Oracle Database are written in
Tables - Indexes
Log Writer (LGWR)
Database Writer (DBWR)
PL/SQL
24. SGA - System Global Area is divided into distinct areas such as the buffer cache - the ________ and the log buffer.
SGA - System Global Area
Shared pool
Real Application Clusters (RAC)
Redo Log Files
25. The very large __________ shared by all Oracle processes is the SGA - System Global Area
Dedicated Server
Memory area
Standard Connection Pooling (Prior to 11g)
Embedded SQL
26. 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.
Recycle Pool
Listener Log
Program Global Area
Control File
27. The engine that processes requests for data from the database is __________
The Oracle Instance
Isolation
On-Line Transaction Processing (OLTP)
Trigger Operations
28. Type of a SQL statement used to modify data
Product Disks - OUI (Oracle Universal Installer)
pfile/spfile
The Shared Pool
DML - Database Manipulation Language
29. The process responsible for making copies of the Redo Log Files when they fill up.
Log Writer (LGWR)
DISPLAY
On-Line Transaction Processing (OLTP)
Archiver (ARCH)
30. Data files are logically grouped into _____ and are usually given descriptive names such as DATA - INDEX - UNDO & TEMP.
pfile/spfile
Tablespaces
Alert Log
Consistency
31. What is the private work area in computer memory which each Oracle server process uses to hold intermediate results (temp files) called?
tnsnames.ora.
Program Global Area
Durability
Cookies
32. The files on the storage disks connected to the database host is the __________
Database
Tables - Indexes
Isolation
DDL - Database Definition Language
33. In which Oracle Architecture is each connection handled by a dedicated Oracle process?
Memory area
Dedicated Server
Redo Log Files
Isolation
34. 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)
Database Resident Connection Pooling (DRCP) (11g Only)
Listener Log
Trigger Operations
35. Beginning Oracle 10g - it provides the most essential software in a bundle called an _______.
Double
Instant Client
Oracle's Data Guard Technology
The Shared Pool
36. When a set of shared Application Tier Processes handle all requests - each of which maintain a persistent connection to the Database - this is called ______________
SYSTEM / SYSAUX tablespaces
Standard Connection Pooling (Prior to 11g)
Listener
Flashback Recovery Area
37. Transactions are Atomic or invisible from a logical perspective until the end of the transaction is indicated by an explicit instruction such as _______
COMMIT.
Log Writer (LGWR)
The Buffer Cache
Trigger Operations
38. What describes the various computer processes resident in computer memory and memory areas shared by these processes?
Data Dictionary
Consistency
SYSTEM / SYSAUX tablespaces
Instance
39. A factor in the decision to assign a table or index to a particular tablespace is ___________
The Buffer Cache
Latches
Keep Pool
Block Size - * they should match
40. 2 tablespaces which are always created by and whose names are mandated by Oracle
SYSTEM & SYSAUX
RAC - Real Application Clusters
Dedicated Server
DML - Database Manipulation Language
41. This process is responsible for any cleanup activities necessary if the database is restarted after an abnormal shutdown resulting from system failure.
Redo Log Group
Product Disks - OUI (Oracle Universal Installer)
Database
System Monitor (SMON)
42. In a UNIX or Linux environment - you will have to mount the _____ _____ and enable an X Windows environment for the use of _____.
Listener Log
Product Disks - OUI (Oracle Universal Installer)
Data Integrity Constraints
Log Buffer
43. Oracle needs at least _____ redo log files and they should be the _____ _____.
2 - same size
Log Buffer
Connection Pooling
PL/SQL
44. These help ensure that the effects of a user's transaction are Durable (even in the event of a computer failure)
Redo Log Files
Maximum Available Architecture (MAA)
Memory area
Listener
45. 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
RAC - Real Application Clusters
Tablespaces
8KB
Oracle Data Guard
46. In which log is a record written every time a user establishes a connection to the database?
Database Writer (DBWR)
Control File
Listener Log
Dedicated Account
47. When Application Tier Processes communicate with a Connection Broker - which uses a Connection Pool - this is called _________________
Database Resident Connection Pooling (DRCP) (11g Only)
Tablespaces
Log Writer
Latches
48. The _____ property ensures that results produces by concurrently executing transactions are serialized.
SQL Deficiencies
Instant Client
Isolation
Recycle Pool
49. Data Files store your _____ & _____.
Log Writer (LGWR)
Transaction Management
tnsnames.ora.
Tables - Indexes
50. A unique part of a record is called__________
Archiver
Shared Server
Listener
Candidate Key