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