2018 Jan Oracle Official New Released 1z0-062
100% Free Download! 100% Pass Guaranteed!

Oracle Database 12c: Installation and Administration

Question No: 111

Your database instance has started using an SPFILE. Examine the RMAN configuration settings:

Latesttests 2018 PDF and VCE

You execute the command:


Which three types of files are backed up by using this command?

  1. online redo log files

  2. control file


  4. archived redo log files

  5. data file(s)

  6. PFILE

Answer: B,C,E Explanation:


Question No: 112

Your database is open and the listener LISTNENER is up. You issue the command: LSNRCTLgt; RELOAD

What is the effect of reload on sessions that were originally established by listener?

  1. Only sessions based on static listener registrations are disconnected.

  2. Existing connections are not disconnected; however, they cannot perform any operations until the listener completes the re-registration of the database instance and service handlers.

  3. The sessions are not affected and continue to function normally.

  4. All the sessions are terminated and active transactions are rolled back.

Answer: B

Question No: 113

Which action takes place when a file checkpoint occurs?

  1. The checkpoint position is advanced in the checkpoint queue.

  2. All buffers for a checkpointed file that were modified before a specific SCN are written to disk by DBWnand the SCN is stored in the control file.

  3. The Database Writer process (DBWn) writes all dirty buffers in the buffer cache to data files.

  4. The Log Writer process (LGWR) writes all redo entries in the log buffer to online redo log files.

Answer: C

Question No: 114

You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP schema.

The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has

been granted the FLASHBACK ANY TABLE system privilege.

What is the quickest way to recoverthe contents of the OCA.EXAM_RESULTS table to the OCP schema?


  2. Recover the table using traditional Tablespace Point In Time Recovery.

  3. Recoverthe table using Automated Tablespace Point In Time Recovery.

  4. Recovery the table using Database Point In Time Recovery.


Answer: C Explanation:

RMAN tablespace point-in-time recovery (TSPITR).

Recovery Manager (RMAN) TSPITR enables quick recovery of one or more tablespaces in a database to an earlier time without affecting the rest of the tablespaces and objects in the database.

Fully Automated(the default)

In this mode, RMAN manages the entire TSPITR process including the auxiliary instance. You specify the tablespaces of the recovery set, an auxiliary destination, the target time, and you allow RMAN to manage all other aspects of TSPITR.

Thedefault mode is recommended unless you specifically need more control over the location of recovery set files after TSPITR, auxiliary set files during TSPITR, channel settings and parameters or some other aspect of your auxiliary instance.

Question No: 115

Which two statementsare true about Oracle Managed Files (OMF)?

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

    specified directions.

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

  3. OMF can beused with ASM disk groups, as well as with raw devices, for better file management.

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

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

Answer: D,E Explanation:

D: The database internally uses standard file system interfaces to create and delete files as needed for the following database structures:

Tablespaces Redo log files Control files Archived logs

Block change tracking files Flashback logs

RMAN backups


* Using Oracle-managed files simplifies the administration of an Oracle Database. Oracle- managed files eliminate the need for you, the DBA, to directly manage the operating system files that make up an Oracle Database. With Oracle-managed files, you specify file system directories in which the database automatically creates, names, and manages files at the database object level. For example, you need only specify that you want to create a tablespace; you do not need to specify the name and path of the tablespace#39;s datafile with the DATAFILE clause. References:

Question No: 116

Which three statements are true about SQL plan directives?

  1. They are tied to a specific statement or SQL ID.

  2. They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.

  3. They are used to gather only missing statistics.

  4. Theyare created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.

  5. They instruct the optimizer to create only column group statistics.

  6. Improve plan accuracy by persisting both compilation andexecution statistics in the SYSAUX tablespace.

Answer: B,D,E Explanation:

During SQL execution, if a cardinality misestimate occurs, then the database creates SQL plan directives. During SQL compilation, the optimizer examines the query corresponding tothe directive to determine whether missing extensions or histograms exist (D). The optimizer records any missing extensions. Subsequent DBMS_STATS calls collect statistics for the extensions.

The optimizer uses dynamic sampling whenever it does not have sufficient statistics corresponding to the directive. (B, not C)

E: Currently, the optimizer monitors only column groups. The optimizer does not create an extension on expressions.


Not A: SQL plan directives are not tied to a specific SQL statement or SQL ID.


* A SQL plan directive is additional information and instructions that the optimizer can use to generate a more optimal plan. For example, a SQL plan directive can instruct the optimizer to record a missing extension.

Question No: 117

What happens if a maintenance window closes before a job that collects optimizer statistics completes?

  1. The job is terminated and the gatheredstatistics are not saved.

  2. The job is terminated but the gathered statistics are not published.

  3. The job continues to run until all statistics are gathered.

  4. The job is terminated and statistics for the remaining objects are collected the next time the maintenance window opens.

Answer: D

Question No: 118

Which two categories of segments are analyzed by the Automatic Segment Advisor?

  1. segments in tablespaces that have exceeded a critical or warning space threshold

  2. segments that have the highest growth rate in a database

  3. segments that are sparsely populated and have more than 10% of free space below the high water mark.

  4. segments that have unusable indexes

  5. segmentsfor tables created using ADVANCED ROW COMPRESSION

Answer: A,B Explanation:


Question No: 119

A database uses Automatic Storage Management (ASM) as database storage, which has a diskgroup, DATA1, which is created as follows:

Latesttests 2018 PDF and VCE

What happens whenthe FAILGRP1 failure group is corrupted?

  1. Mirroring of allocation units occurs within the FAILGRP2 failure group.

  2. Transactions that are using the diskgroup fail.

  3. ASM does not mirror any data and newly allocated primary allocation units (AU) arestored in the FAILGRP2 failure group.

  4. Data in the FAILGRP1 failure group is moved to the FAILGRP2 failure group and rebalancing is started.

Answer: B

Question No: 120

Your database is configured in ARCHIVELOG mode, and daily full database backups are taken. RMAN is configured to perform control file autobackups.

Which statement is true about the loss of aduplexed control file?

  1. The database remains open but transactions are not permitted.

  2. The database instance aborts, and media recovery is required after restoration of the control file to open the database.

  3. The database instance remains open and the control file can be restored without shutting down the database.

  4. The database instance aborts and a control file restore operation does not require media recovery.

Answer: C

100% Free Download!
Download Free Demo:1z0-062 Demo PDF
100% Pass Guaranteed!
Download 2018 Latesttests 1z0-062 Full Exam PDF and VCE

Latesttests ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 Latesttests IT Certification PDF and VCE