Verified 1Z0-063 Exam Dumps 2021

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

• A. It fails because archive log files cannot be backed up using a connection to a PDB.
• B. It succeeds but only the data files belonging to the PDB2_1 pluggable database are backed up.
• C. It succeeds and all data files belonging to PDB2_1 are backed up along with the archive log files.
• D. It fails because the PLUGGABLE clause is missing.

Answer: B

NEW QUESTION 2
Your database is running in ARCHIVELOG mode. You use RMAN to take image copies and you update these copies incrementally every six hours. After a regular maintenance task, when you attempt to restart the instance, it halts in MOUNT state with an error indicating that one of the data files belonging to the EXAMPLE tablespace is lost.
You want to recover the data file as quickly as possible while maximizing availability for the database. Examine the possible steps involved in the recovery process:
1. Mount the database.
2. Take the data file offline.
3. Bring the tablespace online.
4. Use the RMAN SWITCH command to switch to the image copy.
5. Recover the tablespace.
6. Open the database.
7. Use the RMAN RESTORE command to switch to the image copy. Identify the correct sequence of the required steps.

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

Answer: B

NEW QUESTION 3
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 4
Your database instance is abnormally terminated because of a power outage. At the next startup, from which point in the redo log does the recovery start?

• A. from the last complete checkpoint position
• B. from the beginning of the current redo log file until the instance failure
• C. from the last committed transaction
• D. from the beginning of the current redo log file to the checkpoint position
• E. from the most recent incremental checkpoint

Answer: E

NEW QUESTION 5
Which three statements are true about the SQL*Loader utility? (Choose three.)

• A. It can be used to load data from multiple external files into multiple tables.
• B. It can be used to extract and reorganize data from external files, and then load it into a table.
• C. It can be used to load data from external files using direct path only.
• D. It can be used to create tables using data that is stored in external files.
• E. It can be used to generate unique sequential values in specified columns while loading data.

Answer: ABE

NEW QUESTION 6
Examine the resources consumed by a database instance whose current Resource Manager plan is displayed. SQL> SELECT name, active_sessions, queue_length,
consumed_cpu_time, cpu_waits, cpu_wait_time FROM v$rsrc_consumer_group;

Which two statements are true? (Choose two.)

• A. An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
• B. An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.
• C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
• D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.
• E. A user belonging to the DSS_QUERIES resource consumer group can create a new session but the session will be queued.

Answer: CE

NEW QUESTION 7
You execute the RMAN commands:
RMAN> BACKUP VALIDATE DATABASE; RMAN> RECOVER CORRUPTION LIST;
Which task is performed by these commands?

• A. Corrupted blocks, if any, are repaired in the backup created.
• B. Only those data files that have corrupted blocks are backed up.
• C. Corrupted blocks in the data files are checked and repaired before performing the database backup.
• D. The database is checked for physically corrupt blocks and any corrupted blocks are repaired.

Answer: D

NEW QUESTION 8
Which four actions are possible during an Online Datafile Move operation? (Choose four.)

• A. Creating and dropping tables in the datafile being moved
• B. Performing file shrink of the data file being moved
• C. Querying tables in the datafile being moved
• D. Performing Block Media Recovery for a data block in the datafile being moved
• E. Flashing back the database
• F. Executing DML statements on objects stored in the datafile being moved

Answer: ACDF

NEW QUESTION 9
You are administering a multitenant container database (CDB) CDB1 with two pluggable databases (PDBs), PDB1 and PDB2. You execute the following commands on CBD$ROOT as the SYS user:
SQL> CREATE USER c##scott IDENTIFIED BY scottorcll; SQL> GRANT CREATE SESSION TO c##scott user?
Which statement is true about the C##SCOTT user?

• A. It is created in all the PDBs with the CREATE SESSION privilege.
• B. It is created in all the PDBs but has the CREATE SESSION privilege only in CDB$ROOT.
• C. It is created and has the CREATE SESSION privilege only in a PDB that is open.
• D. It is created only in CDB$ROOT and has the CREATE SESSION privilege.

Answer: B

NEW QUESTION 10
You create two Resource Manager plans, one for night time workloads, the other for day time. How would you make the plans switch automatically?

• A. Use job classes.
• B. Use scheduler windows.
• C. Use the mapping rule for the consumer groups.
• D. Set the switch_time plan directive for both plans.
• E. Use scheduler schedules.

Answer: B

NEW QUESTION 11
Your database is running in ARCHIVELOG mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is aborted.
Examine the steps to recover the online redo log group and move it to a new location.
1. Restore the corrupted redo log group.
2. Restore the database from the most recent database backup.
3. Perform an incomplete recovery.
4. Relocate the member of the damaged online redo log group to a new location.
5. Open the database with the RESETLOGS option.
6. Issue a checkpoint and clear the log. Identify the required steps in the correct order.

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

Answer: C

NEW QUESTION 12
Examine the following set of RMAN commands:

Which statement is true about the RMAN RUN block execution?

• A. The script is executed and both DC1 and CH1 channels are used for script execution.
• B. The execution of the script fails because multiple channels cannot exist simultaneously.
• C. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.
• D. The new channel, CH1, is ignored because a channel has been configured already.

Answer: C

NEW QUESTION 13
Your database is running in NOARCHIVELOG mode. One of the data files belonging to the SYSTEM tablespace is corrupted. You notice that all online redo logs have been overwritten since the last backup.
Which method would you use to recover the data file?

• A. Shut down the instance if not already shut down, restore all data files belonging to the SYSTEM tablespace from the last backup, and restart the instance.
• B. Shut down the instance if not already shut down, restore the corrupted data file belonging to the SYSTEM tablespace from the last backup, and restart the instance.
• C. Shut down the instance if not already shut down, restore all data files for the entire database from the last backup, and restart the instance.
• D. Mount the database, restore all data files belonging to the SYSTEM tablespace from the last backup, and open the database.

Answer: C

NEW QUESTION 14
You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2 databases both have their instances running.
Which two statements are true? (Choose two.)

• A. Both orcl1 and orcl2 are automatically added to the Oracle Restart configuration.
• B. All database listeners running from the database home are automatically added to the Oracle Restart configuration.
• C. The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restart configuration.
• D. The crsct1 start has command must be used to start software services for Oracle Automatic Storage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation iscomplete.
• E. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.

Answer: CE

Explanation: https://docs.oracle.com/cd/E18283_01/server.112/e17120/restart001.htm

NEW QUESTION 15
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
Examine the steps required to perform the migration:
1. Use Data Pump export to perform a full transportable export on the source database with the export parameter VERSION=12.
2. Place all tablespaces in read-only mode on the source database.
3. Upgrade the source database to Oracle Database 12c.
4. Copy the dump file and data files to the desired location in the target database.
5. Create a new PDB in the target CDB.
6. Synchronize the PDB on the target CDB.
7. Use Data Pump import on the new PDB by using the full transportable import options. Identify the required steps in the correct order.

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

Answer: C

Explanation: This 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:
* (2) Set user tablespaces in the source database to READ ONLY.
* (5) Create a CDB on the destination system, including a PDB into which you will import the source database.
* (1) 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.
* (4) Copy the tablespace data files from the source system to the destination system.
* (7) 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 16
You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years.
You execute the following command to change the requirement:
SQL> ALTER FLASHBACK ARCHIVE fda1 MODIFY RETENSION 2 YEAR;
What is the outcome?

• A. An error is returned because the retention period cannot be reduced.
• B. All historical data older than two years, if any, is purged from the flashback archive FDA1.
• C. All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years.
• D. All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time.

Answer: B

NEW QUESTION 17
Which three statements are true about Oracle Secure Backup (OSB)? (Choose three.)

• A. It can encrypt client data written to tape.
• B. It can be used to take image copy backups to tape.
• C. It can be used to manage tape backup and restore operations for multiple databases.
• D. It can be used along with an RMAN recovery catalog for maintaining records of backups in a tape library.
• E. It can be used to perform file system backups at the file, directory, file system, or raw partition level.

Answer: ACE

NEW QUESTION 18
Examine the RMAN command:

Which statement is true about the command?

• A. It creates compressed backup sets.
• B. It uses asynchronous I/O for the backup.
• C. It uses parallelization for the backup set.
• D. It uses multisection backup.

Answer: C

Explanation: SBT stands for Serial Backup Tape.
Configuring Parallel Channels for Disk and SBT Devices
The number of channels available for a device type when you run a command determines whether RMAN reads or writes in parallel. As a rule, the number of channels used in executing a command should match the number of devices accessed.
For tape backups, allocate one channel for each tape drive.
References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2021), page 5-6