Oracle 1Z0-063 Dumps Questions 2021

NEW QUESTION 1
Which three types of backups can be performed for a database running in NOARCHIVELOG mode? (Choose three.)

• A. consistent whole database backup
• B. backup of noncritical tablespaces without shutting down the instance
• C. backup of the database without shutting down the instance
• D. backup of only those blocks that have changed since the last backup while database is mounted
• E. backup of only the used blocks in a critical tablespace (SYSTEM or SYSAUX) while the database isopen

Answer: ACD

NEW QUESTION 2
Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and is affecting undo retention.
Which two actions would you take to solve this problem? (Choose two.)

• A. Enable temporary undo for the database.
• B. Enable undo retention guarantee.
• C. Increase the size of the redo log buffer.
• D. Enable Automatic Memory Management (AMM).
• E. Increase the size of the temporary tablespace.

Answer: AE

NEW QUESTION 3
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.

Answer: BE

NEW QUESTION 4
Which three statements are true about unplugging a pluggable database (PDB)? (Choose three.)

• A. The PDB must be open in read only mode.
• B. The PDB must be dosed.
• C. The unplugged PDB becomes a non-CDB.
• D. The unplugged PDB can be plugged into the same multitenant container database (CDB)
• E. The unplugged PDB can be plugged into another CDB.
• F. The PDB data files are automatically removed from disk.

Answer: BDE

Explanation: B (not A): The PDB must be closed before unplugging it.
D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode information in an endianness-sensitive way. There is no supported way to handle the conversion of such columns automatically. This means, quite simply, that an unplugged PDB cannot be moved across an endianness difference.
E (not F): To exploit the new unplug/plug paradigm for patching the Oracle version most effectively, the source and destination CDBs should share a filesystem so that the PDB’s datafiles can remain in place.

NEW QUESTION 5
Which two statements are true about RMAN duplexed backups? (Choose two.)

• A. It is only supported for backups to tape via media management interface.
• B. It is not supported for image copies.
• C. For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.
• D. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.
• E. Duplex backups can contain only data files and control files.

Answer: BD

NEW QUESTION 6
The HR user updates the salary of one of the employees in the EMPLOYEES table, but does not commit the transaction.
Which type of lock would this scenario lead to?

• A. Exclusive table-level lock on the EMPLOYEES table
• B. Row-exclusive lock on the row being updated
• C. Null lock on the EMPLOYEES table
• D. Null lock on the row being updated

Answer: B

NEW QUESTION 7
Which two statements are true about tablespaces in multitenant container databases (CDBs)? (Choose two.)

• A. Default permanent tablespaces can be shared across pluggable databases (PDBs).
• B. The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.
• C. Each PDB can have its own default temporary tablespace.
• D. The default permanent tablespace for a PDB can be changed only by a local user with the required permissions.
• E. The amount of space that each PDB can use in a shared temporary tablespace must be set at the CDB level.

Answer: BC

NEW QUESTION 8
View the SPFILE parameter settings in the Exhibit.

You issue this command and get errors: SQL> startup
ORA-00824:cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information
Why did the instance fail to start?

• A. because pga_aggregate_target is not set
• B. because statistics_level is set to basic
• C. because memory_target and memory_max_target cannot be equal
• D. because sga_target and memory_target are both set

Answer: B

NEW QUESTION 9
You are performing regular backups of your production database by using a recovery catalog.
You add two new tablespaces to your production database after performing a backup. They must be included in future backups.
Which action should you perform?

• A. Synchronize the recovery catalog with the target database control file.
• B. Create a new database incarnation record.
• C. Add the tablespaces in the recovery catalog by using the CATALOG command.
• D. Synchronize all the physical data files with the logical records in the recovery catalog by using theCROSSCHECK command.

Answer: A

NEW QUESTION 10
A database is running in ARCHIVELOG mode. You want to back up a 10 TB data file belonging to the users tablespace. The backup of the data file is too slow.
What type of backup do you recommend to improve the performance of the backup?

• A. image copy backup by using RMAN
• B. multisection image copy backup by using RMAN
• C. multisection parallel backup by using RMAN
• D. cold backup after taking the tablespace offline
• E. cold backup after placing the tablespace in backup mode

Answer: C

NEW QUESTION 11
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

• A. The ADR base is shared across multiple instances.
• B. The ADR base keeps all diagnostic information in binary format.
• C. The ADR can be used to store statspack snapshots to diagnose database performance issues.
• D. The ADR can be used for problem diagnosis even when the database instance is down.
• E. The ADR is used to store Automatic Workload Repository (AWR) snapshots.

Answer: AD

NEW QUESTION 12
Which two statements are true about making RMAN image copies of a database? (Choose two.)

• A. The can only be written to disk.
• B. The can be made only when the database is running in NOARCHIVELOG mode.
• C. They can be made only when the database is in MOUNT state.
• D. They consist of all used an unused blocks in the data files.
• E. They can be made only when the database is running in ARCHIVELOG mode.

Answer: AD

Explanation: An image copy can be written only to disk.
An image copy is the same as datafiles. The disadvantage of image copy backup mode is that it occupies much space and does not skip unused data blocks.
References:
http://www.dba-oracle.com/t_rman_10_image_copies.htm

NEW QUESTION 13
Examine the backup requirement for your company:
1) Every Sunday, a backup of all used data file blocks is performed.
2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is performed.
3) On all the other days, a backup of only the changed blocks since the last day's backup is performed. Which backup strategy satisfies the requirements?

• A. level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
• B. level 0 backup on Sunday, differential incremental backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
• C. full database backup on Sunday, level 0 backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
• D. full database backup on Sunday, level 0 backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days

Answer: A

NEW QUESTION 14
Your database has a table CUSTOMERS that contains the columns CUST_NAME, AMT_DUE, and OLD_STATUS.
Examine the commands executed and their output:

Why is it that only one update is listed by the Flashback Version Query?

• A. Supplemental logging is not enabled for the database.
• B. The undo data that existed for versions of rows before the change to the table structure is invalidated.
• C. The DB_FLASHBACK_RETENTION_TARGET parameter is set to a lower value and the undo data pertaining to the first transaction is flushed out.
• D. Undo retention guarantee is not enabled.
• E. Flashback Data Archive is full after the first update statement.

Answer: B

NEW QUESTION 15
Your multitenant container database (CDB) CDB1 has two pluggable databases, PDB1 and PDB2. The local net service name CDB1 connects to the root database, and the service names PDB1 and PDB2 connect to the pluggable databases (PDBs), PDB1 and PDB2, respectively.
Examine the commands to change the value of the PDB modifiable initialization parameter:
$> sqlplus sys/oracle_4U@pdb1 AS SYSDBA
SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines=FALSE SCOPE=BOTH; SQL> CONN sys/oracle_4U@pdb2 AS SYSDBA
SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines= TRUE SCOPE = BOTH; SQL> CONN sys/oracle _4U@cdbl AS SYSDBA
SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baseline=TRUE SCOPE=BOTH; Which statement is true about the OPTIMIZER_USE_SQL_PLAN_BASELINES parameter?

• A. It gives an error because it cannot be set for the root database.
• B. It is set to TRUE for the root database and the pluggable database PDB2, because values can be set for this parameter at the PDB level in a PDB.
• C. It is set to TRUE for the root database and all the PDBs, because the value set at the root level has higher precedence.
• D. It is set to TRUE for the root database and all the PDBs, but is effective only when the CDB is restarted and the PDBs are reopened.

Answer: B

NEW QUESTION 16
Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero
value? (Choose two.)

• 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 FAST_START_MTTR_TARGET parameter.
• D. The time taken to recover an instance after a crash is always exactly the same as the value set for the FAST_START_MTTR_TARGET parameter.

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

NEW QUESTION 17
Which two statements are true about dropping a pluggable database (PDB)? (Choose two.)

• A. A PDB must be in mount state or it must be unplugged.
• B. The data files associated with a PDB are automatically removed from disk.
• C. A dropped and unplugged PDB can be plugged back into the same multitenant container database (CDB) or other CDBs.
• D. A PDB must be in closed state.
• E. The backups associated with a PDB are removed.
• F. A PDB must have been opened at least once after creation.

Answer: AD

NEW QUESTION 18
Which two statements are true about roles in multitenant container databases (CDBs)? (Choose two.)

• A. Local roles can be granted to local and common users.
• B. A common role can be granted only to a common user.
• C. A common user can create a local role by default in any pluggable database (PDB) that is plugged in to a CDB.
• D. A common role can be granted only system privileges.
• E. The root container can have both local and common roles.
• F. A local role can be assigned to a common role in a PDB.

Answer: AF

NEW QUESTION 19
Your multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode contains two pluggable databases (PDBs), PDB2_1 and PDB2_2, both of which are open. RMAN is connected to the target pluggable database PDB2_1.
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which statement is true about the execution of this command to back up the database?

• A. All data files belonging to PDB2_1 are backed up and all archive log files are deleted.
• B. All data files belonging to PDB2_1 are backed up along with the archive log files.
• C. Only the data files belonging to pdb2_1 are backed up.
• D. This command gives an error because archive log files can be backed up only when RMAN is connected to the root database.

Answer: B

NEW QUESTION 20
In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20.
Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement? (Choose two.)

• A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used
• B. Setting the target tablespace to read-only after the segments are moved
• C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds T3S percent used
• D. Taking the target tablespace offline after the segments are moved
• E. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used

Answer: BC