Free 1Z0-063 Exam Dumps

Question 46

- (Exam Topic 2)
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)? (Choose three.)

A. ADBA can check specific tables with the DMU
B. The database to be migrated must be opened read-only.
C. The release of the database to be converted can be any release since 9.2.0.8.
D. The DMU can report columns that are too long in the converted characterset
E. The DMU can report columns that are not represented in the converted characterset

Correct Answer:ADE
A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps of the migration process.
D: Exceed column limit
The cell data will not fit into a column after conversion. E: Need conversion
The cell data needs to be converted, because its binary representation in the target character set is different than the representation in the current character set, but neither length limit issues nor invalid representation issues have been found.

Question 47

- (Exam Topic 2)
In which three situations must you use a recovery catalog? (Choose three.)

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 CONTROL_FILE_RECORD_KEEP_TIME parameter

Correct Answer:ADE
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 48

- (Exam Topic 1)
While performing database backup to tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive.
Which two actions would you take for tape streaming to happen during the backup? (Choose two.)

A. Configure backup optimization.
B. Configure the channel to increase maxopenfiles.
C. Configure a backup policy by using incremental backups.
D. Configure the channel to increase capacity with the rate parameter.
E. Configure the channel to adjust the tape buffer size by using the 3LKSIZE option.
F. Configure large_pool, if not done alread
G. Alternatively, you can increase the size of large_pool.

Correct Answer:BE

Question 49

- (Exam Topic 2)
You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys user. You execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orcll23; SQL> CREATE ROLE C##CONNECT;
SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT; SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL;
Which statement is true about the c##connect role?

A. It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.
B. It is granted to the c##admin user only in the CDB.
C. It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.
D. It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.

Correct Answer:D

Question 50

- (Exam Topic 1)
You are administering a multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode and contains pluggable databases (PDBs), PDB_1 and PDB_2.
While opening PDB_1, you get an error: SQL> alter pluggable database pdb_1 open;
ORA-01157: cannot identify/lock data file 11-see DBWR trace file
ORA-01110: data file 11: '/u01/app/oracle/oradata/cdb1/pcb_1/example01.dbf'
To repair the failure, you open an RMAN session for the target database CDB$ROOT. You execute the following as the first command:
RMAN> REPAIR FAILURE;
Which statement describes the consequence of the command?

A. The command performs the recovery and closes the failure.
B. The command produces an error because RMAN is not connected to the target database PDB_1.
C. The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command.
D. The command executes successfully, performs recovery, and opens PDB_1.

Correct Answer:C