SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
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 ____ disconnects all users - rolls back pending transactions - and prohibits new connections and new transactions even for already connected users.
/
IMMEDIATE
Init.ora
Dispatcher
2. ____ processes are only present in shared server mode to distribute user connection requests - between server processes.
TNS
Dispatcher
OLTP
Network name
3. When choosing the DBA authentication method - you can choose between ____ and password file authentication.
ORACLE_HOME
Runtime
Program Global Area (PGA)
Operating system
4. The ____ collects statistics about tables or objects - validates tables - finds continuing rows.
Net Services
Listener
Analyze Wizard
More than one
5. A ____ is a label given to a specific network configuration - usually a specific computer - at a specific TCP/IP address.
Alert
.sql
Network name
Init.ora
6. A ____ file is an administrative file containing up-to-date information on the database structure - log files - checkpoints; critical file for opening the database.
$ORACLE_HOME/network/admin
Control
Universal Installer
Operating system
7. The Oracle Net Services configuration is stored in the ____ configuration file on the client computer.
Data Dictionary
OPEN
Schema
Tnsnames.ora
8. In the case of a ____ server - every user session (connection) has its own server process.
Dedicated
ORACLE_BASE
TRANSACTIONAL
Dedicated server
9. SHUTDOWN ____automatically completes and commits all pending transactions - then forcibly disconnects all connected users - and shuts down the database.
8K
TRANSACTIONAL
.sql
Operating system
10. You can start and stop the listener using the listener control utility (____).
Lsnrctl
Redo log
Datafile
Tnsnames.ora
11. 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
Data Upgrade Assistant
All platforms
/
12. SHUTDOWN ____ simply stops all Oracle processes - and releases all memory buffers.
ABORT
Tnsnames.ora
Alert
Data Warehouse
13. The ____ improves response time for background processes and for backup and recovery processes.
DBCA
Large pool
Net Services
SYSOPER
14. _________ databases can be managed within OEM.
Large pool
Multiple
Datafile
By separating data from software
15. The ____ contains many of the memory buffer components for an up and running (online) Oracle instance.
SGA
LOGFILES
ORACLE_HOME
IMMEDIATE
16. The initialization configuration parameters file is ____.
Alert
Transaction Processing
Application server tier
Init.ora
17. Whenever a change is made to data - the ____ stores a copy of the changed data and the original data - in case it is needed.
8K
Redo log buffer
Init.ora
Network name
18. Setting a user connection as being dedicated or shared can be controlled in the client-side configuration of Oracle Net Services - in the ____ file.
Tnsnames.ora
By separating data from software
More than one
DBCA
19. A(n) ____ database is used to service Internet applications.
DBCA
SQL*Plus
PL/SQL
OLTP
20. A ____ file records changes to database data.
OLTP
Redo log
Init.ora
SGA
21. The Oracle ____ tool provides the network link between the Oracle10g database and most applications that communicate with the database.
Redo log
LOGFILES
PL/SQL
Net Services
22. The ____ migrates data from older versions to newer versions of the database.
Schema
Type and sequence of creation
Data Upgrade Assistant
ORACLE_BASE
23. 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.
All platforms
By separating data from software
Dedicated server
Administrator
24. To start Net Manager in Unix or Linux - type ____ on the command line of a shell.
PMON
Redo log buffer
By separating data from software
Netmgr
25. ____ views provide system-related information by querying the database's internal management tables and presenting the data as views (metadata views).
SYSOPER
Dedicated
Application server tier
Data Dictionary
26. Load balancing between multiple listener processes is placed in the ____ configuration file on the client computer.
Custom
/
Tnsnames.ora
.sql
27. The database has a service called the ____ process. This process waits for requests and responds to requests as needed.
/
Oradata
MOUNT
Listener
28. ____ is a valid client installation configuration.
Shared pool
Administrator
Transaction Processing
LOGFILES
29. A ____ is a set of database structures - such as tables - indexes - user-defined attributes - and procedures.
Large pool
Shared pool
Schema
MOUNT
30. The ____ database configuration option will change some configuration - generally allowing low concurrency and very high I/O activity.
SYSOPER
Data Warehouse
/
All platforms
31. The DBCA tool executes the ____ for you - in order to configure the new database's Named Service.
Net Manager
ORACLE_HOME
Dedicated
Tnsnames.ora
32. The ____ initialization parameter defines one or more directories where control files and redo log files are to be created.
DB_CREATE_ONLINE_LOG_DEST_n
Data Upgrade Assistant
Redo log
ORACLE_SID
33. ____ is a valid client installation configuration.
SQL*Plus
Dispatcher
Runtime
Universal Installer
34. In Oracle10g the buffer cache can consist of multiple buffer caches - of different sizes. The default size is ____.
8K
Type and sequence of creation
Tnsnames.ora
.sql
35. The OFA standards call for naming files according to their...
Dedicated server
Type and sequence of creation
Shared pool
Transaction Processing
36. ____ is the default method for connecting to a database.
Application server tier
Transaction Processing
MOUNT
TNS
37. The ____ process cleans up after user sessions are finished.
PMON
Runtime
Administrator
SGA
38. A(n) ____ database allows you to define anything and everything - this one is for the experts.
Custom
OLTP
DB_FILE_DEST
Program Global Area (PGA)
39. The DBA authentication method encompasses the method used to validate logon of users with the SYSDBA or ____ role.
TNS
DB_FILE_DEST
Shared pool
SYSOPER
40. The ____ log is essential because it will contain all the essential information for the smooth running of your database.
ORACLE_SID
8K
Alert
Listener
41. The ____ engine included with the Oracle software provides a specialized programming language you can use for creating triggers - packages - and procedures.
Net Manager
PL/SQL
Tnsnames.ora
Multiple
42. The client configuration is a combination of the user interface tier and the...
Application server tier
Tnsnames.ora
Datafile
Listener
43. 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.
Analyze Wizard
Single-instance server
MOUNT
By separating data from software
44. All Oracle software files and database storage files reside on subdirectories under ____.
OPEN
ORACLE_BASE
DB_CREATE_FILE_DEST
Transaction Processing
45. To implement user-managed redo log files - you should use the ____ clause in the CREATE DATABASE command itself.
Network name
.sql
Redo log
LOGFILES
46. The ____ tool allows you to create and run queries - add rows - modify data - and write reports using SQL.
SQL*Plus
Data Dictionary
Redo log
.sql
47. The <database name> is usually stored as the ____ environment variable
8K
ORACLE_SID
Data Upgrade Assistant
Custom
48. When the ____ initialization parameter is set - Oracle 10g knows where to locate all the datafiles.
LOGFILES
Runtime
Application server tier
DB_FILE_DEST
49. A ____ is a physical file on the computer disk containing data - such as tables and indexes.
TNS
Datafile
NORMAL
Tnsnames.ora
50. Oracle has standardized its software so that it looks and acts identically at the user interface level on...
/
All platforms
Net Manager
SYSOPER