[不定项选择题]choose two You take your database backups by using the RMAN

Media management interface (MMI).

Which two are true about the use of

The RMAN MMI?

A.

You can use it to create proxy copies for database files.

B.

You can use it to create proxy copies for entire file systems.

C.

You can use it to create image copies for entire file systems.

D.

You can use it to create image copies for database files.

E. You can use it to create backup sets for database files.

[不定项选择题]Choose two. Your database is in ARCHIVELOG mode and you plan to

Use Flashback Database. Which two features or parameters manage space

Availability in the fast recovery area?

A. the backup retention policy
B. the backup optimization policy
C. the DB_CREATE_ONLINE_LOG_DEST_n parameter setting
D. the archived log deletion policy
E. the DB_RECOVERY_FILE_DEST parameter setting
F. using guaranteed UNDO retention

[不定项选择题]Choose two .You upgrade your database from pre-12c to a multitenant

Container database (CDB) that contains pluggable databases (PDBs).

Examine the query and its output:

SQL> SELECT * FROM v$PWFILE_users;

USERNAME

SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID

---------------------------------------------------------------------

---

SYS

TRUE TRUE

FALSE

FALSE

FALSE

FALSE

0

Which two tasks must you perform to add users with the SYSBACKUP,

SYSDG, and SYSKM prileges to the password file?

A.) Re-create or migrate the password file to the Oracle Database 12c format
B.) Grant the SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
C.) Copy the password file from a sample file in the DBS dierectory
D.) Assign appropriate operating system groups to SYSBACKUP, SYSDG, and
SYSKM.

[不定项选择题]choose two Which two statements are true about encrypted backups

Performed by using RMAN?

A. Transparent encryption of backups uses an encryption wallet.
B. Image copy backups can be created by using password encryption.
C. A password encryption of backups uses the password while creating and
Restoring backups.
D. Encrypted backups can only be written to disk.
E. A database uses the same encryption key for every encrypted backup.

[不定项选择题]Choose two. Which two are prerequisites for using FLASHBACK TABLE?
A. A table's constraints must be disabled before issuing the flashback.
B. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object
Privilege must be granted to the user performing the flashback.
C. Row Movement must be enabled on the table being flashed back.
D. A table's indexes must be set to unusable before issuing the flashback.
E. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object
Privilege must be granted to the table owner.

[不定项选择题]Choose two. Which two restrictions apply when the RMAN BACKUP AS

COPY command is used to create a backup?

A.

Backups can be taken only if a fast recovery area is configured.

B.

Backups can be written only to disk.

C.

Backups can be taken only for data files.

D.

Binary compression cannot be applied to the backup.

E. Backups can be written only if checksums are stored for each block.
F. Backups can be written only to media.

[不定项选择题]Choose two. In which two situations can you use Database Upgrade
Assistant?
A. when a character set conversion is required during the upgrade
B. when multiple pluggable databases in a container database have to be
Upgraded in a specific sequence
C. when the target and source database are on the same platform
D. when the hardware platform needs to be changed as part of the upgrade
E. when the operating system (OS) needs to be changed as part of the upgrade

[不定项选择题]choose two Which two are true about RMAN image copies?
A.

) They can only be written to disk.

B.

) They can be encrypted using Transparent Data Encryption (TDE).

C.

) They can be used as a level 0 incremental backup.

D.

) They can be used as a level 1 incremental backup.

E.) They are the only backup option available for databases in NOARCHIVELOG
Mode.

[不定项选择题]Choose two. Which two are true about Lockdown profiles in a container

Database (CDB) and its pluggable databases (PDBs)?

A. A Lockdown profile created from a base Lockdown profile is always
Automatically modified if the profile on which it is based is modified.
B. A PDB Lockdown profile can be created in an application root.
C. A Lockdown profile created from a base Lockdown profile is never
Automatically modified if the profile on which it is based is modified.
D. A PDB Lockdown profile can be created in a regular PDB.
E. A PDB Lockdown profile can be created in CDB$ROOT .

[不定项选择题]Choose two. Which two are true about poorly performing SQL

Statements and their tuning in Oracle database instances?

A. SQL statements performing many physical I/Os can always have their
Performance improved by creating indexes.
B. The solution that best optimizes one SQL statement can degrade the
Performance of others.
C. SQL statements doing joins always do more physical I/O than single table
Queries.
D. Poorly performing SQL statements can be tuned automatically by the Oracle
Server.
E. SQL statements doing only logical reads never require tuning because they do
No physical I/O.

[不定项选择题]Choose two. Which two are true about various Oracle security and

Auditing capabilities?

A.

Application-common Transparent Security Data Protection (TSDP) policies can

Be created only if all the PDBs in the application container are closed.

B.

Application-common TSDP policies are always container specific.

C.

Application-common OLS policies can be created only if all the PDBs in the

Application container are closed.

D.

Unified auditing can be automatically synchronized to all application PDBs in

An application container.

E. Fine-grained auditing (FGA) policies in an application root are automatically
Synchronized to all application PDBs contained in the application container when
They are updated.

[不定项选择题]Choose two. Which two are true about RMAN duplexed backup sets?
A. They must be written to media.
B. They can be written only to disk.
C. They can be created only by using the COPIES option of a BACKUP command.
D. They can be created by using the RMAN CONFIGURE command to specify
Duplexing before taking a backup.
E. They can be written to media.

[不定项选择题]Choose two. Which two are true about Oracle Database Configuration

Assistant (DBCA)?

A. It can only be launched from the command line interface.
B. It can be launched from both the command line and the Universal Installer
(OUI) interfaces.
C. It can be used to create container databases and non-container databases.
D. It can be used to change the character set of an existing database.
E. It can be used to convert a non-container database to a container database.

[不定项选择题]Choose two. Which two are true about backup set compression using
RMAN default compression?
A. Compressed backups cannot have a section size defined.
B. Compressed backups can be written only to media.
C. Binary compression adds CPU overhead to backup operations.
D. Unused blocks below the high water mark are backed up.
E. Compression can be done only for locally managed tablespaces.

[不定项选择题]Choose two.

Which two statements are true when row-archival management is enabled?

A.

The ORA_ARCHIVE_STATE column may only be queried by users with the DBA

Role set.

B.

The ORA_ARCHIVE_STATE column is only displayed if it is referenced in the

Column select list of a query

C.

The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows.

D.

The ORA_ARCHIVE_STATE column may only be updated by users with the

DBA role set.

E. The ORA_ARCHIVE_STATE column is updated in an overnight maintenance job
Based on activity tracking.

[不定项选择题]Choose two. Which two are true about server-generated alerts?
A.

Stateless alerts can be cleared manually.

B.

Stateless alerts are automatically cleared after one day.

C.

Stateful alerts are purged automatically from the alert history after one day.

D.

Stateless alerts can be purged manually from the alert history.

E.

Stateful alerts must be cleared by a DBA to resolve the problem identified in the alert.

[不定项选择题]Choose two.

Which two are true about unplugging an application container from a

Container database and plugging it into a different container database?

A.

Plugging the application root into a different CDB plugs in all its application

PDBs.

B.

The application root of an application container should be plugged into the

Other CDB before its application PDBs are plugged in.

C.

Application PDBs in the application container must be unplugged before the

Application root is unplugged.

D.

Unplugging the application root from a CDB unplugs all its application PDBs.

E. It requires only local UNDO mode in the database where the application
Container will be unplugged.
F. It requires local UNDO mode in both container databases.

[不定项选择题]Choose two. Which two are true about Rapid Home Provisioning of

Oracle software?

A. It can be used for applications and middleware.
B. It can be used only for Oracle Grid Infrastructure, including Oracle Restart.
C. It can be used for both Oracle Database and Oracle Grid Infrastructure,
Including Oracle Restart.
D. It can be used for both Oracle Database and Oracle Grid Infrastructure,
Excluding Oracle Restart.
E. It can be used only for Oracle Grid Infrastructure, excluding Oracle Restart.

[不定项选择题]Choose two. Which two are true about Optimizer Statistics?
A. They can be gathered by the DBMS_STATS package.
B. They provide real-time data about schema objects.
C. They are gathered by the SQL Tuning Advisor.
D. They are ignored by Optimizer if they are stale.
E. By default, they are automatically gathered by a maintenance job.