Create Next App

Exam contains 175 questions

Page 3 of 30

Question 13 🔥

Which three are true about the large pool for an Oracle database instance that supports shared server connections?

Which database solution meets these requirements?

A. Allocates memory for RMAN backup and restore operations

Highly voted

C. Contains a cursor area for storing runtime information about cursors

Highly voted

D. Contains stack space

Highly voted

E. Contains a hash area performing hash joins of tables

Highly voted

B. Allocates memory for shared and private SQL areas

Highly voted

Discussion of the question

Question 14 🔥

What are three purposes of the RMAN "FROM" clause?

Which database solution meets these requirements?

A. to support PUSH-based active database duplication

Highly voted

B. to support synchronization of a standby database with the primary database in a Data environment

Highly voted

C. to support PULL-based active database duplication

Highly voted

D. to support file restores over the network in a Data Guard environment

Highly voted

E. to support file recovery over the network in a Data Guard environment

Highly voted

Discussion of the question

Question 15 🔥

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?

Which database solution meets these requirements?

A. Enable Memory Access Mode, which reads performance data from SG

Highly voted

B. Use emergency monitoring to fetch data directly from SGA analysis.

Highly voted

C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.

Highly voted

D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring.

Highly voted

E. Run ADDM in diagnostic mode.

Highly voted

Discussion of the question

Question 16 🔥

You plan to drop the column of a table that has Flashback Archiving enabled.You want to ensure minimal service disruption.How would you do this in your Oracle 12c Database?

Which database solution meets these requirements?

D. Drop the column using the ALTER TABLE statement.

Highly voted

E. Disassociate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVDISASSOCIATE_FBA procedure, set the column unused, and re-associate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVRESASSOCIATE_FBA procedure.

Highly voted

A. Disable Flashback Archiving, set the column unused, and re-enable Flashback Archiving.

Highly voted

B. Disable Flashback Archiving, drop the column unused, and re-enable Flashback Archiving.

Highly voted

C. Disassociate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA procedure, drop the column, and re-associate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.RESASSOCIATE_FBA procedure.

Highly voted

Discussion of the question

Question 17 🔥

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 ColumnarCompressed (HCC) format.Which three storage options support the use of HCC? (Choose three.)

Which database solution meets these requirements?

A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.

Highly voted

B. ASM disk groups with ASM disks consisting of LUNs on any Storage Area Network array

Highly voted

C. ASM disk groups with ASM disks consisting of any zero-padded NFS-mounted files

Highly voted

D. Database files stored in ZFS and accessed using conventional NFS mounts.

Highly voted

E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature

Highly voted

F. Database files stored in any file system and accessed using the Oracle Direct NFS feature

Highly voted

G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

Highly voted

Discussion of the question

Question 18 🔥

Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)

Which database solution meets these requirements?

A. OMF cannot be used in a database that already has data files created with user-specified directions.

Highly voted

B. The file system directions that are specified by OMF parameters are created automatically.

Highly voted

C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.

Highly voted

D. OMF automatically creates unique file names for table spaces and control files.

Highly voted

E. OMF may affect the location of the redo log files and archived log files.

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_060

Exam contains 175 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us