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 _____ _____ can be created to store blocks within the Buffer Cache that are rarely reused.
Latches
Embedded SQL
Recycle Pool
Memory area
2. Commonly used block size of data blocks
Listener
8KB
Redo Log Files
tnsnames.ora.
3. Core Features of any DBMS are: ___________ - Data Integrity - Security
Transaction Management
Listener
The Shared Pool
Real Application Clusters (RAC)
4. In which log are events such as startup - shutdown - DDL operations and space shortages written?
Checkpoint Process (CKPT)
Alert Log
Real Application Clusters (RAC)
Durability
5. Type of SQL statements used to create and modify objects
Listener Log
DDL - Database Definition Language
Cookies
COMMIT.
6. A factor in the decision to assign a table or index to a particular tablespace is ___________
8KB
Block Size - * they should match
Embedded SQL
Data Dictionary
7. In a UNIX or Linux environment - you will need to install and run Oracle using a __________.
Data blocks (or pages)
Dedicated Account
DELETE & MERGE
Embedded SQL
8. Type of a SQL statement used to modify data
DELETE & MERGE
Log Buffer
DML - Database Manipulation Language
Instance
9. What describes the various computer processes resident in computer memory and memory areas shared by these processes?
Embedded SQL
DML - Database Manipulation Language
Instance
The Shared Pool
10. Which Oracle Architecture combines RAC and Standby technology?
PL/SQL
Block Size - * they should match
Program Global Area
Maximum Available Architecture (MAA)
11. A mirrored set of redo log files is called a ________
On-Line Transaction Processing (OLTP)
Redo Log Group
<tablespace><number>.dbf - or - <tablespace><number>.ora
8KB
12. Typical convention for naming data files
Database
<tablespace><number>.dbf - or - <tablespace><number>.ora
COMMIT.
Trigger Operations
13. Data Files store your _____ & _____.
Tables - Indexes
PL/SQL
System Monitor (SMON)
Shared Server
14. The _____ property of a transaction ensures that the transaction does not compromise the integrity of the database.
Oracle Data Guard
Dedicated Account
Consistency
Trigger Operations
15. The location of backup copies of the data files is traditionally referred to as ________
SYSTEM / SYSAUX tablespaces
Flashback Recovery Area
Kernel Settings
Listener Log
16. 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
Durability
Dedicated Server
Database Writer (DBWR)
17. Applications developed to communicate with Oracle DBs use what type of SQL?
Recycle Pool
Control File
Redo Log Group
Embedded SQL
18. 3 Physical Operations of a Transaction: Index Updates - ___________ - Recursive Operations
Database
Trigger Operations
Embedded SQL
Connection Pooling
19. When a redo log file fills up - an Oracle component called the _____ makes one of more copies of it.
Database Creation Assistant (DBCA)
Archiver
Oracle Data Guard
Control File
20. A Dedicated _____ _____ is typically started whenever a user connects to the database.
SQL*Plus
Consistency
Double
Foreground Process
21. Before you can create the first DB on a system - you must first configure a _____.
pfile/spfile
SQL*Plus
Database Creation Assistant (DBCA)
Listener
22. 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
Data blocks (or pages)
Log Writer (LGWR)
Durability
23. 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
Durability
tnsnames.ora.
Control File
24. The process responsible for making copies of the Redo Log Files when they fill up.
<tablespace><number>.dbf - or - <tablespace><number>.ora
Recycle Pool
SQL*Plus
Archiver (ARCH)
25. At frequent intervals - the contents of the Data Caches are synchronized with the Data Files. This is performed by a dedicated process called ____________
Embedded SQL
Double
Maximum Available Architecture (MAA)
Checkpoint Process (CKPT)
26. Oracle Provided Command-Line Tool - * used to automate tasks
Shared pool
Oracle Home
SQL Deficiencies
SQL*Plus
27. Configuration file that contains location information for databases
tnsnames.ora
DML - Database Manipulation Language
Archiver
Isolation
28. Name the 6 Oracle Architectural Choices: Dedicated Server - Shared Server - ___________ - Real Application Clusters (RAC) - Standby DB - Maximum Available Architecture (MAA)
Archiver (ARCH)
Log Writer
Database Resident Connection Pooling (DRCP) (11g Only)
Connection Pooling
29. Data files are logically grouped into _____ and are usually given descriptive names such as DATA - INDEX - UNDO & TEMP.
Alert Log
tnsnames.ora.
The Shared Pool
Tablespaces
30. In which Oracle Architecture is each connection handled by a dedicated Oracle process?
Dedicated Server
Foreground Process
Instant Client
Oracle Data Guard
31. 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.
COMMIT.
Real Application Clusters (RAC)
Embedded SQL
DISPLAY
32. The SYSAUX tablespace is used to store ____________ - such as Statspack or Management Information.
Dedicated Account
Active Workload Repository (AWR)
Dedicated Server
The Shared Pool
33. 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.
Active Workload Repository (AWR)
Database Resident Connection Pooling (DRCP) (11g Only)
COMMIT.
Double
34. The location of the database software
Oracle Home
Atomic
tnsnames.ora
Product Disks - OUI (Oracle Universal Installer)
35. A special _____ _____ can be created within the Buffer Cache to store data blocks from frequently used data tables - such as lookup tables.
Listener
Maximum Available Architecture (MAA)
Trace File
Keep Pool
36. The simplest way to create a database is to use the __________.
Checkpoint Process (CKPT)
Shared pool
Database Creation Assistant (DBCA)
Log Writer (LGWR)
37. An important configuration file related to the users starting a database session is the __________
Listener.ora
Process Monitor (PMON)
Isolation
pfile/spfile
38. The _____ property ensures that once all the steps in a transaction have been competed successfully - the results are considered permanent.
Latches
SGA - System Global Area
SQL Deficiencies
Durability
39. SGA - System Global Area is divided into distinct areas such as the buffer cache - the ________ and the log buffer.
Oracle Home
Shared pool
Listener.ora
Cookies
40. This wakes up periodically and copies any accumulated Undo and Redo entries to the Redo Log File.
Cookies
Log Writer
Tables - Indexes
Database Resident Connection Pooling (DRCP) (11g Only)
41. 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
42. What is produces every time certain severe errors occur?
Trace File
Redo Log Files
Net Configuration Assistant (NetCA)
Archiver (ARCH)
43. In Connection Pooling the information generated by the autonomous tasks not preserved in RAM - but saved in _______ or in the DB itself
SYSTEM & SYSAUX
Log Buffer
Cookies
RAC - Real Application Clusters
44. 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)
Oracle's Data Guard Technology
Cookies
Redo Log Files
45. The files on the storage disks connected to the database host is the __________
DML - Database Manipulation Language
Database Creation Assistant (DBCA)
Database
Checkpoint Process (CKPT)
46. 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
Listener Log
Control File
Listener.ora
47. In a UNIX or Linux environment - you will have to mount the _____ _____ and enable an X Windows environment for the use of _____.
Standard Connection Pooling (Prior to 11g)
Product Disks - OUI (Oracle Universal Installer)
<tablespace><number>.dbf - or - <tablespace><number>.ora
Redo Log Files
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
Real Application Clusters (RAC)
Cookies
pfile/spfile
Oracle Home
49. The Oracle Instance is composed of: Foreground Processes - Background Processes - ___________
Latches
Real Application Clusters (RAC)
Keep Pool
SGA - System Global Area
50. This process watches the progress of the database connections.
Standard Connection Pooling (Prior to 11g)
Process Monitor (PMON)
Listener Log
RAC - Real Application Clusters