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. A DBMS ensures transactions are: _______ - Consistent - Isolated - Durable
Standard Connection Pooling (Prior to 11g)
Log Writer (LGWR)
Atomic
The Shared Pool
2. 2 tablespaces which are always created by and whose names are mandated by Oracle
SYSTEM & SYSAUX
Database Creation Assistant (DBCA)
Shared pool
The Shared Pool
3. In Connection Pooling the information generated by the autonomous tasks not preserved in RAM - but saved in _______ or in the DB itself
Log Writer (LGWR)
Recycle Pool
Log Buffer
Cookies
4. 3 Physical Operations of a Transaction: Index Updates - ___________ - Recursive Operations
Trigger Operations
Cookies
Durability
Recycle Pool
5. Name the 6 Oracle Architectural Choices: Dedicated Server - Shared Server - ___________ - Real Application Clusters (RAC) - Standby DB - Maximum Available Architecture (MAA)
SQL*Plus
Foreground Process
Connection Pooling
Archiver (ARCH)
6. This wakes up periodically and copies any accumulated Undo and Redo entries to the Redo Log File.
Oracle's Data Guard Technology
SQL Deficiencies
Log Writer
tnsnames.ora.
7. Commonly used block size of data blocks
8KB
Consistency
Database
DDL - Database Definition Language
8. The various Oracle processes coordinate their access to the areas of the SGA by using IPC - Interprocess Communication mechanisms called _______
Latches
Foreground Process
Keep Pool
Real Application Clusters (RAC)
9. Configuration file that contains location information for databases
Block Size - * they should match
Isolation
Maximum Available Architecture (MAA)
tnsnames.ora
10. 3 ___________: Redundancy - Nullable Data Items - Duplicate Data Records
SQL Deficiencies
Dedicated Server
Net Configuration Assistant (NetCA)
8KB
11. What describes the various computer processes resident in computer memory and memory areas shared by these processes?
Instance
Log Writer (LGWR)
tnsnames.ora
Net Configuration Assistant (NetCA)
12. 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
13. The process responsible for transferring all Undo and Redo entries in the Log Buffer to the Redo Log Files.
Real Application Clusters (RAC)
Log Writer (LGWR)
tnsnames.ora.
Archiver
14. In which Oracle Architecture is each connection handled by a dedicated Oracle process?
Dedicated Server
Transaction Management
Oracle Home
Database
15. What is typically the largest portion of the SGA?
The Shared Pool
Net Configuration Assistant (NetCA)
SGA - System Global Area
The Buffer Cache
16. This process watches the progress of the database connections.
Log Writer (LGWR)
pfile/spfile
Process Monitor (PMON)
PL/SQL
17. A Dedicated _____ _____ is typically started whenever a user connects to the database.
Log Writer
RAC - Real Application Clusters
Foreground Process
Database
18. What is the private work area in computer memory which each Oracle server process uses to hold intermediate results (temp files) called?
SQL Deficiencies
Data Dictionary
Connection Pooling
Program Global Area
19. When a redo log file fills up - an Oracle component called the _____ makes one of more copies of it.
Active Workload Repository (AWR)
Archiver
Flashback Recovery Area
Trigger Operations
20. A mirrored set of redo log files is called a ________
Redo Log Group
Program Global Area
RAC - Real Application Clusters
The Oracle Instance
21. Other things to consider when determining disk space are _____ & Undo / Temp space.
Connection Pooling
Consistency
Trigger Operations
SYSTEM / SYSAUX tablespaces
22. The process responsible for making copies of the Redo Log Files when they fill up.
Archiver (ARCH)
Real Application Clusters (RAC)
Listener Log
pfile/spfile
23. Type of SQL statements used to create and modify objects
Instance
Active Workload Repository (AWR)
DDL - Database Definition Language
Keep Pool
24. In the Shared Server the State Information is kept in the SGA for _______________
Candidate Key
Kernel Settings
Database
On-Line Transaction Processing (OLTP)
25. The simplest way to create a database is to use the __________.
Listener
Database Creation Assistant (DBCA)
Oracle Home
Data blocks (or pages)
26. The space within data files is organized into
Database
Data blocks (or pages)
The Shared Pool
Trigger Operations
27. Data Files store your _____ & _____.
Block Size - * they should match
Data blocks (or pages)
Embedded SQL
Tables - Indexes
28. The location of the database software
Log Writer
SYSTEM & SYSAUX
pfile/spfile
Oracle Home
29. Before you can create the first DB on a system - you must first configure a _____.
Consistency
The Oracle Instance
Memory area
Listener
30. This is a queue of Undo and Redo entries.
Flashback Recovery Area
Checkpoint Process (CKPT)
Control File
Log Buffer
31. In which log is a record written every time a user establishes a connection to the database?
Archiver (ARCH)
DISPLAY
Data Integrity Constraints
Listener Log
32. When Application Tier Processes communicate with a Connection Broker - which uses a Connection Pool - this is called _________________
Double
Listener
Database Resident Connection Pooling (DRCP) (11g Only)
DELETE & MERGE
33. Beginning Oracle 10g - it provides the most essential software in a bundle called an _______.
Instant Client
DDL - Database Definition Language
Kernel Settings
2 - same size
34. The Oracle Instance is composed of: Foreground Processes - Background Processes - ___________
<tablespace><number>.dbf - or - <tablespace><number>.ora
Log Writer
COMMIT.
SGA - System Global Area
35. 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.
The Buffer Cache
Control File
DML - Database Manipulation Language
DISPLAY
36. 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
Real Application Clusters (RAC)
Database Resident Connection Pooling (DRCP) (11g Only)
On-Line Transaction Processing (OLTP)
37. The _____ property ensures that results produces by concurrently executing transactions are serialized.
Isolation
Archiver
Net Configuration Assistant (NetCA)
pfile/spfile
38. In a UNIX or Linux environment - you will need to install and run Oracle using a __________.
Dedicated Account
The Oracle Instance
Flashback Recovery Area
Data blocks (or pages)
39. The engine that processes requests for data from the database is __________
System Monitor (SMON)
Net Configuration Assistant (NetCA)
The Oracle Instance
Redo Log Files
40. A _____ _____ can be created to store blocks within the Buffer Cache that are rarely reused.
Recycle Pool
The Shared Pool
Dedicated Account
Checkpoint Process (CKPT)
41. Typical convention for naming data files
Data Dictionary
Redo Log Group
<tablespace><number>.dbf - or - <tablespace><number>.ora
Atomic
42. A factor in the decision to assign a table or index to a particular tablespace is ___________
Tables - Indexes
Block Size - * they should match
tnsnames.ora
DML - Database Manipulation Language
43. 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
Kernel Settings
The Buffer Cache
Database
pfile/spfile
44. A unique part of a record is called__________
Candidate Key
Redo Log Files
Instant Client
8KB
45. These help ensure that the effects of a user's transaction are Durable (even in the event of a computer failure)
Embedded SQL
Program Global Area
Redo Log Files
pfile/spfile
46. The _____ property of a transaction ensures that the transaction does not compromise the integrity of the database.
Redo Log Group
Listener Log
Trace File
Consistency
47. The process responsible for transferring all modified data blocks in the Data Caches to the Data Files.
2 - same size
Keep Pool
Database Writer (DBWR)
<tablespace><number>.dbf - or - <tablespace><number>.ora
48. Programs that can be stored in an Oracle Database are written in
PL/SQL
The Buffer Cache
Process Monitor (PMON)
Keep Pool
49. This process is responsible for any cleanup activities necessary if the database is restarted after an abnormal shutdown resulting from system failure.
Transaction Management
System Monitor (SMON)
tnsnames.ora.
PL/SQL
50. The SYSTEM tablespace - which stores only tables containing information about the rest of the database - is called the ___________
On-Line Transaction Processing (OLTP)
Data Dictionary
SQL Deficiencies
Oracle Data Guard
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