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. A ____ file records changes to database data.
.sql
SYSOPER
Analyze Wizard
Redo log
2. The ____ is used to install Oracle software - or change an existing installation.
.sql
Universal Installer
Tnsnames.ora
PL/SQL
3. 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.
Dedicated server
Data Upgrade Assistant
Operating system
DB_CREATE_FILE_DEST
4. Current database files are stored in ____/<database name>.
.sql
IMMEDIATE
SQL*Plus
Oradata
5. The ____ improves response time for background processes and for backup and recovery processes.
DB_FILE_DEST
SGA
$ORACLE_HOME/network/admin
Large pool
6. 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.
MOUNT
Data Dictionary
Data Upgrade Assistant
Custom
7. A ____ is a set of database structures - such as tables - indexes - user-defined attributes - and procedures.
Datafile
Lsnrctl
Schema
SYSOPER
8. The initialization configuration parameters file is ____.
Init.ora
All platforms
Transaction Processing
DB_CREATE_FILE_DEST
9. ____ is the default method for connecting to a database.
TNS
MOUNT
Analyze Wizard
Dedicated server
10. When choosing the DBA authentication method - you can choose between ____ and password file authentication.
Dispatcher
Tnsnames.ora
Operating system
Large pool
11. SHUTDOWN ____waits for all users to log off - prohibits new connections - forcibly rolls back currently running transactions - and then shuts down the database.
SYSOPER
OLTP
NORMAL
Init.ora
12. The ____ migrates data from older versions to newer versions of the database.
NOMOUNT
Multiple
Data Upgrade Assistant
Datafile
13. The listener.ora file is stored in the ____ directory.
Data Upgrade Assistant
DBCA
.sql
$ORACLE_HOME/network/admin
14. A(n) ____ database allows you to define anything and everything - this one is for the experts.
NORMAL
Custom
ORACLE_SID
Data Dictionary
15. The ____ area stores parsed SQL in memory.
Shared pool
Transaction Processing
SYSOPER
All platforms
16. The ____ database configuration option allows for a lot of change activity - raising concurrency requirements - and lowering I/O activity requirements.
OPEN
Transaction Processing
.sql
8K
17. Oracle executable files are stored in a directory tree referred to as ____.
Init.ora
Net Services
ORACLE_HOME
Multiple
18. In the case of a ____ server - every user session (connection) has its own server process.
Dedicated
SGA
Analyze Wizard
TRANSACTIONAL
19. ____ views provide system-related information by querying the database's internal management tables and presenting the data as views (metadata views).
Control
Data Dictionary
TRANSACTIONAL
SYSOPER
20. The OFA standards call for naming files according to their...
Redo log buffer
Type and sequence of creation
Tnsnames.ora
PMON
21. Load balancing between multiple listener processes is placed in the ____ configuration file on the client computer.
Tnsnames.ora
DB_CREATE_ONLINE_LOG_DEST_n
Shared pool
Program Global Area (PGA)
22. ____ is a valid client installation configuration.
Tnsnames.ora
Universal Installer
ORACLE_BASE
Administrator
23. The <database name> is usually stored as the ____ environment variable
Transaction Processing
Data Upgrade Assistant
All platforms
ORACLE_SID
24. In Oracle10g the buffer cache can consist of multiple buffer caches - of different sizes. The default size is ____.
Universal Installer
Datafile
Dedicated
8K
25. The ____ engine included with the Oracle software provides a specialized programming language you can use for creating triggers - packages - and procedures.
Dispatcher
Transaction Processing
PL/SQL
Custom
26. The ____ contains many of the memory buffer components for an up and running (online) Oracle instance.
Data Upgrade Assistant
Runtime
SYSOPER
SGA
27. The Oracle Net Services configuration is stored in the ____ configuration file on the client computer.
Tnsnames.ora
Transaction Processing
Lsnrctl
By separating data from software
28. The ____ database configuration option will change some configuration - generally allowing low concurrency and very high I/O activity.
Data Warehouse
Oradata
Data Upgrade Assistant
Tnsnames.ora
29. Setting a user connection as being dedicated or shared can be controlled in the client-side configuration of Oracle Net Services - in the ____ file.
Redo log
ORACLE_BASE
Data Upgrade Assistant
Tnsnames.ora
30. SHUTDOWN ____ disconnects all users - rolls back pending transactions - and prohibits new connections and new transactions even for already connected users.
NOMOUNT
TNS
IMMEDIATE
Large pool
31. The database has a service called the ____ process. This process waits for requests and responds to requests as needed.
Listener
8K
NORMAL
Data Warehouse
32. A single machine can contain __________ value for ORACLE_HOME.
Network name
Operating system
SQL*Plus
More than one
33. The two main sections of memory for the Oracle instance are the System Global Area (SGA) and the ____.
Program Global Area (PGA)
Application server tier
SQL*Plus
ORACLE_HOME
34. A ____ is a physical file on the computer disk containing data - such as tables and indexes.
DB_CREATE_ONLINE_LOG_DEST_n
Universal Installer
/
Datafile
35. The ____ tool guides you through database setup and creation using windows with instructions for each step.
8K
DBCA
Dedicated server
Control
36. To start Net Manager in Unix or Linux - type ____ on the command line of a shell.
Oradata
Runtime
Application server tier
Netmgr
37. STARTUP ____ starts up all background processes - and allocates space in memory for all Oracle database instance memory buffers.
Schema
.sql
NOMOUNT
Operating system
38. The client configuration is a combination of the user interface tier and the...
Application server tier
ORACLE_SID
Datafile
IMMEDIATE
39. The ____ initialization parameter defines one or more directories where control files and redo log files are to be created.
Data Dictionary
Analyze Wizard
ABORT
DB_CREATE_ONLINE_LOG_DEST_n
40. The Oracle ____ tool provides the network link between the Oracle10g database and most applications that communicate with the database.
All platforms
Net Services
Network name
OLTP
41. SHUTDOWN ____ simply stops all Oracle processes - and releases all memory buffers.
Custom
Analyze Wizard
ORACLE_SID
ABORT
42. A(n) ____ database is used to service Internet applications.
Redo log buffer
ORACLE_HOME
PL/SQL
OLTP
43. Whenever a change is made to data - the ____ stores a copy of the changed data and the original data - in case it is needed.
Tnsnames.ora
Redo log buffer
TNS
Net Manager
44. To implement user-managed redo log files - you should use the ____ clause in the CREATE DATABASE command itself.
NORMAL
.sql
Netmgr
LOGFILES
45. The ____ collects statistics about tables or objects - validates tables - finds continuing rows.
Tnsnames.ora
SYSOPER
NORMAL
Analyze Wizard
46. Oracle has standardized its software so that it looks and acts identically at the user interface level on...
8K
All platforms
By separating data from software
Dedicated server
47. ____ is the typical configuration for an Oracle10g database.
Dispatcher
Single-instance server
PL/SQL
More than one
48. In the SQL*Plus statement CONNECT /@ORACLASS AS SYSDBA - the ____ tells the database to use OS authentication.
Network name
/
Schema
SYSOPER
49. ____ is a valid client installation configuration.
DB_CREATE_ONLINE_LOG_DEST_n
NOMOUNT
NORMAL
Runtime
50. STARTUP ____ will open the database in read/write - unrestricted mode.
ORACLE_BASE
By separating data from software
Shared pool
OPEN