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