Oracle 1Z0-063 Exam Questions 2021

NEW QUESTION 1
You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog.
You create an auxiliary instance and want to execute the command:

What is a prerequisite for the successful execution of this command?

• A. The target database must be in MOUNT state.
• B. RMAN must be connected to the target database instance and the auxiliary instance.
• C. A most recent backup set of the PROD database must exist.
• D. Flashback must be enabled for the PROD database.

Answer: B

Explanation: Assume that the source database prod is on host1 and stores its data files in a non-ASM file system. The control files for prod are located in /oracle/oradata/prod/.
You want to duplicate the source database to database dupdb on remote host host2. You want to store the duplicate database files in ASM disk group +DISK1.
After connecting RMAN to the target, duplicate, and recovery catalog databases, run the following RMAN script to duplicate the database.
DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE
SPFILE
PARAMETER_VALUE_CONVERT '/oracle/oradata/prod/', '+DISK1' SET DB_CREATE_FILE_DEST +DISK1;
When the DUPLICATE command completes, the duplicate database is created, with data files, online redo log files, and control files in ASM disk group +DISK1.
References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2021), page 26-7

NEW QUESTION 2
Your database is running in ARCHIVELOG mode and flashback is enabled.
In which scenario must you use RMAN backups for recovering tables and table partitions?

• A. when recovering a table to a point in time
• B. when recovering a table that has been logically corrupted
• C. when recovering dropped tables that are present in the recyclebin
• D. when recovering the data of a table to the desired point in time, which is more recent that the oldest available undo
• E. when recovering data that was lost after a DDL operation modified the structure of a table

Answer: A

NEW QUESTION 3
In your database, the user SCOTT wants to retrieve the dropped HR.EMPLOYEES table by using the command:
SQL> FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP;
What are three prerequisites for this command to succeed? (Choose three.)

• A. Undo retention guarantee must be enabled.
• B. No other table with the same name should exist in the HR schema.
• C. SCOTT should have the FLASHBACK ANY TABLE privilege.
• D. SCOTT should have the SELECT privilege on the HR schema and its recyclebin.
• E. No duplicates of the HR.EMPLOYEES table should exist in the recyclebin of the HR schema.
• F. The recycle bin should be enabled.

Answer: BCF

NEW QUESTION 4
Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? (Choose two.)

• A. If no PDB plan is enabled for a pluggable database, all sessions for that PDB are treated to an equal share of resources.
• B. To enable a resource plan for a PDB, a CDB resource plan must be created and enabled.
• C. If a PDB plan is enabled for a pluggable database, Resource Manager uses the resource allocation at the PDB level and ignores the limits set at the CDB level.
• D. If no PDB plan is enabled for a pluggable database, the PDB uses the CDB plan.
• E. If a PDB plan is enabled for a pluggable database, resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Answer: AE

Explanation: A: ACDB resource plan determines the amount of resources allocated to each PDB. A PDB resource plan determines how the resources allocated to a specific PDB are allocated to consumer groups within that PDB.
Resource Manager allocates the resources in two steps:
E: A PDB resource plan allocates resource among the consumer groups within a PDB. References: https://docs.oracle.com/database/121/ADMIN/cdb_dbrm.htm

NEW QUESTION 5
Which three statements are true about a job chain? (Choose three.)

• A. It can contain a nested chain of jobs.
• B. It can be used to implement dependency-based scheduling.
• C. It cannot invoke the same program or nested chain in multiple steps in the chain.
• D. It cannot have more than one dependency.
• E. It can be executed using event-based or time-based schedules.

Answer: ABE

NEW QUESTION 6
You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs.
How can you detect the cause of the degraded performance?

• A. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis
• B. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots
• C. by using Active Session History (ASH) data and performing hang analysis
• D. by running ADDM in diagnostic mode

Answer: A

NEW QUESTION 7
You have a production Oracle 12c database running on a host.
You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.
The steps in random order:
1. Create directory structures similar to the production database on all new machines.
2. Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.
3. Create a database clone template for the database.
4. Run the Database Configuration Assistant (DBCA) to create the database.
5. Run OUI in graphical mode on each machine.
6. Run OUI in silent mode using the OUI response file.
Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.

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

Answer: D

NEW QUESTION 8
Your database is running in archivelog mode. Examine the parameters for your database instance: LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY'
LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 ='LOCATIO=/disk3/arch' LOG_ARCHIVE_DEST _4 ='LOCATIONs/disk4/arch' LOG_ARCHIVE _MIN_SUCCEED_DEST = 2
While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used.
What happens at the next log switch?

• A. The database instance hangs and the redo log files are not overwritten.
• B. The archived redo log files are written to the fast recovery area until the mandatory destination is made available.
• C. The database instance is shutdown immediately.
• D. The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

Answer: D

NEW QUESTION 9
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

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

NEW QUESTION 10
Which parameter must be set to which value to implement automatic PGA memory management?

• A. Set memory_target to zero.
• B. Set STATISTICS_LEVEL to BASIC.
• C. Set pga_aggregate_target to a nonzero value.
• D. Set pga_aggregate_target and sga_target to the same value.
• E. Set sgajtarget to zero.

Answer: C

NEW QUESTION 11
You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC? (Choose three.)

• A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.
• B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
• C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
• D. Database files stored in ZFS and accessed using conventional NFS mounts.
• E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature
• F. Database files stored in any file system and accessed using the Oracle Direct NFS feature
• G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

Answer: AEG

Explanation: HCC requires the use of Oracle Storage – Exadata (A), Pillar Axiom (G) or Sun ZFS Storage Appliance (ZFSSA).
Note:
* Hybrid Columnar Compression, initially only available on Exadata, has been extended to support Pillar Axiom and Sun ZFS Storage Appliance (ZFSSA) storage when used with Oracle Database Enterprise Edition
11.2.1.3 and above
* Oracle offers the ability to manage NFS using a feature called Oracle Direct NFS (dNFS). Oracle Direct NFS implements NFS V3 protocol within the Oracle database kernel itself. Oracle Direct NFS client overcomes many of the challenges associated with using NFS with the Oracle Database with simple configuration, better performance than traditional NFS clients, and offers consistent configuration across platforms.

NEW QUESTION 12
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

NEW QUESTION 13
Examine the command and its output: SQL> DROP TABLE EMPLOYEE;
SQL> SELECT object_name AS recycle_name, original_name, type
FROM recyclebin; RECYCLE_NAMEORIGINAL_NAMETYPE
binsgk31sj/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLE You then successfully execute the command:
SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP;
Which two statements are true? (Choose two.)

• A. It flashes back the employee table and all the constraints associated with the table.
• B. It automatically flashes back all the indexes on the employees table.
• C. It automatically flashes back any triggers defined on the table.
• D. It flashes back only the structure of the table and not the data.
• E. It flashes back the data from the recycle bin and the existing data in the original table is permanently lost.

Answer: AC

NEW QUESTION 14
Examine the parameters for your database instance: NAME TYPE VALUE
------------------------------------------------
optimizer_adaptive_reporting_only boolean FALSE optimizer_capture_sql_plan_baselines boolean FALSE optimizer_dynamic_sampling integer 2
optimizer_features_enable string 12.1.0.1
Which three statements are true about the process of automatic optimization by using statistics feedback? (Choose three.)

• A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
• B. The optimizer can re optimize a query only once using cardinality feedback.
• C. The optimizer enables monitoring for cardinality feedback after the first execution of a query.
• D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
• E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

Answer: ACE

NEW QUESTION 15
Examine the command to back up the ASM metadata: ASMCMD>md_backup /backup/ASM_backup
In which three situations can you use the backup? (Choose three.)

• A. when one or more disks in an ASM disk group are lost
• B. when the data file on an ASM disk group gets corrupted
• C. when one of the disks in a disk group is accidentally unplugged
• D. when one or more file directory paths are accidentally deleted from an ASM disk group
• E. when all the ASM disk groups for the ASM instance are lost

Answer: ADE

NEW QUESTION 16
Which two statements are true about encrypted backups performed by using RMAN? (Choose two.)

• A. Transparent encryption of backups uses an encryption wallet.
• B. A database uses the same encryption key for every encrypted backup.
• C. A password encryption of backups uses the password while creating and restoring backups.
• D. Image copy backups can be created by using password encryption.
• E. Encrypted backups can only be written to disk.

Answer: AC

NEW QUESTION 17
Examine the command:
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required? (Choose two.)

• A. The current online redo log file is missing.
• B. A data file belonging to a noncritical tablespace is missing.
• C. All the control files are missing.
• D. The control file backup is older than the database backup.
• E. All the data files are missing.

Answer: CD

NEW QUESTION 18
Which three statements are true about Flashback Data Archive? (Choose three.)

• A. Flashback Data Archive prevents flashback queries from getting a snapshot-too-old error.
• B. A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first.
• C. To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database.
• D. While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the default Flashback Data Archive.
• E. To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace.

Answer: BCD

NEW QUESTION 19
Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)? (Choose three.)

• A. A PDB opened in restricted mode allows only local users to connect.
• B. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.
• C. When a CDB is in MOUNT state, PDBs are automatically placed in MOUNT state.
• D. All PDBs must be shut down before shutting down a CDB instance.
• E. When a CDB instance is started, PDBs can be placed in OPEN state by using database triggers or by executing the ALTER PLUGGABLE DATABASE command.

Answer: BCE

NEW QUESTION 20
Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). (Choose three.)

• A. to store backup information of multiple databases in one place
• B. to restrict the amount of space that is used by backups
• C. to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause
• D. to store RMAN scripts that are available to any RMAN client that can connect to target databases registered in the recovery catalog
• E. to automatically delete obsolete backups after a specified period of time

Answer: ACD