Abreast Of The Times 1Z0-063 Lab 2021

NEW QUESTION 1
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 2

You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1. Place all the user-defined tablespace in read-only mode on the source database.
2. Upgrade the source database to a 12c version.
3. Create a new PDB in the target container database.
4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.
5. Copy the associated data files and export the dump file to the desired location in the target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function. Identify the correct order of the required steps.

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

Answer: C

Explanation:
This example example is a dumpfile-based full transportable export/import operation. In this case the metadata from the source database is exported to a dump file, and both the dump file and the tablespace data files are transferred to a new system. The steps would be as follows:
* (1) Set user tablespaces in the source database to READ ONLY.
* (3) Create a CDB on the destination system, including a PDB into which you will import the source database.
* (4) From the Oracle Database 11g Release 2 (11.2.0.3) environment, export the metadata and any data residing in administrative tablespaces from the source database using the FULL=Y and TRANSPORTABLE=ALWAYS parameters. Note that the VERSION=12 parameter is required only when exporting from an Oracle Database 11g Release 2 database.
* (5) Copy the tablespace data files from the source system to the destination system.
* (6) In the Oracle Database 12c environment, connect to the pre-created PDB and import the dump file.
References:
http://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp-12c-1896123.pdf, page 11

NEW QUESTION 3

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 4

Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (CDB) plan using Oracle Database Resource Manager? (Choose two.)

• A. maximum undo per consumer group
• B. maximum idle time for a session in a PDB
• C. parallel server limit
• D. CPU
• E. maximum number of sessions for a PDB

Answer: CD

NEW QUESTION 5

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 6

You want to export the pluggable database (PDB) HR_PDB1 from the multitenant container database (CDB) CDB1 and import it into the CDB2 CDB as the EMP_PDB1 PDB.
Examine the list of possible steps required to perform the task:
1. Create a PDB named EMP_PDB1.
2. Export the HR_PDB1 PDB by using the FULL clause.
3. Open the EMP_PDB1 PDB.
4. Mount the EMP_PDB1 PDB.
5. Synchronize the EMP_PDB1 PDB in restricted mode.
6. Copy the dump file to the Data Pump directory.
7. Create a Data Pump directory in the EMP_PDB1 PDB.
8. Import data into EMP_PDB1 with the FULL and REMAP clauses.
9. Create the same tablespaces in EMP_PDB1 as in HR_PDB1 for new local user objects. Identify the required steps in the correct order.

• A. 2, 1, 3, 7, 6, and 8
• B. 2, 1, 4, 5, 3, 7, 6, 9, and 8
• C. 2, 1, 3, 7, 6, 9, and 8
• D. 2, 1, 3, 5, 7, 6, and 8

Answer: C

NEW QUESTION 7

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 8

You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:

Which statement is true about the execution of the last command?

• A. It succeeds and displays all the tablespaces that belong to the root database.
• B. It fails and returns an error because a connection is not made by using the SYSDBA privilege.
• C. It succeeds and displays all the tablespaces that belong to the root and pluggable databases.
• D. It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.

Answer: C

NEW QUESTION 9

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 10

Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler? (Choose three.)

• A. A job is specified as part of a program definition.
• B. A program can be used in the definition of multiple jobs.
• C. A program and job can be specified as part of a schedule definition.
• D. A program and schedule can be specified as part of a job definition.
• E. A program and window can be specified as part of a job definition.

Answer: BDE

NEW QUESTION 11

Examine the command to duplicate a database: RMAN> DUPLICATE TARGET DATABASE TO cdb PLUGGABLE DATABASE pdb1, pdb5;
Which two statements are true about the DUPLICATE command? (Choose two.)

• A. The SPFILE is copied along with the data files of the pluggable databases (PDBs).
• B. A backup of pdb1 and pdb5 must exist before executing the command.
• C. The DUPLICATE command first creates a backup, and then duplicates the PDBs by using the backup.
• D. The root and the seed database in the container database (CDB) are also duplicated.
• E. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

Answer: BD

NEW QUESTION 12

Which two statements are true about service creation for pluggable databases (PDBs)? (Choose two.)

• A. When a PDB is created, a service is automatically started in the instance with the same name as the PDB.
• B. The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.
• C. A database managed by Oracle Restart can have additional services created or existing services modified by using the SRVCTL utility for each PDB.
• D. Only a common user can create additional services for a PDB.
• E. When a PDB is created, a service with the same name as the PDB is created in the PDB.

Answer: AC

NEW QUESTION 13

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 14

You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.
Which method or feature should you use?

• A. Database Replay
• B. Automatic Database Diagnostic Monitor (ADDM) Compare Period report
• C. Active Session History (ASH) report
• D. SQL Performance Analyzer

Answer: B

NEW QUESTION 15

Examine the command:

Which statement is true about the execution of the command?

• A. It fails because the log file parameter is not specified.
• B. It fails because no absolute path is specified for the log file and dump file.
• C. It succeeds and exports the full database, simultaneously creating three copies of dump files at three different locations.
• D. It succeeds and exports the full database, simultaneously creating three dump files at three different locations, but the total number of dump files can exceed three.

Answer: D

NEW QUESTION 16

Which three conditions must be met before you create a Virtual Private Catalog (VPC)? (Choose three.)

• A. A base recovery catalog should exist.
• B. The owner of VPC cannot own recovery catalog.
• C. At least one target database should be registered in the recovery catalog.
• D. The register database privilege should be granted to the virtual catalog owner.
• E. The recovery_catalog_owner role should be granted to the virtual catalog owner.

Answer: ADE

NEW QUESTION 17

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 18

Which two are prerequisites for performing Flashback Transaction? (Choose two.)

• A. A supplemental log must be enabled for the primary key.
• B. Undo retention guarantee must be configured for the database.
• C. Fast Recovery Area must be enabled for the database.
• D. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.
• E. Row movement must be enabled.

Answer: AD

NEW QUESTION 19

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 20

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 21

Your database is running in ARCHIVELOG mode. Examine the initialization parameters you plan to set for your database instance.
LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/3rch'
LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch' L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/3rch MANDATORY'
Identify the statement that correctly describes these settings.

• A. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in any of the LOG_ARCHIVE_DEST_.n destinations.
• B. Optional destinations cannot use the fast recovery area.
• C. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in the location specified for LOG_ARCHIVE_DEST_4.
• D. These settings work only if LOG ARCHIVE_MIN_SUCCEED_DEST is set to a value of 4.

Answer: C

NEW QUESTION 22

Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?

• A. configuration of unified auditing mode
• B. execution of SQL statements by users connected with the SYSDBA privilege
• C. usage of the AUDIT statement
• D. creation of a fine grained audit policy

Answer: C

NEW QUESTION 23

Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN:
1. Create media families for data files and archived redo log files.
2. Configure database backup storage selectors or RMAN media management parameters.
3. Create an OSB user preauthorized for RMAN operations.
4. Configure RMAN Access to the OSB SBT.
5. Disable Non-Uniform Memory Access (NUMA) awareness by setting the ob_ignore_numa parameter to 0. Identify the steps in the correct order.

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

Answer: C

NEW QUESTION 24

Examine the RMAN commands executed in your database: RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET; RKAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
You issue the command:
RMAN> BACKUP DATABASE;
Which two statements are true about the command? (Choose two.)

• A. It performs a log switch.
• B. It creates compressed backup sets by using binary compression by default.
• C. It backs up only the used blocks in data files.
• D. It backs up data files, the control file, and the server parameter file.
• E. It creates a backup of only the control file whenever the database undergoes a structural change.

Answer: CD

NEW QUESTION 25

The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to
/u01/app/oracle/product/12.1.0/db 1.
You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database.
NAME TYPE VALUE
---------------- ------------------- -------------------
audit_file_dest string /u01/app/oracle/admin/eml2rep/adump background_dump_dest string
core_dump_dest string db_create_file_dest string
db_recovery_file_dest string /u01/app/oracle/fast_recovery_area diagnostic_dest string
What is the location of the ADR base?

• A. It is set to /u01/app/oracle/product:/12.1.0/db_1/log.
• B. It is set to /u01/app/oracle/admin/enl2r&p/adump.
• C. It is set to /u01/app/oracle.
• D. It is set to /u01/app/oracle/flash_recovery_area.

Answer: C

NEW QUESTION 26

You are administering a multitenant container database (CDB) that contains two pluggable databases (PDBs), PDB1 and PDB2. You are connected to PDB2 as a common user with DBA privileges.
The STATISTICS_LEVEL parameter is PDB modifiable. As the user SYS, execute the following command on PDB2:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;
Which statement is true about the result of this command?

• A. The STATISTICS_LEVEL parameter is set to ALL when any of the PDBs is reopened.
• B. The STATISTICS_LEVEL parameter is set to ALL only for PDB2 when it is reopened.
• C. The STATISTICS_LEVEL parameter is set to ALL when the root database is restarted.
• D. The statement is ignored because there is no SPFILE for a PDB.

Answer: B

NEW QUESTION 27
......