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
Transaction Management
Checkpoint Process (CKPT)
Double
2. The _____ property ensures that once all the steps in a transaction have been competed successfully - the results are considered permanent.
DISPLAY
Durability
Standard Connection Pooling (Prior to 11g)
Candidate Key
3. In a UNIX or Linux environment - you will also need to use the root account to perform a few tasks such as modifying the __________.
Tables - Indexes
Kernel Settings
Real Application Clusters (RAC)
The Shared Pool
4. When a set of shared Application Tier Processes handle all requests - each of which maintain a persistent connection to the Database - this is called ______________
Log Buffer
Shared pool
Standard Connection Pooling (Prior to 11g)
Archiver
5. 2 tablespaces which are always created by and whose names are mandated by Oracle
Real Application Clusters (RAC)
Keep Pool
Dedicated Account
SYSTEM & SYSAUX
6. At frequent intervals - the contents of the Data Caches are synchronized with the Data Files. This is performed by a dedicated process called ____________
Checkpoint Process (CKPT)
pfile/spfile
Tables - Indexes
Dedicated Server
7. Transactions are Atomic or invisible from a logical perspective until the end of the transaction is indicated by an explicit instruction such as _______
Log Writer (LGWR)
Listener Log
Embedded SQL
COMMIT.
8. 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
SYSTEM & SYSAUX
Cookies
Redo Log Files
9. This process watches the progress of the database connections.
Process Monitor (PMON)
DELETE & MERGE
Data Dictionary
Isolation
10. In the Shared Server the State Information is kept in the SGA for _______________
2 - same size
On-Line Transaction Processing (OLTP)
SQL Deficiencies
Foreground Process
11. Other things to consider when determining disk space are _____ & Undo / Temp space.
Double
SYSTEM / SYSAUX tablespaces
Cookies
Shared pool
12. Data files are logically grouped into _____ and are usually given descriptive names such as DATA - INDEX - UNDO & TEMP.
Tablespaces
Database
The Oracle Instance
System Monitor (SMON)
13. Oracle Provided Command-Line Tool - * used to automate tasks
Shared pool
SQL Deficiencies
Isolation
SQL*Plus
14. Core Features of any DBMS are: ___________ - Data Integrity - Security
SYSTEM / SYSAUX tablespaces
Shared Server
8KB
Transaction Management
15. What is produces every time certain severe errors occur?
Trace File
Process Monitor (PMON)
Log Writer
SYSTEM / SYSAUX tablespaces
16. The _____ property ensures that results produces by concurrently executing transactions are serialized.
Oracle Data Guard
Isolation
Tables - Indexes
Keep Pool
17. When a redo log file fills up - an Oracle component called the _____ makes one of more copies of it.
SYSTEM & SYSAUX
Archiver
Database Resident Connection Pooling (DRCP) (11g Only)
DELETE & MERGE
18. In a UNIX or Linux environment - you will need to install and run Oracle using a __________.
Dedicated Account
SGA - System Global Area
Oracle's Data Guard Technology
tnsnames.ora.
19. The very large __________ shared by all Oracle processes is the SGA - System Global Area
Cookies
Listener.ora
Memory area
SQL Deficiencies
20. 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)
Product Disks - OUI (Oracle Universal Installer)
Log Writer (LGWR)
Database Writer (DBWR)
21. The location of the database software
Database Resident Connection Pooling (DRCP) (11g Only)
Oracle Home
Archiver (ARCH)
Dedicated Server
22. What is typically the largest portion of the SGA?
The Buffer Cache
Isolation
Net Configuration Assistant (NetCA)
Checkpoint Process (CKPT)
23. The process responsible for transferring all Undo and Redo entries in the Log Buffer to the Redo Log Files.
Log Writer (LGWR)
Isolation
tnsnames.ora.
Instance
24. A factor in the decision to assign a table or index to a particular tablespace is ___________
Consistency
Isolation
Block Size - * they should match
On-Line Transaction Processing (OLTP)
25. The simplest way to create a database is to use the __________.
Database Creation Assistant (DBCA)
The Shared Pool
Trace File
Database Writer (DBWR)
26. Type of a SQL statement used to modify data
PL/SQL
The Buffer Cache
DML - Database Manipulation Language
Standard Connection Pooling (Prior to 11g)
27. A unique part of a record is called__________
Program Global Area
Oracle Home
Shared pool
Candidate Key
28. 3 Physical Operations of a Transaction: Index Updates - ___________ - Recursive Operations
Control File
Trigger Operations
SQL Deficiencies
8KB
29. This wakes up periodically and copies any accumulated Undo and Redo entries to the Redo Log File.
Log Writer
Listener
Flashback Recovery Area
Checkpoint Process (CKPT)
30. Commonly used block size of data blocks
Memory area
2 - same size
Instant Client
8KB
31. In which Oracle Architecture is each connection handled by a dedicated Oracle process?
Dedicated Server
Cookies
On-Line Transaction Processing (OLTP)
COMMIT.
32. The location of backup copies of the data files is traditionally referred to as ________
Dedicated Account
Flashback Recovery Area
Database
Kernel Settings
33. Before you can create the first DB on a system - you must first configure a _____.
Listener
Trigger Operations
Program Global Area
PL/SQL
34. 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.
Archiver (ARCH)
Flashback Recovery Area
Log Buffer
tnsnames.ora.
35. These help ensure that the effects of a user's transaction are Durable (even in the event of a computer failure)
tnsnames.ora.
Redo Log Files
Shared pool
SYSTEM / SYSAUX tablespaces
36. Data Files store your _____ & _____.
Connection Pooling
Listener
Tables - Indexes
2 - same size
37. In which log are events such as startup - shutdown - DDL operations and space shortages written?
The Buffer Cache
Tablespaces
Alert Log
Log Writer (LGWR)
38. 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)
Data blocks (or pages)
Redo Log Group
Database Creation Assistant (DBCA)
39. A special _____ _____ can be created within the Buffer Cache to store data blocks from frequently used data tables - such as lookup tables.
SYSTEM / SYSAUX tablespaces
Dedicated Server
Standard Connection Pooling (Prior to 11g)
Keep Pool
40. What is the private work area in computer memory which each Oracle server process uses to hold intermediate results (temp files) called?
Program Global Area
Redo Log Group
DISPLAY
COMMIT.
41. 3 ___________: Redundancy - Nullable Data Items - Duplicate Data Records
Checkpoint Process (CKPT)
Listener Log
DISPLAY
SQL Deficiencies
42. An important configuration file related to the users starting a database session is the __________
Oracle Data Guard
Database Resident Connection Pooling (DRCP) (11g Only)
System Monitor (SMON)
Listener.ora
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.
Shared pool
Net Configuration Assistant (NetCA)
Control File
DISPLAY
44. The process responsible for transferring all modified data blocks in the Data Caches to the Data Files.
Keep Pool
Data Integrity Constraints
Double
Database Writer (DBWR)
45. A DBMS ensures transactions are: _______ - Consistent - Isolated - Durable
Tables - Indexes
Atomic
Latches
Listener
46. Applications developed to communicate with Oracle DBs use what type of SQL?
Atomic
Log Writer (LGWR)
Foreground Process
Embedded SQL
47. What tool is used to automated the process of Redo information being shipped from the Main DB and applied to the Standby DB?
Oracle Data Guard
Consistency
PL/SQL
Standard Connection Pooling (Prior to 11g)
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
The Buffer Cache
Active Workload Repository (AWR)
pfile/spfile
Tables - Indexes
49. SGA - System Global Area is divided into distinct areas such as the buffer cache - the ________ and the log buffer.
Durability
SGA - System Global Area
Shared pool
tnsnames.ora
50. A large component of the SGA - which is best-known for use in caching query execution plans is called _________
The Shared Pool
Latches
tnsnames.ora.
Cookies
Sorry!:) No result found.
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