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