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
You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost.
Examine the steps required to recover the database:
1. Restore an autobackup of the server parameter file.
2. Restore the control file.
3. Start up the database instance in NOMOUNT state.
4. Mount the database.
5. Restore the data files.
6. Open the database with the RESETLOGS option.
7. Recover the data files.
8. Set DBID for the database.
Identify the required steps in the correct order.

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

Answer: B

NEW QUESTION 3
You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX-based Oracle 12c database:
CONNECT /AS SYSDBA
ALTER SYSTEM SET THREADED_EXECUTION=TRUE SCOPE=SPFILE; SHUTDOWN IMMEDIATE
You then restart the instance and get an error: STARTUP
ORA-01031: insufficient privileges
Why does the startup command return the error shown?

• A. because the threaded architecture requires exiting from sql*plus and reconnecting with sql*Plus / as sysdba before issuing a startup command
• B. because the threaded architecture requires issuing a new connect / as sysdba from within sql*plus before issuing a startup command
• C. because the threaded architecture requires authentication using a password file before issuing a startup command
• D. because the threaded architecture requires connecting to the instance via a listener before issuing a startup command
• E. because the threaded architecture requires restarting the listener before issuing a startup command

Answer: C

NEW QUESTION 4
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 5
Which three statements are true about the keystore storage framework for transparent data encryption? (Choose three.)

• A. It facilitates and helps to enforce keystore backup requirements.
• B. It handles encrypted data without modifying applications.
• C. It enables a keystore to be stored only in a file on a file system.
• D. It enables separation of duties between the database administrator and the security administrator.
• E. It transparently decrypts data for the database users and applications that access this data.
• F. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.

Answer: ADF

NEW QUESTION 6
Which three statements are true about Oracle Restart? (Choose three.)

• A. It can be configured to automatically attempt to restart various components after a hardware or software failure.
• B. While starting any components, it automatically attempts to start all dependencies first and in proper order.
• C. It can be configured to automatically restart a database in case of normal shutdown of the database instance.
• D. It can be used to only start Oracle components.
• E. It runs periodic check operations to monitor the health of Oracle components.

Answer: ABE

NEW QUESTION 7
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 8
View the Exhibit showing steps to create a database resource manager plan. SQL>execute dbms_resource_manager.create_pendingarea();
PL/SQL procedure successfully completed.
SQL>exec dbms_resource_manager, create_consumergroup (consumer_group=>’OLTP,,comment=>,onlineuser’)
PL/SQL procedure successfully completed.
SQL>exec bras resource_manager.create plan(plan=>’PRIU3ER3',comment=>'dssprio’); SQL>exec
Dbms_resource_manager.create_plan_directive(plan=>’PRIU3ER3’,group_or_subplan=>'OLTP’,comment=>'o PL/3QLproceduresuccessfullycompleted.
After executing the steps in the exhibit you execute this procedure, which results in an error: SQL> EXECUTE dbms_resource_manager. validate_pending_area ();
What is the reason for the error?

• A. The pending area is automatically submitted when creating plan directives.
• B. The procedure must be executed before creating any plan directive.
• C. The sys_group group is not included in the resource plan.
• D. The other_groups group is not included in the resource plan.
• E. Pending areas can not be validated until submitted.

Answer: D

NEW QUESTION 9
LDAP_DIRECTORY_SYSAUTH is set to YES.
Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory (OID). SSL has been configured for the database and OID and the password file has been configured for the database. User scott with sysdba privilege tries to connect remotely using this command:
$sqlplusscott/tiger@DB0l As sysdba where DB01 is the net service name. Which authentication method will be attempted first?

• A. authentication by password file
• B. authentication by using certificates over SSL
• C. authentication by using the Oracle Internet Directory
• D. authentication by using the local OS of the database server

Answer: A

NEW QUESTION 10
You must unload data from the orders, order_items, and products database tables to four files using the External Tables.
CREATE TABLE orders_ext
(order_id, order_date, product_id, product_name,quantity) ORGANIZATION EXTERNAL
(
TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY ext.dir
LOCATION (‘ordersl.dmp','orders2.dmp’,’orders3.dmp’,’lorders4.dmp')
) PARALLEL AS
SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity FROM orders o,productsp,order_items
WHERE o.orderid = i.order_id and i.product_id = p.product_id;
You execute the command shown in the Exhibit, but only two files are created. Which parameter must be changed so that four files are created?

• A. TYPE
• B. LOCATION
• C. PARALLEL
• D. DEFAULT DIRECTORY
• E. ORGANIZATION EXTERNAL

Answer: C

NEW QUESTION 11
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 12
You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want to ensure the following:

• A. Long-running queries are not affected.i
• B. No extra space is used.ii
• C. Data manipulation language (DML) operations on the table succeed at all times throughout the process.i
• D. Unused space is reclaimed both above and below the high water mar
• E. Which alter TABLE option would you recommend?
• F. DEALLOCATE UNUSED
• G. SHRINK SPACE CASCADE
• H. SHRINK SPACE COMPACT
• I. ROW STORE COMPRESS BASIC

Answer: C

NEW QUESTION 13
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 14
Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.)

• A. You cannot export data from a remote database.
• B. You can rename tables during import.
• C. You can overwrite existing dump files during export.
• D. You can compress data but not metadata during export.

Answer: BC

NEW QUESTION 15
Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup? (Choose two.)

• A. Tables or table partitions can be recovered by using an auxiliary instance only.
• B. Tables or table partitions with a foreign key cannot be recovered.
• C. Tables or table partitions can be recovered only when the database is in MOUNT state.
• D. Tables or table partitions from the SYSTEM and SYSAUX tablespaces cannot be recovered.
• E. Tables with NOT NULL constraints cannot be recovered.

Answer: AD

NEW QUESTION 16
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 17
You are connected to a pluggable database (PDB) as a common user with the SYSDBA privilege. The PDB is open and you issue the SHUTDOWN IMMEDIATE command.
What is the outcome?

• A. The PDB is closed.
• B. The PDB is placed in mount state.
• C. The command executes only if the common user is granted the SET CONTAINER privilege for the PDB.
• D. The command results in an error because the PDB can be shut down only by a local user.

Answer: B

NEW QUESTION 18
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 19
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