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. These help ensure that the effects of a user's transaction are Durable (even in the event of a computer failure)
RAC - Real Application Clusters
Foreground Process
On-Line Transaction Processing (OLTP)
Redo Log Files
2. The various Oracle processes coordinate their access to the areas of the SGA by using IPC - Interprocess Communication mechanisms called _______
Latches
Atomic
Real Application Clusters (RAC)
Instant Client
3. 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
Listener Log
Checkpoint Process (CKPT)
Foreground Process
4. In which Oracle Architecture can additional Instances be added to the cluster to scale out instead of scaling up?
PL/SQL
DML - Database Manipulation Language
Real Application Clusters (RAC)
Memory area
5. Which Oracle Architecture combines RAC and Standby technology?
Alert Log
Maximum Available Architecture (MAA)
SYSTEM / SYSAUX tablespaces
Oracle Home
6. Name the 6 Oracle Architectural Choices: Dedicated Server - Shared Server - ___________ - Real Application Clusters (RAC) - Standby DB - Maximum Available Architecture (MAA)
Alert Log
DELETE & MERGE
Log Buffer
Connection Pooling
7. Other things to consider when determining disk space are _____ & Undo / Temp space.
Embedded SQL
Double
Listener.ora
SYSTEM / SYSAUX tablespaces
8. Programs that can be stored in an Oracle Database are written in
Transaction Management
SQL Deficiencies
PL/SQL
Shared pool
9. What is produces every time certain severe errors occur?
On-Line Transaction Processing (OLTP)
Standard Connection Pooling (Prior to 11g)
Trace File
Oracle Home
10. The files on the storage disks connected to the database host is the __________
Kernel Settings
Instance
tnsnames.ora
Database
11. In Connection Pooling the information generated by the autonomous tasks not preserved in RAM - but saved in _______ or in the DB itself
Dedicated Account
Cookies
Data Dictionary
SQL*Plus
12. What is the private work area in computer memory which each Oracle server process uses to hold intermediate results (temp files) called?
DISPLAY
Program Global Area
Foreground Process
Instant Client
13. The SYSTEM tablespace - which stores only tables containing information about the rest of the database - is called the ___________
Data Dictionary
The Oracle Instance
Shared Server
DDL - Database Definition Language
14. Data Files store your _____ & _____.
System Monitor (SMON)
Data Dictionary
Tables - Indexes
The Buffer Cache
15. Core Features of any DBMS are: ___________ - Data Integrity - Security
Oracle Data Guard
Transaction Management
RAC - Real Application Clusters
Redo Log Group
16. What describes the various computer processes resident in computer memory and memory areas shared by these processes?
2 - same size
Shared Server
Instance
Data Dictionary
17. 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)
Process Monitor (PMON)
Log Writer
Instant Client
18. A factor in the decision to assign a table or index to a particular tablespace is ___________
Block Size - * they should match
2 - same size
Data blocks (or pages)
Shared Server
19. The _____ property of a transaction ensures that the transaction does not compromise the integrity of the database.
Log Writer (LGWR)
SQL*Plus
Active Workload Repository (AWR)
Consistency
20. 3 Physical Operations of a Transaction: Index Updates - ___________ - Recursive Operations
Isolation
Trigger Operations
Active Workload Repository (AWR)
pfile/spfile
21. The _____ property ensures that once all the steps in a transaction have been competed successfully - the results are considered permanent.
On-Line Transaction Processing (OLTP)
Data Dictionary
System Monitor (SMON)
Durability
22. Type of a SQL statement used to modify data
DML - Database Manipulation Language
Kernel Settings
Real Application Clusters (RAC)
Recycle Pool
23. What is typically the largest portion of the SGA?
The Buffer Cache
Candidate Key
Checkpoint Process (CKPT)
Product Disks - OUI (Oracle Universal Installer)
24. A Dedicated _____ _____ is typically started whenever a user connects to the database.
Kernel Settings
Foreground Process
Process Monitor (PMON)
SGA - System Global Area
25. A special _____ _____ can be created within the Buffer Cache to store data blocks from frequently used data tables - such as lookup tables.
Database
Keep Pool
Kernel Settings
Tablespaces
26. INSERT - UPDATE - ________ are examples of DML - Database Manipulation Language
Connection Pooling
Cookies
SQL*Plus
DELETE & MERGE
27. When a set of shared Application Tier Processes handle all requests - each of which maintain a persistent connection to the Database - this is called ______________
Standard Connection Pooling (Prior to 11g)
SQL*Plus
Oracle Home
Tables - Indexes
28. The location of backup copies of the data files is traditionally referred to as ________
Log Writer (LGWR)
<tablespace><number>.dbf - or - <tablespace><number>.ora
Flashback Recovery Area
SYSTEM / SYSAUX tablespaces
29. 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.
Consistency
DISPLAY
Flashback Recovery Area
Tablespaces
30. This is a queue of Undo and Redo entries.
Archiver (ARCH)
Log Buffer
The Shared Pool
Checkpoint Process (CKPT)
31. The _____ property ensures that results produces by concurrently executing transactions are serialized.
Real Application Clusters (RAC)
Transaction Management
Trigger Operations
Isolation
32. 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?
Trigger Operations
Real Application Clusters (RAC)
Log Buffer
Net Configuration Assistant (NetCA)
33. Oracle Provided Command-Line Tool - * used to automate tasks
SQL*Plus
DISPLAY
Active Workload Repository (AWR)
Database Resident Connection Pooling (DRCP) (11g Only)
34. Data files are logically grouped into _____ and are usually given descriptive names such as DATA - INDEX - UNDO & TEMP.
Tablespaces
System Monitor (SMON)
Oracle Data Guard
2 - same size
35. 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
Keep Pool
SQL*Plus
Log Writer
36. The simplest way to create a database is to use the __________.
Cookies
Database Creation Assistant (DBCA)
Durability
Data Integrity Constraints
37. In a UNIX or Linux environment - you will have to mount the _____ _____ and enable an X Windows environment for the use of _____.
Instance
Double
Product Disks - OUI (Oracle Universal Installer)
SYSTEM / SYSAUX tablespaces
38. 2 tablespaces which are always created by and whose names are mandated by Oracle
Trigger Operations
SYSTEM & SYSAUX
Embedded SQL
Checkpoint Process (CKPT)
39. In which log is a record written every time a user establishes a connection to the database?
Connection Pooling
Listener Log
Trace File
Memory area
40. A DBMS ensures transactions are: _______ - Consistent - Isolated - Durable
Maximum Available Architecture (MAA)
Data Integrity Constraints
Listener.ora
Atomic
41. A large component of the SGA - which is best-known for use in caching query execution plans is called _________
Kernel Settings
Listener
The Shared Pool
Log Writer (LGWR)
42. This wakes up periodically and copies any accumulated Undo and Redo entries to the Redo Log File.
Transaction Management
Log Writer
Memory area
Candidate Key
43. This process is responsible for any cleanup activities necessary if the database is restarted after an abnormal shutdown resulting from system failure.
On-Line Transaction Processing (OLTP)
System Monitor (SMON)
Data blocks (or pages)
Database Resident Connection Pooling (DRCP) (11g Only)
44. A unique part of a record is called__________
Shared pool
Dedicated Server
Candidate Key
Listener
45. In which Oracle Architecture is each connection handled by a dedicated Oracle process?
Log Buffer
Tables - Indexes
Dedicated Server
Net Configuration Assistant (NetCA)
46. 3 ______________: Check - Uniqueness - Referential
Real Application Clusters (RAC)
Candidate Key
SQL Deficiencies
Data Integrity Constraints
47. An important configuration file related to the users starting a database session is the __________
Listener.ora
System Monitor (SMON)
Recycle Pool
Database Creation Assistant (DBCA)
48. In the Shared Server the State Information is kept in the SGA for _______________
On-Line Transaction Processing (OLTP)
Maximum Available Architecture (MAA)
Candidate Key
Checkpoint Process (CKPT)
49. Type of SQL statements used to create and modify objects
DDL - Database Definition Language
Shared Server
Listener Log
Embedded SQL
50. This process watches the progress of the database connections.
Data blocks (or pages)
Process Monitor (PMON)
Recycle Pool
COMMIT.