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. The Oracle ____ tool provides the network link between the Oracle10g database and most applications that communicate with the database.
DBCA
Net Services
Large pool
SQL*Plus
2. The Oracle Net Services configuration is stored in the ____ configuration file on the client computer.
DB_FILE_DEST
Universal Installer
Tnsnames.ora
Netmgr
3. 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.
All platforms
MOUNT
SQL*Plus
SYSOPER
4. The ____ process cleans up after user sessions are finished.
PMON
Type and sequence of creation
Listener
PL/SQL
5. _________ databases can be managed within OEM.
By separating data from software
Multiple
Runtime
ORACLE_HOME
6. All Oracle software files and database storage files reside on subdirectories under ____.
Universal Installer
LOGFILES
TNS
ORACLE_BASE
7. The ____ log is essential because it will contain all the essential information for the smooth running of your database.
Universal Installer
Alert
Runtime
Dedicated
8. The script files generated by the DBCA tool include numerous SQL*Plus executable ____ files - a configuration parameter file called init.ora - and a batch file for executing all the scripts in a single shell command.
ORACLE_BASE
TNS
.sql
Net Manager
9. ____ is the default method for connecting to a database.
Data Upgrade Assistant
DB_CREATE_ONLINE_LOG_DEST_n
TNS
Redo log buffer
10. To start Net Manager in Unix or Linux - type ____ on the command line of a shell.
Application server tier
LOGFILES
Netmgr
DB_CREATE_ONLINE_LOG_DEST_n
11. ____ views provide system-related information by querying the database's internal management tables and presenting the data as views (metadata views).
Data Dictionary
IMMEDIATE
Data Upgrade Assistant
Dispatcher
12. ____ is a valid client installation configuration.
Analyze Wizard
IMMEDIATE
Administrator
Single-instance server
13. The <database name> is usually stored as the ____ environment variable
Type and sequence of creation
TRANSACTIONAL
ORACLE_SID
Data Upgrade Assistant
14. A ____ is a physical file on the computer disk containing data - such as tables and indexes.
DB_FILE_DEST
Datafile
Lsnrctl
PMON
15. In the SQL*Plus statement CONNECT /@ORACLASS AS SYSDBA - the ____ tells the database to use OS authentication.
Data Dictionary
DBCA
/
Control
16. The initialization configuration parameters file is ____.
Dedicated
Universal Installer
Init.ora
OLTP
17. Whenever a change is made to data - the ____ stores a copy of the changed data and the original data - in case it is needed.
LOGFILES
OLTP
Network name
Redo log buffer
18. ____ is the typical configuration for an Oracle10g database.
SQL*Plus
$ORACLE_HOME/network/admin
Application server tier
Single-instance server
19. The ____ collects statistics about tables or objects - validates tables - finds continuing rows.
Custom
Net Services
Analyze Wizard
Redo log buffer
20. The ____ improves response time for background processes and for backup and recovery processes.
Listener
Network name
Large pool
PMON
21. The ____ area stores parsed SQL in memory.
Net Manager
Shared pool
DBCA
Netmgr
22. Load balancing between multiple listener processes is placed in the ____ configuration file on the client computer.
Dedicated server
Tnsnames.ora
Network name
Dispatcher
23. A ____ file records changes to database data.
Redo log
Control
Datafile
Schema
24. When the ____ initialization parameter is set - Oracle 10g knows where to locate all the datafiles.
DB_FILE_DEST
NORMAL
Runtime
Netmgr
25. A(n) ____ database allows you to define anything and everything - this one is for the experts.
Alert
Custom
Dedicated server
Application server tier
26. The ____ tool guides you through database setup and creation using windows with instructions for each step.
All platforms
Data Warehouse
DBCA
OLTP
27. The ____ migrates data from older versions to newer versions of the database.
DBCA
Network name
Data Upgrade Assistant
DB_FILE_DEST
28. A single machine can contain __________ value for ORACLE_HOME.
Single-instance server
Net Manager
IMMEDIATE
More than one
29. OFA provides standards intended to improve performance of the database by - among other things - spreading I/O functions across separate devices...
Dedicated
Oradata
By separating data from software
Runtime
30. The listener.ora file is stored in the ____ directory.
Runtime
NOMOUNT
$ORACLE_HOME/network/admin
Redo log buffer
31. Oracle executable files are stored in a directory tree referred to as ____.
DB_CREATE_ONLINE_LOG_DEST_n
SGA
Operating system
ORACLE_HOME
32. SHUTDOWN ____ simply stops all Oracle processes - and releases all memory buffers.
PMON
/
ABORT
SQL*Plus
33. The ____ database configuration option allows for a lot of change activity - raising concurrency requirements - and lowering I/O activity requirements.
PL/SQL
Redo log buffer
SYSOPER
Transaction Processing
34. Setting a user connection as being dedicated or shared can be controlled in the client-side configuration of Oracle Net Services - in the ____ file.
SYSOPER
IMMEDIATE
Tnsnames.ora
Multiple
35. The database has a service called the ____ process. This process waits for requests and responds to requests as needed.
DB_FILE_DEST
ORACLE_BASE
Listener
Redo log buffer
36. A ____ is a set of database structures - such as tables - indexes - user-defined attributes - and procedures.
SQL*Plus
Redo log
Schema
ORACLE_HOME
37. The ____ database configuration option will change some configuration - generally allowing low concurrency and very high I/O activity.
Shared pool
Netmgr
ORACLE_BASE
Data Warehouse
38. The client configuration is a combination of the user interface tier and the...
Analyze Wizard
Application server tier
PL/SQL
Operating system
39. Current database files are stored in ____/<database name>.
Shared pool
PMON
MOUNT
Oradata
40. STARTUP ____ will open the database in read/write - unrestricted mode.
OPEN
SYSOPER
Multiple
$ORACLE_HOME/network/admin
41. SHUTDOWN ____waits for all users to log off - prohibits new connections - forcibly rolls back currently running transactions - and then shuts down the database.
NORMAL
Operating system
ORACLE_HOME
More than one
42. ____ is a valid client installation configuration.
Network name
Custom
Runtime
Lsnrctl
43. To implement user-managed redo log files - you should use the ____ clause in the CREATE DATABASE command itself.
Transaction Processing
OPEN
LOGFILES
Operating system
44. SHUTDOWN ____automatically completes and commits all pending transactions - then forcibly disconnects all connected users - and shuts down the database.
TRANSACTIONAL
OLTP
ORACLE_BASE
Network name
45. The ____ contains many of the memory buffer components for an up and running (online) Oracle instance.
Tnsnames.ora
.sql
OLTP
SGA
46. A ____ file is an administrative file containing up-to-date information on the database structure - log files - checkpoints; critical file for opening the database.
Tnsnames.ora
ORACLE_HOME
Control
Transaction Processing
47. The DBA authentication method encompasses the method used to validate logon of users with the SYSDBA or ____ role.
ORACLE_BASE
Netmgr
SYSOPER
Datafile
48. STARTUP ____ starts up all background processes - and allocates space in memory for all Oracle database instance memory buffers.
NOMOUNT
Operating system
Type and sequence of creation
DB_CREATE_ONLINE_LOG_DEST_n
49. You can start and stop the listener using the listener control utility (____).
Lsnrctl
NOMOUNT
Tnsnames.ora
Universal Installer
50. 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.
Data Dictionary
DB_CREATE_FILE_DEST
ORACLE_BASE
Dedicated server