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. The simplest way to create a database is to use the __________.
On-Line Transaction Processing (OLTP)
Instant Client
Atomic
Database Creation Assistant (DBCA)
2. A _____ _____ can be created to store blocks within the Buffer Cache that are rarely reused.
Trace File
SGA - System Global Area
Recycle Pool
Listener Log
3. The space within data files is organized into
DML - Database Manipulation Language
Listener.ora
Recycle Pool
Data blocks (or pages)
4. Commonly used block size of data blocks
Log Writer (LGWR)
8KB
Oracle Data Guard
Latches
5. Typical convention for naming data files
Cookies
Data Integrity Constraints
Listener
<tablespace><number>.dbf - or - <tablespace><number>.ora
6. 3 ___________: Redundancy - Nullable Data Items - Duplicate Data Records
SYSTEM & SYSAUX
SQL Deficiencies
Redo Log Group
tnsnames.ora
7. 2 tablespaces which are always created by and whose names are mandated by Oracle
SYSTEM & SYSAUX
Log Buffer
Oracle Home
Oracle's Data Guard Technology
8. The SYSTEM tablespace - which stores only tables containing information about the rest of the database - is called the ___________
Isolation
Data Dictionary
Double
Log Buffer
9. A mirrored set of redo log files is called a ________
Block Size - * they should match
tnsnames.ora
Redo Log Group
Tablespaces
10. A factor in the decision to assign a table or index to a particular tablespace is ___________
Redo Log Group
Block Size - * they should match
Cookies
Listener.ora
11. Data files are logically grouped into _____ and are usually given descriptive names such as DATA - INDEX - UNDO & TEMP.
DDL - Database Definition Language
Tablespaces
The Oracle Instance
Foreground Process
12. The various Oracle processes coordinate their access to the areas of the SGA by using IPC - Interprocess Communication mechanisms called _______
Latches
Keep Pool
Data Dictionary
Listener.ora
13. In which log is a record written every time a user establishes a connection to the database?
PL/SQL
Keep Pool
Listener Log
Database
14. The process responsible for transferring all modified data blocks in the Data Caches to the Data Files.
Dedicated Account
Database Writer (DBWR)
Flashback Recovery Area
DDL - Database Definition Language
15. In which log are events such as startup - shutdown - DDL operations and space shortages written?
Real Application Clusters (RAC)
Alert Log
Candidate Key
Cookies
16. When Application Tier Processes communicate with a Connection Broker - which uses a Connection Pool - this is called _________________
Cookies
Database Resident Connection Pooling (DRCP) (11g Only)
Embedded SQL
Database
17. What tool is used to automated the process of Redo information being shipped from the Main DB and applied to the Standby DB?
The Shared Pool
Oracle Data Guard
Durability
SYSTEM / SYSAUX tablespaces
18. Transactions are Atomic or invisible from a logical perspective until the end of the transaction is indicated by an explicit instruction such as _______
tnsnames.ora.
<tablespace><number>.dbf - or - <tablespace><number>.ora
COMMIT.
Oracle's Data Guard Technology
19. This process watches the progress of the database connections.
Process Monitor (PMON)
Standard Connection Pooling (Prior to 11g)
Durability
Trigger Operations
20. 3 ______________: Check - Uniqueness - Referential
On-Line Transaction Processing (OLTP)
Data Integrity Constraints
SYSTEM / SYSAUX tablespaces
Database Creation Assistant (DBCA)
21. What is produces every time certain severe errors occur?
Cookies
SGA - System Global Area
8KB
Trace File
22. What is the private work area in computer memory which each Oracle server process uses to hold intermediate results (temp files) called?
Listener.ora
Log Writer (LGWR)
Tables - Indexes
Program Global Area
23. 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.
Active Workload Repository (AWR)
Shared Server
Listener.ora
tnsnames.ora.
24. Oracle Provided Command-Line Tool - * used to automate tasks
SQL*Plus
Net Configuration Assistant (NetCA)
Maximum Available Architecture (MAA)
8KB
25. The files on the storage disks connected to the database host is the __________
Shared pool
COMMIT.
Memory area
Database
26. In a UNIX or Linux environment - you will need to install and run Oracle using a __________.
Tablespaces
Latches
Product Disks - OUI (Oracle Universal Installer)
Dedicated Account
27. A standby database - which is kept in a separate data center - is kept synchronized with the production DB using this.
28. 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.
Database Writer (DBWR)
Double
Data blocks (or pages)
Flashback Recovery Area
29. Before you can create the first DB on a system - you must first configure a _____.
Latches
Trace File
Listener
Database
30. The SYSAUX tablespace is used to store ____________ - such as Statspack or Management Information.
SGA - System Global Area
PL/SQL
Archiver
Active Workload Repository (AWR)
31. A Dedicated _____ _____ is typically started whenever a user connects to the database.
Shared Server
The Shared Pool
Foreground Process
Flashback Recovery Area
32. A special _____ _____ can be created within the Buffer Cache to store data blocks from frequently used data tables - such as lookup tables.
Double
tnsnames.ora.
Log Writer
Keep Pool
33. In which Oracle Architecture does the client communicate with an ODB Dispatcher Process which has a Request Queue and a Response Queue?
Listener Log
Shared Server
Flashback Recovery Area
Net Configuration Assistant (NetCA)
34. Beginning Oracle 10g - it provides the most essential software in a bundle called an _______.
Standard Connection Pooling (Prior to 11g)
Archiver (ARCH)
Double
Instant Client
35. In which Oracle Architecture is each connection handled by a dedicated Oracle process?
SYSTEM & SYSAUX
Candidate Key
Dedicated Server
Dedicated Account
36. Core Features of any DBMS are: ___________ - Data Integrity - Security
Redo Log Files
Oracle's Data Guard Technology
Atomic
Transaction Management
37. The _____ property of a transaction ensures that the transaction does not compromise the integrity of the database.
Consistency
DISPLAY
Shared Server
DDL - Database Definition Language
38. Data Files store your _____ & _____.
Log Writer
The Shared Pool
pfile/spfile
Tables - Indexes
39. Configuration file that contains location information for databases
Log Writer
tnsnames.ora
The Shared Pool
Embedded SQL
40. In which Oracle Architecture can additional Instances be added to the cluster to scale out instead of scaling up?
Instance
Shared pool
Real Application Clusters (RAC)
Checkpoint Process (CKPT)
41. The _____ property ensures that once all the steps in a transaction have been competed successfully - the results are considered permanent.
Real Application Clusters (RAC)
Instance
Program Global Area
Durability
42. The Oracle Instance is composed of: Foreground Processes - Background Processes - ___________
Control File
SGA - System Global Area
Consistency
Trigger Operations
43. 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.
Database Writer (DBWR)
Control File
DELETE & MERGE
Keep Pool
44. At frequent intervals - the contents of the Data Caches are synchronized with the Data Files. This is performed by a dedicated process called ____________
SYSTEM & SYSAUX
Real Application Clusters (RAC)
DML - Database Manipulation Language
Checkpoint Process (CKPT)
45. In a UNIX or Linux environment - you will have to mount the _____ _____ and enable an X Windows environment for the use of _____.
Data blocks (or pages)
Log Writer
Consistency
Product Disks - OUI (Oracle Universal Installer)
46. Programs that can be stored in an Oracle Database are written in
PL/SQL
Checkpoint Process (CKPT)
Listener Log
On-Line Transaction Processing (OLTP)
47. Oracle needs at least _____ redo log files and they should be the _____ _____.
Latches
Data blocks (or pages)
Database Creation Assistant (DBCA)
2 - same size
48. The very large __________ shared by all Oracle processes is the SGA - System Global Area
Log Writer
Flashback Recovery Area
Memory area
Listener
49. The _____ property ensures that results produces by concurrently executing transactions are serialized.
Isolation
Data Dictionary
On-Line Transaction Processing (OLTP)
Archiver
50. Name the 6 Oracle Architectural Choices: Dedicated Server - Shared Server - ___________ - Real Application Clusters (RAC) - Standby DB - Maximum Available Architecture (MAA)
Data blocks (or pages)
Connection Pooling
The Shared Pool
Checkpoint Process (CKPT)