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 Test
Start Test
Study First
Subjects
:
oracle
,
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. OFA provides standards intended to improve performance of the database by - among other things - spreading I/O functions across separate devices...
DBCA
By separating data from software
Custom
Tnsnames.ora
2. Current database files are stored in ____/<database name>.
LOGFILES
Oradata
By separating data from software
Operating system
3. The two main sections of memory for the Oracle instance are the System Global Area (SGA) and the ____.
Program Global Area (PGA)
Tnsnames.ora
Transaction Processing
DB_CREATE_ONLINE_LOG_DEST_n
4. A ____ is a set of database structures - such as tables - indexes - user-defined attributes - and procedures.
Network name
Redo log buffer
Shared pool
Schema
5. In the case of a ____ server - every user session (connection) has its own server process.
SGA
Single-instance server
Dedicated
Network name
6. Whenever a change is made to data - the ____ stores a copy of the changed data and the original data - in case it is needed.
Data Dictionary
TNS
Redo log buffer
Data Upgrade Assistant
7. To implement user-managed redo log files - you should use the ____ clause in the CREATE DATABASE command itself.
LOGFILES
Net Manager
Single-instance server
TRANSACTIONAL
8. The listener.ora file is stored in the ____ directory.
DB_FILE_DEST
Operating system
ABORT
$ORACLE_HOME/network/admin
9. The ____ database configuration option will change some configuration - generally allowing low concurrency and very high I/O activity.
SGA
Data Warehouse
Data Dictionary
.sql
10. In the SQL*Plus statement CONNECT /@ORACLASS AS SYSDBA - the ____ tells the database to use OS authentication.
ABORT
Large pool
/
ORACLE_BASE
11. SHUTDOWN ____automatically completes and commits all pending transactions - then forcibly disconnects all connected users - and shuts down the database.
TRANSACTIONAL
Init.ora
Listener
Oradata
12. ____ is a valid client installation configuration.
Data Warehouse
PL/SQL
Administrator
OPEN
13. ____ is the default method for connecting to a database.
More than one
TNS
Net Manager
Redo log
14. A ____ is a physical file on the computer disk containing data - such as tables and indexes.
All platforms
OLTP
Datafile
Tnsnames.ora
15. A ____ file is an administrative file containing up-to-date information on the database structure - log files - checkpoints; critical file for opening the database.
Control
PMON
Listener
SYSOPER
16. A ____ file records changes to database data.
Redo log
NOMOUNT
Application server tier
By separating data from software
17. The ____ contains many of the memory buffer components for an up and running (online) Oracle instance.
SGA
Schema
Dispatcher
Single-instance server
18. A(n) ____ database is used to service Internet applications.
Schema
DBCA
OLTP
Transaction Processing
19. _________ databases can be managed within OEM.
DB_CREATE_ONLINE_LOG_DEST_n
Application server tier
Multiple
$ORACLE_HOME/network/admin
20. The Oracle Net Services configuration is stored in the ____ configuration file on the client computer.
Tnsnames.ora
DB_CREATE_ONLINE_LOG_DEST_n
Data Upgrade Assistant
DB_FILE_DEST
21. ____ is the typical configuration for an Oracle10g database.
Single-instance server
/
SYSOPER
TRANSACTIONAL
22. The ____ database configuration option allows for a lot of change activity - raising concurrency requirements - and lowering I/O activity requirements.
Network name
NORMAL
Transaction Processing
Redo log
23. The ____ process cleans up after user sessions are finished.
SQL*Plus
SYSOPER
NOMOUNT
PMON
24. ____ is a valid client installation configuration.
Runtime
Netmgr
SYSOPER
ORACLE_BASE
25. The initialization configuration parameters file is ____.
Netmgr
OLTP
Init.ora
NOMOUNT
26. Oracle has standardized its software so that it looks and acts identically at the user interface level on...
Redo log
DBCA
MOUNT
All platforms
27. Setting a user connection as being dedicated or shared can be controlled in the client-side configuration of Oracle Net Services - in the ____ file.
All platforms
Lsnrctl
Tnsnames.ora
TRANSACTIONAL
28. If you install Oracle10g Enterprise Edition - Standard Edition - or Personal Edition and choose to have a predefined database created on installation - the database is configured in ____ mode.
Administrator
Dedicated server
Dispatcher
IMMEDIATE
29. Load balancing between multiple listener processes is placed in the ____ configuration file on the client computer.
Tnsnames.ora
SGA
Transaction Processing
Net Manager
30. The ____ log is essential because it will contain all the essential information for the smooth running of your database.
DB_CREATE_FILE_DEST
Netmgr
By separating data from software
Alert
31. STARTUP ____ mounts the database files - essentially creating the connection between file pointers in the control file and the files themselves - such as datafiles and redo log files.
Control
MOUNT
TNS
LOGFILES
32. SHUTDOWN ____ simply stops all Oracle processes - and releases all memory buffers.
ABORT
ORACLE_BASE
NOMOUNT
LOGFILES
33. ____ views provide system-related information by querying the database's internal management tables and presenting the data as views (metadata views).
OLTP
Data Dictionary
Shared pool
Universal Installer
34. The ____ collects statistics about tables or objects - validates tables - finds continuing rows.
Net Services
Redo log
Analyze Wizard
Alert
35. The DBCA tool executes the ____ for you - in order to configure the new database's Named Service.
Runtime
Multiple
ORACLE_SID
Net Manager
36. The <database name> is usually stored as the ____ environment variable
SGA
Tnsnames.ora
/
ORACLE_SID
37. The ____ initialization parameter defines one or more directories where control files and redo log files are to be created.
DB_CREATE_ONLINE_LOG_DEST_n
Redo log
Tnsnames.ora
Data Warehouse
38. The ____ improves response time for background processes and for backup and recovery processes.
Network name
Analyze Wizard
.sql
Large pool
39. The ____ migrates data from older versions to newer versions of the database.
Data Warehouse
Data Upgrade Assistant
Administrator
Schema
40. The OFA standards call for naming files according to their...
Custom
Dedicated server
Init.ora
Type and sequence of creation
41. Oracle executable files are stored in a directory tree referred to as ____.
IMMEDIATE
$ORACLE_HOME/network/admin
More than one
ORACLE_HOME
42. The ____ initialization parameter defines the directory where all datafiles and tempfiles (files used for storage of temporary data during sorting and other operations) are to be created.
DB_CREATE_FILE_DEST
MOUNT
Large pool
Control
43. All Oracle software files and database storage files reside on subdirectories under ____.
ORACLE_BASE
.sql
SGA
NORMAL
44. A single machine can contain __________ value for ORACLE_HOME.
ORACLE_HOME
Data Warehouse
More than one
Type and sequence of creation
45. The ____ tool guides you through database setup and creation using windows with instructions for each step.
Large pool
Net Manager
DBCA
Redo log buffer
46. The database has a service called the ____ process. This process waits for requests and responds to requests as needed.
DB_FILE_DEST
Listener
Tnsnames.ora
Network name
47. STARTUP ____ will open the database in read/write - unrestricted mode.
OPEN
Data Dictionary
ABORT
Tnsnames.ora
48. The client configuration is a combination of the user interface tier and the...
Application server tier
Data Warehouse
Universal Installer
Single-instance server
49. The ____ is used to install Oracle software - or change an existing installation.
Universal Installer
TRANSACTIONAL
DB_CREATE_ONLINE_LOG_DEST_n
Net Services
50. The ____ area stores parsed SQL in memory.
Lsnrctl
MOUNT
Analyze Wizard
Shared pool