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. Load balancing between multiple listener processes is placed in the ____ configuration file on the client computer.
Custom
Tnsnames.ora
DB_FILE_DEST
IMMEDIATE
2. When the ____ initialization parameter is set - Oracle 10g knows where to locate all the datafiles.
Administrator
DB_FILE_DEST
Data Warehouse
NOMOUNT
3. ____ is the default method for connecting to a database.
TNS
SYSOPER
Redo log
PMON
4. The ____ collects statistics about tables or objects - validates tables - finds continuing rows.
Control
SGA
Analyze Wizard
Schema
5. ____ views provide system-related information by querying the database's internal management tables and presenting the data as views (metadata views).
Data Dictionary
Listener
Program Global Area (PGA)
Administrator
6. 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
DB_CREATE_FILE_DEST
Tnsnames.ora
ORACLE_BASE
7. ____ is the typical configuration for an Oracle10g database.
Datafile
Single-instance server
DB_CREATE_ONLINE_LOG_DEST_n
Tnsnames.ora
8. To start Net Manager in Unix or Linux - type ____ on the command line of a shell.
Custom
Netmgr
Redo log buffer
Application server tier
9. SHUTDOWN ____automatically completes and commits all pending transactions - then forcibly disconnects all connected users - and shuts down the database.
PMON
MOUNT
NORMAL
TRANSACTIONAL
10. The DBA authentication method encompasses the method used to validate logon of users with the SYSDBA or ____ role.
NOMOUNT
SYSOPER
Application server tier
Analyze Wizard
11. STARTUP ____ will open the database in read/write - unrestricted mode.
Shared pool
TRANSACTIONAL
OPEN
PL/SQL
12. When choosing the DBA authentication method - you can choose between ____ and password file authentication.
Schema
Operating system
Data Upgrade Assistant
Dedicated server
13. 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.
Schema
Transaction Processing
Dedicated server
Control
14. SHUTDOWN ____ simply stops all Oracle processes - and releases all memory buffers.
Listener
OLTP
ABORT
Multiple
15. SHUTDOWN ____waits for all users to log off - prohibits new connections - forcibly rolls back currently running transactions - and then shuts down the database.
Single-instance server
ORACLE_SID
/
NORMAL
16. The ____ tool guides you through database setup and creation using windows with instructions for each step.
DBCA
Operating system
ORACLE_HOME
Net Manager
17. In the SQL*Plus statement CONNECT /@ORACLASS AS SYSDBA - the ____ tells the database to use OS authentication.
/
DBCA
TNS
Operating system
18. The <database name> is usually stored as the ____ environment variable
IMMEDIATE
Administrator
TNS
ORACLE_SID
19. A ____ is a label given to a specific network configuration - usually a specific computer - at a specific TCP/IP address.
/
NORMAL
Network name
DB_FILE_DEST
20. _________ databases can be managed within OEM.
Multiple
Application server tier
SYSOPER
Administrator
21. Whenever a change is made to data - the ____ stores a copy of the changed data and the original data - in case it is needed.
Application server tier
Redo log buffer
Tnsnames.ora
Transaction Processing
22. A single machine can contain __________ value for ORACLE_HOME.
LOGFILES
More than one
Dedicated server
Runtime
23. The ____ database configuration option will change some configuration - generally allowing low concurrency and very high I/O activity.
Net Manager
Data Warehouse
Large pool
Schema
24. 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.
Transaction Processing
Administrator
MOUNT
.sql
25. The DBCA tool executes the ____ for you - in order to configure the new database's Named Service.
Type and sequence of creation
Schema
Dedicated
Net Manager
26. The listener.ora file is stored in the ____ directory.
$ORACLE_HOME/network/admin
TNS
IMMEDIATE
MOUNT
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.
Large pool
Tnsnames.ora
Data Dictionary
Custom
28. The client configuration is a combination of the user interface tier and the...
Datafile
All platforms
TRANSACTIONAL
Application server tier
29. The ____ database configuration option allows for a lot of change activity - raising concurrency requirements - and lowering I/O activity requirements.
PL/SQL
LOGFILES
Transaction Processing
ORACLE_SID
30. The ____ contains many of the memory buffer components for an up and running (online) Oracle instance.
Administrator
Universal Installer
SGA
Net Manager
31. Current database files are stored in ____/<database name>.
Operating system
Oradata
Large pool
DB_CREATE_ONLINE_LOG_DEST_n
32. The ____ initialization parameter defines one or more directories where control files and redo log files are to be created.
Dispatcher
Alert
Shared pool
DB_CREATE_ONLINE_LOG_DEST_n
33. The ____ improves response time for background processes and for backup and recovery processes.
Large pool
PL/SQL
Transaction Processing
Runtime
34. The OFA standards call for naming files according to their...
Lsnrctl
Type and sequence of creation
Data Upgrade Assistant
Net Services
35. All Oracle software files and database storage files reside on subdirectories under ____.
Single-instance server
Network name
Net Services
ORACLE_BASE
36. ____ is a valid client installation configuration.
NORMAL
DBCA
TRANSACTIONAL
Administrator
37. The ____ process cleans up after user sessions are finished.
All platforms
PMON
Dispatcher
Redo log
38. OFA provides standards intended to improve performance of the database by - among other things - spreading I/O functions across separate devices...
Schema
Multiple
Netmgr
By separating data from software
39. The ____ area stores parsed SQL in memory.
Dispatcher
ORACLE_BASE
Shared pool
NORMAL
40. Oracle executable files are stored in a directory tree referred to as ____.
LOGFILES
Single-instance server
ORACLE_HOME
Large pool
41. A ____ is a set of database structures - such as tables - indexes - user-defined attributes - and procedures.
Schema
NORMAL
Single-instance server
Dispatcher
42. To implement user-managed redo log files - you should use the ____ clause in the CREATE DATABASE command itself.
Schema
DB_CREATE_ONLINE_LOG_DEST_n
Custom
LOGFILES
43. The ____ is used to install Oracle software - or change an existing installation.
Universal Installer
By separating data from software
Shared pool
PMON
44. STARTUP ____ starts up all background processes - and allocates space in memory for all Oracle database instance memory buffers.
Net Manager
NORMAL
SGA
NOMOUNT
45. The Oracle ____ tool provides the network link between the Oracle10g database and most applications that communicate with the database.
IMMEDIATE
Data Warehouse
Net Services
SQL*Plus
46. The ____ tool allows you to create and run queries - add rows - modify data - and write reports using SQL.
Network name
SQL*Plus
OLTP
OPEN
47. ____ processes are only present in shared server mode to distribute user connection requests - between server processes.
NOMOUNT
Control
Dispatcher
Program Global Area (PGA)
48. ____ is a valid client installation configuration.
Dedicated server
Alert
Runtime
Netmgr
49. The two main sections of memory for the Oracle instance are the System Global Area (SGA) and the ____.
NOMOUNT
Program Global Area (PGA)
MOUNT
Net Services
50. Oracle has standardized its software so that it looks and acts identically at the user interface level on...
Custom
Data Warehouse
All platforms
8K