Oracle 1Z0-063 Exam Questions 2021

NEW QUESTION 1
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 2
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 3
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 4
You need to perform a block media recovery on the tools01.dbf data file in your database by using Recovery Manager (RMAN).
Which two are prerequisites for performing this operation? (Choose two.)

• A. You must configure a block change tracking file.
• B. You must use an incremental level-1 backup to restore blocks.
• C. You must ensure that the database is mounted or open.
• D. You must have full or level-0 backups to restore blocks.
• E. You must take the tools01.dbf data file offline.

Answer: CD

Explanation: The target database must run in ARCHIVELOG mode and be open or mounted with a current control file. The backups of the data files containing the corrupt blocks must be full or level 0 backups. They cannot be
proxy copies or incremental backups.
References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2021), page 19-4

NEW QUESTION 5
You execute the command to recover your database:

Which statement is true?

• A. It restores all data files from the specified time, and then applies the redo logs.
• B. It restores all data files, redo log files, and control files, and then applies the redo logs up to the specified time.
• C. It restores all data files and control files from the most recent backup taken before the “until time”, and then recovers up to the “until time” using any restored archive logs that are needed to complete the task.
• D. It restores the control file and all data files from the most recent backups, and then applies the redo logs up to the “until time”.

Answer: C

Explanation: UNTIL TIME = 'date_string' specifies a time as an upper limit. RMAN selects only files that can be used to restore and recover up to but not including the specified time.
RMAN can perform recovery of the whole database to a specified past time, SCN, or log sequence number. This type of recovery is sometimes called incomplete recovery because it does not completely use all of the available redo. Incomplete recovery of the whole database is also called database point-in-time recovery (DBPITR).
DBPITR requires restoring your database from an older backup, then performing media recovery until your specified target time, SCN or log sequence number. Note that because you need your archived redo log files to perform this process, you cannot perform database point-in-time recovery if you have been running your database in NOARCHIVELOG mode.
References: https://docs.oracle.com/cd/B13789_01/server.101/b10734/rcmrecov.htm

NEW QUESTION 6
In a database supporting an OLTP workload, tables are frequently updated on both key and non-key columns. Reports are also generated by joining multiple tables.
Which table organization or type would provide the best performance for this hybrid workload?

• A. heap table with a primary key index
• B. external table
• C. hash clustered table
• D. global temporary table
• E. index clustered table

Answer: E

NEW QUESTION 7
You created a database with DBCA by using one of the Oracle supplied templates. Which is the default permanent tablespace for all users except DBSNMP and OUTLN?

• A. USERS
• B. SYSTEM
• C. SYSAUX
• D. EXAMPLE

Answer: B

NEW QUESTION 8
Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests? (Choose three.)

• A. RMAN preauthorization on the host
• B. OSB encryption for data in transport and on tape
• C. matching the OS user identity of the Oracle instance associated with the database username
• D. assigned to a class with rights to back up or restore Oracle database
• E. scheduling of the RMAN backup to occur automatically at user-defined intervals
• F. assigned to a class with rights to browse all directories and catalogs

Answer: ADF

Explanation: A: Performing Oracle database backups using RMAN requires RMAN user preauthorization within OSBD: The preauthorized Oracle Secure Backup user must also be assigned to an Oracle Secure Backup class
possessing the following rights:
access Oracle backups (set to owner, class, or all) perform Oracle backups and restores
F: The preauthorized Oracle Secure Backup user must be mapped to operating system privileges to access the files to be backed up or restored. the preauthorized Oracle Secure Backup user can perform RMAN operations only on the host where it has access to files.
References: https://docs.oracle.com/cd/E16926_01/doc.121/e16564/osb_rman_backup.htm#OBADM199

NEW QUESTION 9
Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

• A. Oracle Data Pump
• B. Oracle Recovery Manager (RMAN)
• C. Oracle Label Security
• D. Oracle Database Vault
• E. Oracle Real Application Security

Answer: B

NEW QUESTION 10
Examine the statements that use flashback technologies:
1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP (‘2013-02-04 09:30:00’, ‘YYYY-MM-DD HH:MI:SS’);
2. SELECT * FROM customers AS OF SCN 123456;
3. FLASHBACK TABLE customers TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP (‘2013-02-04 09:30:00’, ‘YYYY-MM-DD HH:MI:SS’);
5. SELECT * FROM customers VERSIONS BETWEEM SCN 123456 AND 123999;
6. ALTER TABLE customer FLASHBACK ARCHIVE;
Which set of statements depends on the availability of relevant undo data in the undo tablespace?

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

Answer: A

NEW QUESTION 11
Examine the command used to perform an incremental level-0 backup: RMAN> BACKUP INCREMENTAL LEVEL0 DATABASE;
To enable block change tracking, after the incremental level 0 backup, you issue the command: SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING
FILE'/mydir/rman_change_track.f';
To perform an incremental level-1 cumulative backup, you issue the command: RMAN> BACKUP INCREMENTAL LEVEL1 CUMULATIVE DATABASE;
Which two statements are true in the preceding situation? (Choose two.)

• A. The block change tracking data is used only from the next incremental backup.
• B. The incremental level 1 backup fails because a block change tracking file is created after the level 0 backup.
• C. The incremental level 1 backup does not use change tracking data for accomplishing the backup.
• D. The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup.
• E. The block change tracking data is used for the next incremental level 1 backup only after the next level 0 backup.

Answer: CE

NEW QUESTION 12
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 13
You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance.
How can you detect the cause of the degraded performance?

• A. Enable Memory Access Mode, which reads performance data from SGA.
• B. Use emergency monitoring to fetch data directly from SGA for analysis.
• C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
• D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring.
• E. Run ADDM in diagnostic mode.

Answer: B

NEW QUESTION 14
As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database.
Which step should you perform next to start the upgrade of the database?

• A. Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files during the upgrade.
• B. Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.
• C. Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.
• D. Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.

Answer: B

NEW QUESTION 15
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 16
In the SPFILE, UNDO TABLESPACE is Set to UNDOTBS.
You rename the undotbs undo tablespace:
ALTER TABLESPACE undotbs RENAME TO undotbs_old; Which statement is true?

• A. The tablespace will be renamed but the data file headers will not be updated.
• B. The statement will fail because you cannot rename an undo tablespace.
• C. The tablespace will be renamed and all the changes will be logged in the alert log.
• D. The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter.
• E. You must set the undo_tablespace parameter to some other tablespace name before renaming undotbs.

Answer: C

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 three statements are true about persistent lightweight jobs? (Choose three.)

• A. A user cannot set privileges on them.
• B. They generate large amounts of metadata.
• C. They may be created as fully self-contained jobs.
• D. They must reference an existing Scheduler Program.
• E. They are useful when users need to create a large number of jobs quickly.

Answer: ADE