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. In the case of a ____ server - every user session (connection) has its own server process.
Redo log buffer
Dedicated
Alert
TNS
2. The Oracle Net Services configuration is stored in the ____ configuration file on the client computer.
Network name
Tnsnames.ora
Runtime
SQL*Plus
3. ____ views provide system-related information by querying the database's internal management tables and presenting the data as views (metadata views).
Type and sequence of creation
Data Dictionary
Dedicated
ORACLE_HOME
4. ____ is the default method for connecting to a database.
Lsnrctl
TNS
OPEN
Program Global Area (PGA)
5. A ____ is a set of database structures - such as tables - indexes - user-defined attributes - and procedures.
Net Manager
Alert
Schema
Dispatcher
6. To start Net Manager in Unix or Linux - type ____ on the command line of a shell.
ORACLE_HOME
Init.ora
8K
Netmgr
7. The ____ initialization parameter defines one or more directories where control files and redo log files are to be created.
Oradata
Custom
NOMOUNT
DB_CREATE_ONLINE_LOG_DEST_n
8. The database has a service called the ____ process. This process waits for requests and responds to requests as needed.
Listener
ORACLE_BASE
Net Manager
Data Upgrade Assistant
9. The ____ improves response time for background processes and for backup and recovery processes.
Dedicated server
Oradata
DBCA
Large pool
10. The ____ tool guides you through database setup and creation using windows with instructions for each step.
Lsnrctl
DBCA
DB_CREATE_FILE_DEST
Shared pool
11. STARTUP ____ will open the database in read/write - unrestricted mode.
SYSOPER
OPEN
Lsnrctl
ORACLE_BASE
12. The ____ engine included with the Oracle software provides a specialized programming language you can use for creating triggers - packages - and procedures.
Lsnrctl
Oradata
Multiple
PL/SQL
13. The listener.ora file is stored in the ____ directory.
$ORACLE_HOME/network/admin
Tnsnames.ora
Dispatcher
Network name
14. The OFA standards call for naming files according to their...
Transaction Processing
DB_FILE_DEST
NOMOUNT
Type and sequence of creation
15. The ____ is used to install Oracle software - or change an existing installation.
Redo log
Universal Installer
ABORT
Tnsnames.ora
16. To implement user-managed redo log files - you should use the ____ clause in the CREATE DATABASE command itself.
Transaction Processing
LOGFILES
By separating data from software
Operating system
17. The ____ database configuration option will change some configuration - generally allowing low concurrency and very high I/O activity.
ORACLE_BASE
.sql
LOGFILES
Data Warehouse
18. 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
Single-instance server
Netmgr
ORACLE_SID
19. ____ is the typical configuration for an Oracle10g database.
Single-instance server
All platforms
Datafile
Alert
20. The client configuration is a combination of the user interface tier and the...
$ORACLE_HOME/network/admin
SGA
Tnsnames.ora
Application server tier
21. The ____ area stores parsed SQL in memory.
Shared pool
NORMAL
SYSOPER
Init.ora
22. The ____ tool allows you to create and run queries - add rows - modify data - and write reports using SQL.
SQL*Plus
Dedicated
Netmgr
Type and sequence of creation
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
Type and sequence of creation
Dedicated server
DB_FILE_DEST
24. The ____ migrates data from older versions to newer versions of the database.
Data Upgrade Assistant
Multiple
Tnsnames.ora
OPEN
25. In the SQL*Plus statement CONNECT /@ORACLASS AS SYSDBA - the ____ tells the database to use OS authentication.
Administrator
Single-instance server
SGA
/
26. SHUTDOWN ____ simply stops all Oracle processes - and releases all memory buffers.
ABORT
/
Operating system
OPEN
27. A(n) ____ database is used to service Internet applications.
Shared pool
OLTP
NORMAL
Network name
28. 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
Oradata
By separating data from software
Lsnrctl
29. SHUTDOWN ____ disconnects all users - rolls back pending transactions - and prohibits new connections and new transactions even for already connected users.
IMMEDIATE
Net Manager
Application server tier
TRANSACTIONAL
30. A ____ file is an administrative file containing up-to-date information on the database structure - log files - checkpoints; critical file for opening the database.
Schema
PMON
.sql
Control
31. Whenever a change is made to data - the ____ stores a copy of the changed data and the original data - in case it is needed.
Dispatcher
Redo log buffer
Data Warehouse
Data Dictionary
32. Oracle has standardized its software so that it looks and acts identically at the user interface level on...
Type and sequence of creation
ORACLE_BASE
Application server tier
All platforms
33. 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.
DB_CREATE_FILE_DEST
Custom
MOUNT
PL/SQL
34. The DBA authentication method encompasses the method used to validate logon of users with the SYSDBA or ____ role.
Net Manager
Dedicated
MOUNT
SYSOPER
35. 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.
Tnsnames.ora
.sql
PMON
ORACLE_SID
36. The initialization configuration parameters file is ____.
Init.ora
Net Services
$ORACLE_HOME/network/admin
Shared pool
37. You can start and stop the listener using the listener control utility (____).
Lsnrctl
More than one
Analyze Wizard
LOGFILES
38. The ____ collects statistics about tables or objects - validates tables - finds continuing rows.
DBCA
Multiple
Program Global Area (PGA)
Analyze Wizard
39. ____ is a valid client installation configuration.
.sql
All platforms
Custom
Administrator
40. Oracle executable files are stored in a directory tree referred to as ____.
Transaction Processing
Tnsnames.ora
ORACLE_HOME
OLTP
41. _________ databases can be managed within OEM.
Tnsnames.ora
Multiple
Tnsnames.ora
Custom
42. Load balancing between multiple listener processes is placed in the ____ configuration file on the client computer.
LOGFILES
Application server tier
Tnsnames.ora
SYSOPER
43. SHUTDOWN ____waits for all users to log off - prohibits new connections - forcibly rolls back currently running transactions - and then shuts down the database.
OLTP
NORMAL
DB_FILE_DEST
Program Global Area (PGA)
44. The ____ process cleans up after user sessions are finished.
SGA
MOUNT
PMON
TNS
45. A ____ is a physical file on the computer disk containing data - such as tables and indexes.
Datafile
Tnsnames.ora
OLTP
Net Services
46. The ____ log is essential because it will contain all the essential information for the smooth running of your database.
ORACLE_HOME
Network name
Alert
Custom
47. When choosing the DBA authentication method - you can choose between ____ and password file authentication.
Data Upgrade Assistant
Multiple
Operating system
Redo log
48. When the ____ initialization parameter is set - Oracle 10g knows where to locate all the datafiles.
OLTP
Network name
Listener
DB_FILE_DEST
49. The ____ contains many of the memory buffer components for an up and running (online) Oracle instance.
SGA
Control
More than one
Tnsnames.ora
50. The ____ database configuration option allows for a lot of change activity - raising concurrency requirements - and lowering I/O activity requirements.
LOGFILES
Schema
Transaction Processing
Analyze Wizard
Sorry!:) No result found.
Can you answer 50 questions in 15 minutes?
Let me suggest you:
Browse all subjects
Browse all tests
Most popular tests
Major Subjects
Tests & Exams
AP
CLEP
DSST
GRE
SAT
GMAT
Certifications
CISSP go to https://www.isc2.org/
PMP
ITIL
RHCE
MCTS
More...
IT Skills
Android Programming
Data Modeling
Objective C Programming
Basic Python Programming
Adobe Illustrator
More...
Business Skills
Advertising Techniques
Business Accounting Basics
Business Strategy
Human Resource Management
Marketing Basics
More...
Soft Skills
Body Language
People Skills
Public Speaking
Persuasion
Job Hunting And Resumes
More...
Vocabulary
GRE Vocab
SAT Vocab
TOEFL Essential Vocab
Basic English Words For All
Global Words You Should Know
Business English
More...
Languages
AP German Vocab
AP Latin Vocab
SAT Subject Test: French
Italian Survival
Norwegian Survival
More...
Engineering
Audio Engineering
Computer Science Engineering
Aerospace Engineering
Chemical Engineering
Structural Engineering
More...
Health Sciences
Basic Nursing Skills
Health Science Language Fundamentals
Veterinary Technology Medical Language
Cardiology
Clinical Surgery
More...
English
Grammar Fundamentals
Literary And Rhetorical Vocab
Elements Of Style Vocab
Introduction To English Major
Complete Advanced Sentences
Literature
Homonyms
More...
Math
Algebra Formulas
Basic Arithmetic: Measurements
Metric Conversions
Geometric Properties
Important Math Facts
Number Sense Vocab
Business Math
More...
Other Major Subjects
Science
Economics
History
Law
Performing-arts
Cooking
Logic & Reasoning
Trivia
Browse all subjects
Browse all tests
Most popular tests