File Info
| Exam | Upgrade to Oracle Database 12c |
| Number | 1z0-060 |
| File Name | Oracle.1z0-060.CertKey.2018-08-14.111q.tqb |
| Size | 2 MB |
| Posted | Aug 14, 2018 |
| Download | Oracle.1z0-060.CertKey.2018-08-14.111q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
What are three purposes of the RMAN “FROM” clause?
- to support PUSH-based active database duplication
- to support synchronization of a standby database with the primary database in a Data environment
- to support PULL-based active database duplication
- to support file restores over the network in a Data Guard environment
- to support file recovery over the network in a Data Guard environment
Correct answer: BDE
Explanation:
* With a control file autobackup, RMAN can recover the database even if the current control file, recovery catalog, and server parameter file are inaccessible. * RMAN uses a recovery catalog to track filenames for all database files in a Data Guard environment. A recovery catalog is a database schema used by RMAN to store metadata about one or more Oracle databases. The catalog also records where the online redo logs, standby redo logs, tempfiles, archived redo logs, backup sets, and image copies are created. * With a control file autobackup, RMAN can recover the database even if the current control file, recovery catalog, and server parameter file are inaccessible.
* RMAN uses a recovery catalog to track filenames for all database files in a Data Guard environment. A recovery catalog is a database schema used by RMAN to store metadata about one or more Oracle databases. The catalog also records where the online redo logs, standby redo logs, tempfiles, archived redo logs, backup sets, and image copies are created.
Question 2
You notice that the performance of your production 24/7 Oracle 12c database significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance.
How can you detect the cause of the degraded performance?
- Enable Memory Access Mode, which reads performance data from SGA.
- Use emergency monitoring to fetch data directly from SGA analysis.
- Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
- Use Active Session History (ASH) data and hang analysis in regular performance monitoring.
- Run ADDM in diagnostic mode.
Correct answer: B
Question 3
You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC? (Choose three.)
- ASM disk groups with ASM disks consisting of Exadata Grid Disks.
- ASM disk groups with ASM disks consisting of LUNs on any Storage Area Network array
- ASM disk groups with ASM disks consisting of any zero-padded NFS-mounted files
- Database files stored in ZFS and accessed using conventional NFS mounts.
- Database files stored in ZFS and accessed using the Oracle Direct NFS feature
- Database files stored in any file system and accessed using the Oracle Direct NFS feature
- ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
Correct answer: AEG
Explanation:
HCC requires the use of Oracle Storage – Exadata (A), Pillar Axiom (G) or Sun ZFS Storage Appliance (ZFSSA). Note:Hybrid Columnar Compression, initially only available on Exadata, has been extended to support Pillar Axiom and Sun ZFS Storage Appliance (ZFSSA) storage when used with Oracle Database Enterprise Edition 11.2.0.3 and above Oracle offers the ability to manage NFS using a feature called Oracle Direct NFS (dNFS). Oracle Direct NFS implements NFS V3 protocol within the Oracle database kernel itself. Oracle Direct NFS client overcomes many of the challenges associated with using NFS with the Oracle Database with simple configuration, better performance than traditional NFS clients, and offers consistent configuration across platforms. HCC requires the use of Oracle Storage – Exadata (A), Pillar Axiom (G) or Sun ZFS Storage Appliance (ZFSSA).
Note:
- Hybrid Columnar Compression, initially only available on Exadata, has been extended to support Pillar Axiom and Sun ZFS Storage Appliance (ZFSSA) storage when used with Oracle Database Enterprise Edition 11.2.0.3 and above
- Oracle offers the ability to manage NFS using a feature called Oracle Direct NFS (dNFS). Oracle Direct NFS implements NFS V3 protocol within the Oracle database kernel itself. Oracle Direct NFS client overcomes many of the challenges associated with using NFS with the Oracle Database with simple configuration, better performance than traditional NFS clients, and offers consistent configuration across platforms.
