CompTIA Online Training

1Z0-074 Upgrade Oracle DBA 11g or 12c to 12c R2

January 25, 2019 by admin

Exam Title: Upgrade Oracle DBA 11g or 12c to 12c R2
Exam Number: 1Z0-074
Exam Price: $245.00 More on exam pricing
Format: Multiple Choice
Duration: 120 Minutes
Number of Questions: 75
Passing Score: 63%
Validated Against: Upgrade to Oracle Database 12c R2 Administration Certified Professional

Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1
Oracle Database 12c R1: New Features for Administrators Ed 2

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.

Practice Exams: Oracle Authorized practice exam from Kaplan IT Training: 1Z0-074 Upgrade Oracle DBA 11g or 12c to 12c R2 (OCP)

Using CDBs and Application Containers
Describe the application root and application seed
Create an application container
Explain application install and upgrade

Creating Different Types of PDBs
Unplug and plug an encrypted PDB in one-step operation
Describe near-zero downtime PDB relocation with local UNDO tablespaces
Configure a proxy PDB and query data across CDBs

Managing Performance in PDBs and CDBs
Manage memory allocation between PDBs
Manage resources allocation between PDBs with Resource Manager Performance Profile

Creating and Managing Profiles and Privileges
Enhance the security of administrative users

Using Data Redaction
Create and reuse redaction formats from library

Using TSPD policies with Auditing and Column Encryption
Use TSDP policies with other Oracle features like auditing and column encryption

Recovering a database
Perform incomplete recover
Restore and recover database
Recover table

Using Oracle Data Pump, SQL*Loader and External Tables
Explain Oracle Data Pump enhancements

Tuning SQL Statements
Describe the Optimizer Statistics Advisor
Use SQL Performance Analyzer (SPA) enhancements to make it resilient to certain workloads which can cause divergence
* Triggers with DMLs
* Usage of SYSDATE
* Rows to fetch
New SQL JOIN processing
Continuous Adaptive Query Plans
Use Adaptive Execution Plans
Use enhanced features of statistics gathering

Applying Different Types of Partitioning
Explain Interval Subpartitioning
Explain Auto-List Partitioning and Subpartitioning
Describe composite partitioning
Describe read-only partition

Using Diagnostic Enhancements
Describe ADR file automatic space management
Collect diagnostic information by using TFA
Trace data pump operations while job is running
Diagnose refresh performance issues related to MV refreshed statistics

Using SQL Enhancements
Describe the new SQLcl utility
Describe the SQL identifiers new lengths
Describe the new VALIDATE_CONVERSION function

Administrating Storage
Administer ASM Instances, ASM Diskgroups and ASM disk

Managing Users and Users Access to Data in a Multitenant Environment
Manage common and local users, privileges, roles and objects in application containers
Manage PDB Lockdown profile

Recovering and Flashing back CDBs and PDBs
Use PDB close abort to recover a PDB from SYSTEM tablespace damage
Perform flashback PDBs

Upgrading Database from 11g or 12.1 to 12.2
Upgrade 12.1.0.1 CDBs to 12.2
Use cross-platform PDB backupsets to import into a CDB

Performing Unified Auditing
Audit all users to whom roles are granted directly

Using Data Encryption
Encrypt / decrypt / re-key all tablespaces online

Creating and Managing backup and recovery catalog
Upgrade and drop the catalog in one command
Automate the two step manual process into one recovery operation after missing logs found during RECOVER DATABASE
Describe REPAIR FAILURE enhanced command
Describe the filtered partition maintenance operations

Transporting a tablespace
Transport encrypted tablespace
Describe the online table and partition move features
Use upfront check on available disk space and REMAP TABLE to complete a table recovery across schemas
Describe some more non-blocking DDLs

Performing In Memory Column Store
Explain how to deploy the in-memory column store in a database (static and dynamic)

Memory and Other Performance Enhancements
Manage session PGA limit
Reduce cursor invalidations for DDLs
Describe the Advanced Index Compression ( HIGH )
Manage real-time materialized views with on query computation

Manageability
Describe DB Operation enhancements (some enhancements deferred out of 12.2.0.1)

Managing Oracle Database Cloud Services
Describe the Oracle Public Cloud Services
Describe the Oracle Database Cloud Services console
Create a database deployment
Explain database deployment backup and recovery automatic procedures
Monitor database deployment using DBaaS Monitor console
Describe the differences between database deployments and on-premises databases
Migrate on-premises database to Oracle Database Public Cloud Services

Using Information Lifecycle Management and Storage Enhancements)
Use ILM features

QUESTION: 1
Which two statements are true about application containers? (Choose two.)

A. A regular PDB can be plugged in to an application container provided it is an Oracle Database 12c Release 2 (12.2) PDB.
B. An application root can be unplugged from a CDB and plugged in to another CDB.
C. An application PDB can belong to multiple application containers.
D. User-created common objects are accessible from the CDB root.
E. The application root stores user-created common objects and Oracle-supplied common objects.
F. Multiple application roots can be created in one container database.

Answer: D,E
Reference:
https://blogs.oracle.com/oraclemagazine/multitenant-database-management

QUESTION: 2
From which two failure scenarios can a database be restored and recovered with the REPAIR
DATABASE
command? (Choose two.)

A. loss of ARCHIVELOGS
B. loss of a redo log member
C. loss of a noncritical data file
D. loss of all copies of the control file
E. loss of a critical data file such as SYSTEM, SYSAUX or UNDO
F. loss of SPFILE

Answer: D,E
Reference:
https://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta033.htm#RCMRF199

QUESTION: 3
Users BIXBY, RLAYTON, and MURDOK each have a table named CUST_RECORDS in their schemA.
BIXBY has created a procedure, UPDATE_CUST, which updates the CUST_RECORDS table with
invoker’s right.
BIXBY grants the execute permission on UPDATE_CUST to the RLAYTON user.
When RLAYTON executes the UPDATE_CUST procedure, which table does the procedure attempt to
update?

A. CUST_RECORDS table in Bixby’s schema
B. CUST_RECORDS table in Murdok’s schema
C. CUST_RECORDS table in Rlayton’s schema
D. CUST_RECORDS table in the schema of Bixby and Rlayton
E. CUST_RECORDS table in the schema of Bixby, Rlayton, and Murdok

Answer: C

QUESTION: 4
Identify two types of files that are generated by the Pre-Upgrade Information tool as part of the
database
upgrade prerequisite checks? (Choose two.)

A. expdp scripts to export database objects belonging to the SYS schema
B. a log file containing a list of pre-upgrade patches to be applied
C. RMAN database backup scripts
D. a log file with tool recommendations and requirements
E. pre- and post-upgrade fixup scripts

Answer: D,E
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/usingpreupgradeinformationtool-
for-oracle-database.html#GUID-C0219AF1-AD43-4097-B358-E53E48958647

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

Best Oracle 1Z0-074 Certification, Oracle 1Z0-074 Training at certkingdom.com