[2018-3-29] Lead2pass Latest Oracle 1Z0-063 Exam Questions Free Download (181-190)

Easily Pass 1Z0-063 Exam With Lead2pass Updated Oracle 1Z0-063 Dumps.v.2018-3-29.236q:

https://www.lead2pass.com/1z0-063.html

QUESTION 181
Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):

1811

Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1 role?

A.    The command fails and gives an error because object privileges cannot be granted to a common user.
B.    The command fails because container is not set to current.
C.    The command succeeds and the common user c##admin can create a session and query the DBA_users view in cdb$root and all the PDBs.
D.    The command succeeds and the common user c##admin can create a session in cdb$root and all the PDBs, but can only query the dba_users view in cdb$root.
E.    The command succeeds and the common user c##admin can create a session and query the DBA_users view only in cdb$root.

Answer: C

QUESTION 182
You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES:

1821

Which two statements are true?

A.    The root and seed databases are included in the duplication.
B.    Only the SALES PDB is duplicated as the non-CDB CDBDUP.
C.    A backup of the SALES PDB must exist before the execution of the command.
D.    An auxiliary instance must have been started with the initialization parameter set to TRUE.
ENABLE_PLUGGABLE_DATABASE
E.    RMAN must be connected to a recovery catalog for the execution of the command.

Answer: AD
Explanation:
D: When duplicating a whole CDB or one more PDBs:
You must create the auxiliary instance as a CDB. To do so, start the instance with the following declaration in the initialization parameter file:
enable_pluggable_database=TRUE
A: To duplicate PDBs, you must create the auxiliary instance as a CDB. To do so, start the instance with the declaration enable_pluggable_database=TRUE in the initialization parameter file. When you duplicate one or more PDBs, RMAN also duplicates the root (CDB$ROOT) and the seed database (PDB$SEED).
The resulting duplicate database is a fully functional CDB that contains the root, the seed database, and the duplicated PDBs.
References: https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm

QUESTION 183
You create a new database by using the CREATE DATABASE command in SQL *Plus, with the ENABLE clause specified.
PLUGGABLE DATABASE

Which statement is true about the database that is created?

A.    It is created as a container database (CDB) with CDB$ROOT, PDB$SEED, and a pluggable database (PDB).
B.    It is created as a non-CDB that becomes a CDB after the first PDB is plugged in.
C.    It is created as a PDB that must be plugged into an existing CDB.
D.    It is created as a CDB with the CDB$ROOT and PDB$SEED databases.

Answer: D
Explanation:
The CREATE DATABASE command with the ENABLE PLUGGABLE DATABASE clause indicates that a CDB is being created. The CDB will contain a root (CDB$ROOT) and a seed (PDB$SEED).
References: https://docs.oracle.com/database/121/SQLRF/statements_5005.htm

QUESTION 184
Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing purposes, you want to replicate your database to another host, OUSERVER1, with the same directory structure. So, you copy the backups to the new host.

What must you do to make the database operational in OUSERVER1?

A.    Restore the control file from the backup by using the CATALOG option, restore the data files by using the SET NEWNAME command, and recover the data files.
B.    Restore the data files by using the NOCATALOG option and use the SET NEWNAME command to change the location.
C.    Restore the control file from the backup by using the NOCATALOG option, and then restore and recover the data files.
D.    Restore the data files from the backup by using the recovery catalog, use the SWITCH command to change the location, and recover the data files.

Answer: A
Explanation:
Catalog any backups not recorded in the repository with the CATALOG command.
Restore the data files to their original locations. If volume names have changed, then run SET NEWNAME commands before the restore operation and perform a switch after the restore operation to update the control file with the new locations for the data files, as shown in the following example.
Note: One way to name duplicate data files is to use the SET NEWNAME command before executing the DUPLICATE command. RMAN supports the following commands, listed in order of precedence:
1. SET NEWNAME FOR DATAFILE and SET NEWNAME FOR TEMPFILE
2. SET NEWNAME FOR TABLESPACE
3. SET NEWNAME FOR DATABASE
References: https://docs.oracle.com/database/121/BRADV/rcmadvre.htm

QUESTION 185
Examine the list of possible steps to transport a tablespace across platforms that have the same compatibility level, character sets, and endian format:

1. Make the tablespace read-only at the source database.
2. Export metadata from the source database.
3. Import metadata into the target database.
4. Transfer the dump file and data files to the target machine.
5. Convert data files by using Recovery Manager (RMAN).
6. Make the tablespace read-write at the target database.

Identify the required steps in the correct order.

A.    2, 4, and 3
B.    2, 4, 3, and 5
C.    1, 5, 2, 4, 3, and 6
D.    1, 2, 4, 3, and 6

Answer: D
Explanation:
Step 1 (1) : To copy tablespaces from one database to another using transportable tablespace, the source tablespaces are first kept in READ-ONLY mode (to ensure data consistency). Once the tablespaces are in READ-ONLY mode, the actual datafiles belonging to the source tablespaces are copied from source database to target database (using any available methods like scp, sftp, rcp, etc).
Step 2 (2): Once the tablespace is kept in READ-ONLY mode, we need to generate the metadata export of the tablespaces that needs to transported using the DataPump export utility.
Step 3 (4): Once the metadata export is generated on the source database for all the tablespaces that needs to be transported, we need to copy the Export Dump file as well as all the datafiles belonging to the tablespaces to be transported to the target database server.
References: http://www.oraclebuffer.com/oracle/migrate-oracle-database-using-transportable-tablespace/

QUESTION 186
In which three situations must you use a recovery catalog?

A.    when you want to store RMAN global scripts that can be used across multiple databases
B.    when you want to restrict the amount of space used by backups
C.    when you want to perform incremental backups by using a block change tracking file
D.    when you want to list data files that were in a target database at a given time by using the AT clause with the REPORT SCHEMA command
E.    when you want to maintain backup metadata longer than the period specified by the parameter
CONTROL_FILE_RECORD_KEEP_TIME

Answer: ADE
Explanation:
A: Some RMAN features function only when you use a recovery catalog. For example, you can store RMAN scripts in a recovery catalog. The chief advantage of a stored script is that it is available to any RMAN client that can connect to the target database and recovery catalog. Command files are only available if the RMAN client has access to the file system on which they are stored.
A local stored script is associated with the target database to which RMAN is connected when the script is created, and can only be executed when you are connected to this target database. A global stored script can be run against any database registered in the recovery catalog.
D: If you use a recovery catalog, then you can use the atClause to specify a past time, SCN, or log sequence number, as shown in these examples of the command:
RMAN> REPORT SCHEMA AT TIME ‘SYSDATE-14’; # schema 14 days ago RMAN> REPORT SCHEMA AT SCN 1000; # schema at scn 1000
RMAN> REPORT SCHEMA AT SEQUENCE 100 THREAD 1; # schema at sequence 100 RMAN> REPORT SCHEMA FOR DB_UNIQUE_NAME standby1;
E: The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter determines the minimum number of days that records are retained in the control file before they are candidates for being overwritten. Thus, you must ensure that you resynchronize the recovery catalog with the control file records before these records are erased.
References: https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmcatdb.htm https://docs.oracle.com/database/121/BRADV/rcmreprt.htm#BRADV90911

QUESTION 187
Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests?

A.    RMAN preauthorization on the host
B.    OSB encryption for data in transport and on tape
C.    matching the OS user identity of the Oracle instance associated with the database username
D.    assigned to a class with rights to back up or restore Oracle database
E.    scheduling of the RMAN backup to occur automatically at user-defined intervals
F.    assigned to a class with rights to browse all directories and catalogs

Answer: ADF
Explanation:
A: Performing Oracle database backups using RMAN requires RMAN user preauthorization within OSB
D: The preauthorized Oracle Secure Backup user must also be assigned to an Oracle Secure Backup class possessing the following rights:
access Oracle backups (set to owner, class, or all)
perform Oracle backups and restores
F: The preauthorized Oracle Secure Backup user must be mapped to operating system privileges to access the files to be backed up or restored. the preauthorized Oracle Secure Backup user can perform RMAN operations only on the host where it has access to files.
References: https://docs.oracle.com/cd/E16926_01/doc.121/e16564/osb_rman_backup.htm#OBADM199

QUESTION 188
Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero value?

A.    The MTTR advisor is enabled only if the value is greater than the default value.
B.    Automatic checkpoint tuning is enabled.
C.    The value of the LOG_CHECKPOINT_INTERVAL parameter overrides the value of the parameter.
FAST_START_MTTR_TARGET
D.    The time taken to recover an instance after a crash is always exactly the same as the value set for the parameter.
FAST_START_MTTR_TARGET

Answer: AC
Explanation:
The FAST_START_MTTR_TARGET initialization parameter lets you specify in seconds the expected “mean time to recover” (MTTR), which is the expected amount of time Oracle takes to perform crash or instance recovery for a single instance.
To enable MTTR advisory, set the initialization parameter FAST_START_MTTR_TARGET to a nonzero value. If FAST_START_MTTR_TARGET is not specified, then MTTR advisory will be OFF.
When specified, FAST_START_MTTR_TARGET is overridden by LOG_CHECKPOINT_INTERVAL.
Note: The default value is 0. Range of values is 0 to 3600 seconds.
References: https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams079.htm#REFRN10058 https://docs.oracle.com/cd/A97630_01/server.920/a96533/instreco.htm

QUESTION 189
You execute the commands to configure settings in RMAN:

1891

Then, you issue the following command to take a backup:

1892

Which statement is true about the execution of these commands?

A.    The backup terminates because the backup destination for disk is not specified in the BACKUP command.
B.    It backs up two copies each of the data files to disk and media, and two copies of archived logs to media.
C.    It backup up the data files and archived logs, making one copy of each data file and archived log on disk and media.
D.    It backs up the data files and archived logs to media, making two copies of each data file and archived logs.

Answer: D

QUESTION 190
You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). RMAN is connected to CDB$ROOT.
Examine the command:

RMAN> LIST FAILURE;

Which statement is true about this command?

A.    It lists failures only for the CDB root database.
B.    It lists failures for a PDB only when RMAN is connected to a recovery catalog.
C.    It lists failures for the CDB and all the PDBs in this CDB.
D.    It lists failures only if RMAN is connected to a PDB.

Answer: A
Explanation:
In the current release, Data Recovery Advisor can only be used to diagnose and repair data corruptions in non-CDBs and the root of a multitenant container database (CDB). Data Recovery Advisor is not supported for pluggable databases (PDBs).
Note: You can run the LIST FAILURE command to show all known failures.
References: https://docs.oracle.com/database/121/BRADV/rcmrepai.htm

1Z0-063 dumps full version (PDF&VCE): https://www.lead2pass.com/1z0-063.html

Large amount of free 1Z0-063 exam questions on Google Drive: https://drive.google.com/open?id=1KOnr3ehUBvZFATrr9N7qE_zU1doGP8Qk