1Z0-062 Oracle Database 12c Administration

Exam Number: 1Z0-062
Exam Title: Oracle Database 12c Administration
Associated Certification Paths Oracle Database 12c Administrator Certified Associate
Duration: 120 minutes
Number of Questions: 67
Passing Score: 64%
Beta exam score reports will be available approximately 11 weeks after the close of the Beta Exam. You will receive an email with instructions on how to access your beta exam results.
View passing score policy
Validated Against: This exam has been validated against Oracle Database 12.1.0.1.0.
Format: Multiple Choice

Complete Recommended Training

Complete the training below to prepare for your exam (optional):

Oracle Database 12c: Administration Workshop

Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.

Exam Preparation Seminar
Exam Prep Seminar Package: Oracle Database 12c Administrator Certified Associate
Certification Exam Prep Seminar: Oracle Database 12c: Install and Admin

Practice Exams
Practice Exams: Oracle Authorized practice exam from Kaplan IT Training: 1Z0-062 – Oracle Database 12c: Installation and Administration

TEMAS DE EXAMEN Administración de Oracle Database 12c 1Z0-062
(Examen 1Z0-062 in Español -150 minutos; 77 preguntas; 65% puntaje de aprobación)

Exploring the Oracle Database Architecture
List the architectural components of Oracle Database
Explain the memory structures
Describe the background processes

Oracle Database Management Tools
Use database management tools

Oracle Database Instance
Understand initialization parameter files
Start up and shut down an Oracle database instance
View the alert log and access dynamic performance views

Configuring the Oracle Network Environment
Configure Oracle Net Services
Use tools for configuring and managing the Oracle network
Configure client-side network
Configure communication between databases

Administering User Security
Create and manage database user accounts
Grant and revoke privileges
Create and manage roles
Create and manage profiles

Managing Database Storage Structures
Describe the storage of table row data in blocks
Create and manage tablespaces

Create and manage tablespaces
Explain how Oracle database server automatically manages space
Save space by using compression
Use the Segment Advisor
Reclaim wasted space from tables and indexes by using the segment shrink functionality

Managing Undo Data
Explain DML and undo data generation
Monitor and administer undo data
Describe the difference between undo data and redo data
Configure undo retention

Managing Data Concurrency
Describe the locking mechanism and how Oracle manages data concurrency
Monitor and resolve locking conflicts

Implementing Oracle Database Auditing
Enable standard database auditing and unified auditing

Backup and Recovery Concepts
Identify the importance of checkpoints, redo log files, and archive log files

Backup and Recovery Configuration
Configure the fast recovery area
Configure ARCHIVELOG mode

Performing Database Backups
Create consistent database backups
Back up your database without shutting it down
Create incremental backups
Automate database backups
Manage backups

Performing Database Recovery
Determine the need for performing recovery
Use Recovery Manager (RMAN) and the Data Recovery Advisor to perform recovery of the control file, redo log file and data file

Moving Data
Describe ways to move data
Use SQL*Loader to load data from a non-Oracle database
Use external tables to move data via platform-independent files
Explain the general architecture of Oracle Data Pump
Use Data Pump Export and Import to move data between Oracle databases

Performing Database Maintenance
Use server-generated alerts

Managing Performance: SQL Tuning
Use the SQL Tuning advisor

Automating Tasks by Using Oracle Scheduler
Use Oracle Scheduler to simplify management tasks
Use job chains to perform a series of related tasks
Use Scheduler jobs on remote systems
Use advanced Scheduler features to prioritize jobs

Creating an Oracle Database Using DBCA
Generate database creation scripts by using DBCA
Manage database design templates by using DBCA

Upgrading Oracle Database Software
Describe data migration methods
Describe the upgrade process

Introduction to DBAAS
Recognize the difference between a DBaaS Instance and a Database Instance
Navigate with My Services Dashboard
User authentication and roles
Generate a Secure Shell (SSH) Public/Private Key Pair

QUESTION 1 – (Topic 1)
Examine the following query output:

You issue the following command to import tables into the hr schema:
$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr
TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y
Which statement is true?

A. All database operations performed by the impdp command are logged.
B. Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.
C. Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.
D. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

Answer: C

Explanation:
Oracle Data Pump disable redo logging when loading data into tables and when creating indexes.
The new TRANSFORM option introduced in data pumps import provides the flexibility to turn off the redo generation for the objects during the course of import. The Master Table is used to track the detailed progress information of a Data Pump job.
The Master Table is created in the schema of the current user running the Pump Dump export or import, and it keeps tracks of lots of detailed information.

QUESTION 2 – (Topic 1)
You execute the following commands to audit database activities:
SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;
SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL;
Which statement is true about the audit record that generated when auditing after instance restarts?

A. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.
B. One audit record is created for every successfulexecution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.
C. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution planfor the SQL statements.
D. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.
E. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.

Answer: A

Explanation:
Note:
* BY SESSION
In earlier releases, BY SESSION caused the database to write a single record for all SQL statements or operations of the same type executed on the same schema objects in the same session. Beginning with this release (11g) of Oracle Database, both BY SESSION and BY ACCESS cause Oracle Database to write one audit record for each audited statementand operation.
* BY ACCESS
Specify BY ACCESS if you want Oracle Database to write one record for each audited statement and operation.
Note:
If you specify either a SQL statement shortcut or a system privilege that audits a data definition language (DDL)statement, then the database always audits by access. In all other cases, the database honors the BY SESSION or BY ACCESS specification.
* For each audited operation, Oracle Database produces an audit record containing this information:
/ The user performing the operation
/ The type of operation
/ The object involved in the operation
/ The date and time of the operation
References:

QUESTION 3 – (Topic 1)
Which two statements are true about extents?

A. Blocks belonging to an extent can be spread across multiple data files.
B. Data blocks in an extent are logically contiguous but can be non-contiguous on disk.
C. The blocks of a newly allocated extent, although free, may have been used before.
D. Data blocks in an extent are automatically reclaimed for use by other objects in a tablespace when all the rows in a table are deleted.

Answer: B,C

QUESTION 4 – (Topic 1)
Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):

Which three are prerequisites for successful execution of the command?

A. The import operation must be performed by a user on the target database by a user with theDATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user with the DATAPUMP_EXP_FULL_DATABASE role on the source database.
B. All the user-defined tablespaces must be in read-only mode on the source database.
C. The export dump file must be created before starting the import on the target database.
D. The source and target database must be running on the same operating system (OS) with the same endianness.
E. The impdp operation must be performed by the same user that performed the expdpoperation.

Answer: A,B,D

Explanation:
In this case we have run the impdp without performing any conversion if endian format is different then we have to first perform conversion.

QUESTION 5 – (Topic 1)
Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.
You want to issue the following RMAN command:
RMAN > BACKUP TABLESPACE hr_pdb:userdata;
Which task should you perform before issuing the command?

A. Place the root container in ARHCHIVELOG mode.
B. Take the user data tablespace offline.
C. Place the root container in the nomount stage.
D. Ensure that HR_PDB is open.

Answer: A

Click here to view complete Q&A of 1Z0-062 exam
Certkingdom Review, Certkingdom PDF Torrents