| |
 |
| |
|
| Duration: |
120 minutes |
| Number of Questions: |
68 |
| Passing Score: |
70% |
|
Passing score subject to change. View Details
|
|
Recommended Training and Preparation
Additional Information & Resources
Exam Topics
Fraudulent Activity Policy
Recommended Training and Preparation
Additional Information & Resources
Exam Topics
| Oracle Architectural Components
|
[ ] |
Describe the Oracle architecture and its main components
|
[ ] |
List (describe) the structures involved in connecting
a user to an Oracle instance |
| Getting Started With the Oracle
Server |
[ ] |
Identify common database administrative tools
available to a DBA |
| Managing an Oracle Instance
|
[ ] |
Create and manage initialization parameter files |
[ ] |
Start up and shut down an instance |
[ ] |
Monitor the use of diagnostic files |
| Creating a Database |
[ ] |
Describe the prerequisites necessary for database
creation |
[ ] |
Create a database manually |
| Data Dictionary Content and Usage
|
[ ] |
Identify key data dictionary components |
[ ] |
Identify the contents and uses of the data dictionary |
[ ] |
Query the data dictionary |
| Maintaining the Control File
|
[ ] |
Explain the uses of the control file |
[ ] |
Mulitplex and manage the control file |
[ ] |
Obtain control file information |
|
| Maintaining Redo Log Files
|
[ ] |
Explain the purpose of online redo log files |
[ ] |
Describe the structure of online redo log files |
[ ] |
Control log switches and checkpoints |
[ ] |
Mulitplex and maintain online redo log files |
| Managing Tablespaces and Data
files |
[ ] |
Describe the logical structure of tablespaces
within the database |
[ ] |
Create tablespaces |
[ ] |
Allocate space for temporary segments |
[ ] |
Change the status of tablespaces |
[ ] |
Change the storage settings of tablespaces |
| Storage Structure and Relationships
|
[ ] |
List the segment types and their uses |
[ ] |
List the keywords that control block space usage |
[ ] |
Obtain information about storage structures from
the data dictionary |
| Managing Undo Data
|
[ ] |
Describe the purpose of undo data |
[ ] |
Implement Automatic Undo Management |
| Managing Tables |
[ ] |
Identify the various methods of storing data |
[ ] |
Create regular and temporary tables |
[ ] |
Reorganize, truncate, drop a table |
[ ] |
Drop a column within a table |
| Managing Indexes |
[ ] |
List the different types of indexes and their
uses |
[ ] |
Reorganize indexes |
[ ] |
Monitor the usage of an index |
|
| Maintaining Data Integrity
|
[ ] |
Describe the Types of Data
Integrity Constraints |
| Managing Users |
[ ] |
Create new database users |
[ ] |
Alter and drop existing database users |
[ ] |
Monitor information about existing
users |
| Managing Privileges
|
[ ] |
Identify system and object
privileges |
[ ] |
Grant and revoke privileges |
| Using Globalization Support |
[ ] |
Choose database character set and national character
set for a database |
[ ] |
Specify the language-dependent behavior using initialization
parameters, environment variables and the ALTER SESSION command |
| Basic Oracle Net Architecture |
[ ] |
Explain the key components of the Oracle Net layered
architecture |
[ ] |
Explain Oracle Net Services role in client server
connections |
[ ] |
Describe how web client connections are established
through Oracle networking products |
| Basic Net Server-Side Configuration
|
[ ] |
Identify how the listener responds to incoming connections
|
[ ] |
Configure the listener using Oracle Net Manager
|
[ ] |
Control the listener using the Listener Control
Utility (lsnrctl) |
[ ] |
Describe Dynamic Service Registration |
| Basic Oracle Net Services Client-Side
Configuration |
[ ] |
Describe the difference between host naming and
local service name resolution |
[ ] |
Use Oracle Net Configuration Assistant to configure:
Host Naming, Local naming method, Net service names |
[ ] |
Perform simple connection troubleshooting |
|
Oracle Certification Program Fraudulent Activity Policy
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.
If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered.
View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.
Printer View