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