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 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 3

After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:
SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE
------------------------- 0
SQL> EXECDBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1)
PL/SQL procedure successfully completed.
SQL> select number_value from redaction_values_for_type_full; NUMBER VALUE
------------------------
-1
After changing the value, you notice that FULL redaction continues to redact numeric data with a zero. What must you do to activate the new default value for numeric full redaction?

• A. Re-enable redaction policies that use FULL data redaction.
• B. Re-create redaction policies that use FULL data redaction.
• C. Re-connect the sessions that access objects with redaction policies defined on them.
• D. Flush the shared pool.
• E. Restart the database instance.

Answer: E

Explanation:
About Altering the Default Full Data Redaction Value
You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value. The modification applies to all of the Data Redaction policies in the current database instance. After you modify a value, you must restart the database for it to take effect.

NEW QUESTION 4

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 5

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 6

Your multitenant container database (CDB) CDB1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:
SQL> STARTUP
Which two statements are true about the successful execution of the command? (Choose two.)

• A. All redo log files are opened.
• B. The root, the seed, and all the PDBs are opened in read-write mode.
• C. All the PDBs are opened in read-write mode.
• D. All the PDBs are in closed state.
• E. Only the root database is opened in read-write mode.

Answer: AE

NEW QUESTION 7

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 8

Examine the initialization parameter that is set in the PFILE:
DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/'
You execute the following command to create CDB1 container database (CDB): SQL>CREATE DATABASE CDB1
DEFAULT TABLESPACE users DEFAULT TEMPORARY TABLESPACE
temp
UNDO TABLESPACE
Undotbsl ENABLE
PLUGGABLE DATABASE SEED
SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED SYSAUX DATAFILES SIZE 100M;
Which three statements are true? (Choose three.)

• A. It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.
• B. The files created for both the root and seed databases use Oracle Managed Files (OMF).
• C. It creates a multitenant container database with the root and seed databases opened and one PDB mounted.
• D. It sets the users tablespace as the default for both the root and seed databases.
• E. undotbs1 is used as the undo tablespace for both the root and seed databases.
• F. It creates a multitenant container database with the root database opened and the seed database mounted.

Answer: ABE

NEW QUESTION 9

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 10

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 11

In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20.
Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement? (Choose two.)

• A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used
• B. Setting the target tablespace to read-only after the segments are moved
• C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds T3S percent used
• D. Taking the target tablespace offline after the segments are moved
• E. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used

Answer: BC

NEW QUESTION 12

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 13

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

NEW QUESTION 14

You are administering a database that supports data warehousing workload and is running in NOARCHIVELOG mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure. You want to recover the data file.
Examine the steps involved in the recovery process:
1. Shut down the database instance.
2. Start up the database instance in NOMOUNT state.
3. Mount the database.
4. Take the data file offline.
5. Put the data file online.
6. Restore the control file.
7. Restore the database.
8. Restore the data file.
9. Open the database with the RESETLOG option.
10. Recover the database with the NOREDO option.
11. Recover the data file with the NOREDO option. Identify the required steps in the correct order.

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

Answer: C

NEW QUESTION 15

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 16

You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter resumable_timeout to 3600. Which two statements are true? (Choose two.)

• A. A resumable statement can be suspended and resumed only once during execution.
• B. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
• C. A suspended statement will report an error if no corrective action has taken place during a timeout period.
• D. Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.
• E. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.

Answer: CD

NEW QUESTION 17

Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? (Choose two.)

• A. Reduced logical I/O
• B. Reduced virtual memory utilization
• C. Improved Serial Execution performance
• D. Reduced physical I/O
• E. Reduced CPU utilization

Answer: BE

NEW QUESTION 18

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 19

While performing database backup to tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive.
Which two actions would you take for tape streaming to happen during the backup? (Choose two.)

• A. Configure backup optimization.
• B. Configure the channel to increase maxopenfiles.
• C. Configure a backup policy by using incremental backups.
• D. Configure the channel to increase capacity with the rate parameter.
• E. Configure the channel to adjust the tape buffer size by using the 3LKSIZE option.
• F. Configure large_pool, if not done alread
• G. Alternatively, you can increase the size of large_pool.

Answer: BE

NEW QUESTION 20

You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES:

Which two statements are true? (Choose two.)

• A. The root and seed databases are included in the duplication.
• B. Only the SALES PDB is duplicated as the non-CDBCDBDUP.
• C. A backup of the SALES PDB must exist before the execution of the command.
• D. An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.
• E. RMAN must be connected to a recovery catalog for the execution of the command.

Answer: AD

Explanation:
D: When duplicating a whole CDB or one more PDBs:
You must create the auxiliary instance as a CDB. To do so, start the instance with the following declaration in the initialization parameter file:
enable_pluggable_database=TRUE
A: To duplicate PDBs, you must create the auxiliary instance as a CDB. To do so, start the instance with the declaration enable_pluggable_database=TRUE in the initialization parameter file. When you duplicate one or more PDBs, RMAN also duplicates the root (CDB$ROOT) and the seed database (PDB$SEED). The resulting duplicate database is a fully functional CDB that contains the root, the seed database, and the duplicated PDBs.
References: https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm

NEW QUESTION 21

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 22

You are administering a multitenant container database (CDB) CDB1 that has multiple pluggable databases (PDBs). As the SYS user on CDB$ROOT, you execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orc1123;
SQL> GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL; SQL> GRANT CREATE USER TO C##ADMIN CONTAINER=ALL;
Which two statements are true about the c##ADMIN user that is created in all PDBs? (Choose two.)

• A. It can create only local users in all the PDBs.
• B. It has a common schema for all the PDBs.
• C. It can create common users only when it is logged in to the CDB.
• D. It can create only local users in the CDB.
• E. It can be granted only common roles in the PDBs.

Answer: AC

NEW QUESTION 23

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 24

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 25

Which three requirements must be met before a tablespace can be transported across different platforms? (Choose three.)

• A. Both the source and target databases must use the same character set.
• B. The platforms of both the source and target databases must have the same endian format.
• C. The COMPATIBLE parameter value must be the same in the source and target databases.
• D. The minimum compatibility level for both the source and target databases must be 10.0.0.
• E. The tablespace to be transported must be in read-only mode.

Answer: ADE

NEW QUESTION 26
......