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. This is a queue of Undo and Redo entries.
Log Buffer
SYSTEM / SYSAUX tablespaces
Archiver (ARCH)
COMMIT.
2. What tool is used to automated the process of Redo information being shipped from the Main DB and applied to the Standby DB?
Real Application Clusters (RAC)
tnsnames.ora
Redo Log Files
Oracle Data Guard
3. In the Shared Server the State Information is kept in the SGA for _______________
Kernel Settings
The Oracle Instance
On-Line Transaction Processing (OLTP)
Isolation
4. When a redo log file fills up - an Oracle component called the _____ makes one of more copies of it.
tnsnames.ora.
Archiver
Flashback Recovery Area
Memory area
5. Transactions are Atomic or invisible from a logical perspective until the end of the transaction is indicated by an explicit instruction such as _______
The Buffer Cache
SGA - System Global Area
Checkpoint Process (CKPT)
COMMIT.
6. A large component of the SGA - which is best-known for use in caching query execution plans is called _________
Redo Log Group
2 - same size
The Shared Pool
SYSTEM / SYSAUX tablespaces
7. Programs that can be stored in an Oracle Database are written in
Active Workload Repository (AWR)
PL/SQL
pfile/spfile
Log Writer (LGWR)
8. A DBMS ensures transactions are: _______ - Consistent - Isolated - Durable
Redo Log Files
Tablespaces
PL/SQL
Atomic
9. 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
10. This process watches the progress of the database connections.
Recycle Pool
Memory area
Database Resident Connection Pooling (DRCP) (11g Only)
Process Monitor (PMON)
11. The process responsible for making copies of the Redo Log Files when they fill up.
Data blocks (or pages)
Durability
Archiver (ARCH)
COMMIT.
12. In a UNIX or Linux environment - you will need to install and run Oracle using a __________.
Latches
Real Application Clusters (RAC)
Listener
Dedicated Account
13. In a UNIX or Linux environment - you will have to mount the _____ _____ and enable an X Windows environment for the use of _____.
Net Configuration Assistant (NetCA)
Dedicated Server
Candidate Key
Product Disks - OUI (Oracle Universal Installer)
14. The SYSTEM tablespace - which stores only tables containing information about the rest of the database - is called the ___________
Dedicated Account
Data Dictionary
Checkpoint Process (CKPT)
Oracle Data Guard
15. The process responsible for transferring all modified data blocks in the Data Caches to the Data Files.
Standard Connection Pooling (Prior to 11g)
DML - Database Manipulation Language
Database Writer (DBWR)
RAC - Real Application Clusters
16. Applications developed to communicate with Oracle DBs use what type of SQL?
Embedded SQL
Trace File
Database Creation Assistant (DBCA)
Data Integrity Constraints
17. Beginning Oracle 10g - it provides the most essential software in a bundle called an _______.
SGA - System Global Area
Instant Client
Listener Log
Database Creation Assistant (DBCA)
18. Other things to consider when determining disk space are _____ & Undo / Temp space.
SYSTEM / SYSAUX tablespaces
Oracle's Data Guard Technology
Real Application Clusters (RAC)
The Buffer Cache
19. When Application Tier Processes communicate with a Connection Broker - which uses a Connection Pool - this is called _________________
Database Resident Connection Pooling (DRCP) (11g Only)
Database Writer (DBWR)
Real Application Clusters (RAC)
Log Writer
20. SGA - System Global Area is divided into distinct areas such as the buffer cache - the ________ and the log buffer.
Archiver
Shared pool
RAC - Real Application Clusters
Redo Log Files
21. These help ensure that the effects of a user's transaction are Durable (even in the event of a computer failure)
Checkpoint Process (CKPT)
Redo Log Files
Archiver (ARCH)
Standard Connection Pooling (Prior to 11g)
22. A special _____ _____ can be created within the Buffer Cache to store data blocks from frequently used data tables - such as lookup tables.
Flashback Recovery Area
SQL Deficiencies
Keep Pool
Dedicated Account
23. What is produces every time certain severe errors occur?
Log Buffer
Trace File
<tablespace><number>.dbf - or - <tablespace><number>.ora
Database Resident Connection Pooling (DRCP) (11g Only)
24. The Oracle Instance is composed of: Foreground Processes - Background Processes - ___________
SGA - System Global Area
Embedded SQL
Keep Pool
Log Buffer
25. Oracle needs at least _____ redo log files and they should be the _____ _____.
DELETE & MERGE
Redo Log Group
2 - same size
Double
26. 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?
SQL Deficiencies
Embedded SQL
The Oracle Instance
Real Application Clusters (RAC)
27. In which log are events such as startup - shutdown - DDL operations and space shortages written?
PL/SQL
Alert Log
SQL Deficiencies
The Buffer Cache
28. 3 ______________: Check - Uniqueness - Referential
Oracle Data Guard
Database Creation Assistant (DBCA)
Data Integrity Constraints
<tablespace><number>.dbf - or - <tablespace><number>.ora
29. The SYSAUX tablespace is used to store ____________ - such as Statspack or Management Information.
Active Workload Repository (AWR)
Atomic
Flashback Recovery Area
Data Dictionary
30. Name the 6 Oracle Architectural Choices: Dedicated Server - Shared Server - ___________ - Real Application Clusters (RAC) - Standby DB - Maximum Available Architecture (MAA)
Connection Pooling
Program Global Area
Keep Pool
Tablespaces
31. The process responsible for transferring all Undo and Redo entries in the Log Buffer to the Redo Log Files.
Instance
Maximum Available Architecture (MAA)
Log Writer (LGWR)
8KB
32. 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
Control File
Keep Pool
Redo Log Files
33. In which log is a record written every time a user establishes a connection to the database?
Transaction Management
DDL - Database Definition Language
Listener Log
PL/SQL
34. In which Oracle Architecture can additional Instances be added to the cluster to scale out instead of scaling up?
Data Integrity Constraints
Real Application Clusters (RAC)
Log Buffer
Connection Pooling
35. 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.
Double
COMMIT.
Real Application Clusters (RAC)
Maximum Available Architecture (MAA)
36. The location of backup copies of the data files is traditionally referred to as ________
Database Writer (DBWR)
Flashback Recovery Area
Embedded SQL
Oracle's Data Guard Technology
37. A Dedicated _____ _____ is typically started whenever a user connects to the database.
Listener Log
Foreground Process
Maximum Available Architecture (MAA)
DML - Database Manipulation Language
38. Commonly used block size of data blocks
8KB
SQL*Plus
Oracle Data Guard
Redo Log Group
39. Core Features of any DBMS are: ___________ - Data Integrity - Security
Log Writer (LGWR)
Transaction Management
Consistency
Listener
40. In which Oracle Architecture is each connection handled by a dedicated Oracle process?
<tablespace><number>.dbf - or - <tablespace><number>.ora
Dedicated Server
Trace File
COMMIT.
41. 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.
Durability
Archiver
Control File
Memory area
42. What program is used to create a Listener?
Tables - Indexes
Net Configuration Assistant (NetCA)
DDL - Database Definition Language
Dedicated Account
43. 3 ___________: Redundancy - Nullable Data Items - Duplicate Data Records
Tables - Indexes
Trace File
SQL Deficiencies
Instance
44. In which Oracle Architecture does the client communicate with an ODB Dispatcher Process which has a Request Queue and a Response Queue?
Archiver (ARCH)
Shared Server
Data Integrity Constraints
Database Writer (DBWR)
45. The 6 Background Processes: Database Writer (DBWWR) - Log Writer (LGWR) - Archiver (ARCH) - ___________ - Process Monitor (PMON) - System Monitor (SMON)
Dedicated Server
Keep Pool
Memory area
Checkpoint Process (CKPT)
46. This process is responsible for any cleanup activities necessary if the database is restarted after an abnormal shutdown resulting from system failure.
System Monitor (SMON)
Checkpoint Process (CKPT)
Redo Log Files
Data blocks (or pages)
47. Oracle Provided Command-Line Tool - * used to automate tasks
DELETE & MERGE
SQL*Plus
Redo Log Files
Block Size - * they should match
48. 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
Trace File
Real Application Clusters (RAC)
Log Writer (LGWR)
49. A mirrored set of redo log files is called a ________
On-Line Transaction Processing (OLTP)
Trace File
SQL Deficiencies
Redo Log Group
50. The _____ property ensures that results produces by concurrently executing transactions are serialized.
Isolation
Double
2 - same size
Tablespaces
Can you answer 50 questions in 15 minutes?
Let me suggest you:
Browse all subjects
Browse all tests
Most popular tests
Major Subjects
Tests & Exams
AP
CLEP
DSST
GRE
SAT
GMAT
Certifications
CISSP go to https://www.isc2.org/
PMP
ITIL
RHCE
MCTS
More...
IT Skills
Android Programming
Data Modeling
Objective C Programming
Basic Python Programming
Adobe Illustrator
More...
Business Skills
Advertising Techniques
Business Accounting Basics
Business Strategy
Human Resource Management
Marketing Basics
More...
Soft Skills
Body Language
People Skills
Public Speaking
Persuasion
Job Hunting And Resumes
More...
Vocabulary
GRE Vocab
SAT Vocab
TOEFL Essential Vocab
Basic English Words For All
Global Words You Should Know
Business English
More...
Languages
AP German Vocab
AP Latin Vocab
SAT Subject Test: French
Italian Survival
Norwegian Survival
More...
Engineering
Audio Engineering
Computer Science Engineering
Aerospace Engineering
Chemical Engineering
Structural Engineering
More...
Health Sciences
Basic Nursing Skills
Health Science Language Fundamentals
Veterinary Technology Medical Language
Cardiology
Clinical Surgery
More...
English
Grammar Fundamentals
Literary And Rhetorical Vocab
Elements Of Style Vocab
Introduction To English Major
Complete Advanced Sentences
Literature
Homonyms
More...
Math
Algebra Formulas
Basic Arithmetic: Measurements
Metric Conversions
Geometric Properties
Important Math Facts
Number Sense Vocab
Business Math
More...
Other Major Subjects
Science
Economics
History
Law
Performing-arts
Cooking
Logic & Reasoning
Trivia
Browse all subjects
Browse all tests
Most popular tests