Free 1Z0-062 Exam Dumps

Question 91

What action must you take to ensure complete database recovery till the point of failure?

A. Multiplex the control files
B. Duplex the RMAN backup sets.
C. Multiplex the online redo log files.
D. Configure the database to run in ARCHIVELOG mod

Correct Answer:D

Question 92

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB). The characteristics of the non-CDB are as follows:
– Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit
– Character set: AL32UTF8
– National character set: AL16UTF16
– O/S: Oracle Linux 6 64-bit
The characteristics of the CDB are as follows:
– Version: Oracle Database 12c Release 1 64-bit
– Character Set: AL32UTF8
– National character set: AL16UTF16
– O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

A. Transportable database
B. Transportable tablespace
C. Data Pump full export/import
D. The DBMS_PDB package
E. RMAN

Correct Answer:B
* Overview, example:
- Log into ncdb12c as sys
- Get the database in a consistent state by shutting it down cleanly.
- Open the database in read only mode
- Run DBMS_PDB.DESCRIBE to create an XML file describing the database.
- Shut down ncdb12c
- Connect to target CDB (CDB2)
- Check whether non-cdb (NCDB12c) can be plugged into CDB(CDB2)
- Plug-in Non-CDB (NCDB12c) as PDB(NCDB12c) into target CDB(CDB2).
- Access the PDB and run the noncdb_to_pdb.sql script.
- Open the new PDB in read/write mode.
* You can easily plug an Oracle Database 12c non-CDB into a CDB. Just create a PDB manifest file for the non-CDB, and then use the manifest file to create a cloned PDB in the CDB.
* Note that to plug in a non-CDB database into a CDB, the non-CDB database needs to be of version 12c as well. So existing 11g databases will need to be upgraded to 12c before they can be part of a 12c CDB.

Question 93

Your database is configured in ARCHIVELOG mode. Examine the RMAN configuration parameters:
1Z0-062 dumps exhibit
Examine the command:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
What is the outcome?

A. It fails because the DELETE INPUT option can be used only with the BACKUP AS BACKUPSET command.
B. It executes successfully and creates a backup set of the database along with archived log files and then deletes the original archived log files.
C. It executes successfully and creates an image copy of the database along with archive log files and then deletes the original archived log files.
D. It fails because the DELETE INPUT option can be used only with the BACKUP AS COPY command.

Correct Answer:B
References: https://docs.oracle.com/cd/B13789_01/server.101/b10734/rcmbackp.htm

Question 94

Which three statements are true about naming methods? (Choose three.)

A. Local naming supports multiple protocols, but for any one connection, the client and server must use the same protocol.
B. In the Easy Connect method, clients can connect to a database server by using the host name of the database with an optional port and service name.
C. In the Easy Connect method, the listener port and IP address must be provided for the connection to be successful.
D. The local naming method does not support connect-time failover and load-balancing options.
E. The directory naming method supports connect-time failover and load-balancing option

Correct Answer:ABE

Question 95

Which four statements are true about the components of the Oracle Scheduler? (Choose four.)

A. A schedule can be specified to a single job only.
B. A scheduler job can point to a chain instead of pointing to a single program object.
C. A job may get started automatically when a window opens.
D. A program and job can be specified as part of a schedule definition.
E. A job is specified as part of a program specification.
F. A program can be used in the definition of multiple jobs.
G. A program and schedule can be specified as part of a job definition.

Correct Answer:BCFG
References: https://docs.oracle.com/cd/B19306_01/server.102/b14231/schedover.htm