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