A.  

he SPFILE is copied along with the datafiles of the pluggable databases (PDBs). The root and the seed database in the container database (CDB) are also duplicated.

B.  

A backup of pdb1 and pdb5 must exist before executing the command.

C.  

The duplicate command first creates a backup, and then duplicates the PDBs by using the backup.

D.  

A backup of CDB and pdb1 and pdb5 must exist before executing the command.

E.  

An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRU

E.  

A.  

It requires installation of Oracle Universal Installer.

B.  

It supports Rolling Patching.

C.  

It must be invoked as the user that owns the software being patched.

D.  

It is a Java-based utility for applying patchsets.

E.  

It is platform independent.

F.  

It can be used to apply interim patches to the Grid Infrastructure and Database Home combination.

A.  

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in PDB$SEED.

B.  

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.

C.  

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs).

D.  

System statistics can be gathered only while the CDB is in MOUNT state.

E.  

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/ write mode gathers object statistics for that PDB.

A.  

RMAN uses the pull method to restore files using image copies

B.  

RMAN uses the push method to transfer image copies

C.  

RMAN uses the push method to transfer backup sets

D.  

RMAN uses the pull method to restore files using backup sets

A.  

It is not supported for image copies.

B.  

It is only supported for backups to tape via the media management interface.

C.  

Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.

D.  

Duplex backups can contain only data files and control files.

E.  

For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.

A.  

By default, the transported database will use Oracle Managed Files (OMF)

B.  

Data files can be converted on the destination system.

C.  

Data files can be converted on the source system.

D.  

A new DBID is automatically created for the transported database.

E.  

Databases can be transported between systems with different endian formats.

F.  

The password file is automatically converted by RMAN.

A.  

Space might be reclaimed proactively before space pressure occurs.

B.  

Space is always reclaimed proactively before space pressure occurs.

C.  

Space might be reclaimed automatically when the retention period for Flashback logs is lowered.

D.  

Space is always reclaimed automatically when the retention period for Flashback logs is lowered.

E.  

Space is only reclaimed when there is space pressure in the Fast Recovery Area (FRA).

A.  

The target database must be open

B.  

The duplication process can use existing backup sets or image copies

C.  

The duplication process can use existing backup sets or image copies.

D.  

The target database must be in mount state.

E.  

The duplication -process pushes backup sets to the auxiliary instance.

F.  

The duplication process pushes image copies to the auxiliary instance.

A.  

CDB2 must be in shared UNDO mode only.

B.  

CDB2 must be in archivelog mode.

C.  

CDB1 must be in archivelog mode.

D.  

CDB1 and CDB2 must both be in local UNDO mode.

E.  

CDB1 must be in shared UNDO mode only.A container database, CDB1, contains a pluggable database PDB1.

F.  

CDB1 and CDB2 must be in shared UNDO mode.

A.  

To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace.

B.  

To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database

C.  

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.

D.  

A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first.

E.  

Flashback Data Archive prevents flashback queries from getting a snapshot-too-old error.

A.  

backup retention policy

B.  

default backup device type

C.  

default section size for backups

D.  

default destinations for backups

E.  

multiple backup device types for a single backup

A.  

It succeeds and creates multisection backup sets that are used for active database duplication.

B.  

It fails because there is no connection to a recovery catalog.

C.  

It succeeds only if the target database is in MOUNT state.

D.  

It fails because no parallel channels are allocated for the auxiliary database.

A.  

FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVE D REDO LOG files.

B.  

FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVE D REDO LOG files.

C.  

FLASHBACK TABLE can undrop a column.

D.  

FLASHBACK DROP can undrop an index when undropping a table.

E.  

After a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.

A.  

They can be retained forever.

B.  

They are always created automatically.

C.  

They are always created manually.

D.  

They are generated if STATISTICS LEVEL is set to TYPICAL.

E.  

They are generated if STATISTICS LEVEL is set to BASIC.

F.  

They are generated if STATISTICS LEVEL is set to ALL.

A.  

Tablespaces are automatically created as need while importing full exports in either a non-CDB or a PDB.

B.  

Oracle attempts to convert conventional database users to local users when moving schemas from a non-CDB to a PD

B.  

C.  

A new PDB is automatically created when importing a non-CDB into a CDB.

D.  

Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.

E.  

Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.

F.  

Moving data from a non-CDB to a PDB is only possible by using conventional export and import.

A.  

It cannot be backed up manually as a binary copy.

B.  

It gets backed up automatically by RMAN as a trace file containing SQL statements for control file re¬creation when a database backup occurs.

C.  

It can be backed up manually as a binary copy.

D.  

It can get backed up automatically as a binary copy.

E.  

It gets backed up automatically by RMAN when the BACKUP SPFILE command is used.

F.  

It can be backed up manually as a trace file containing SQL statements for control file recreation.

A.  

After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.

B.  

Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.

C.  

After the change, only one undo tablespace can exist in CDB$ROOT.

D.  

After the change, any user with the required privilege can create an undo tablespace in the PDBs.

E.  

Undo tablespaces existing in PDBs must be dropped before the change.

F.  

After the change, each existing PDB has to be reopened for the new undo mode to take effect.

A.  

They can view data from any data dictionary view or dynamic performance view.

B.  

They can drop any tablespace.

C.  

They can view data from any user-defined tables.

D.  

They can create any table.

E.  

They cannot create restore points.

F.  

They cannot drop tablespaces.

A.  

They can be gathered by the DBMS_STATE package.

B.  

They are ignored by Optimizer if they are state.

C.  

They are gathered by the SQL Tuning Advisor.

D.  

By default, they are automatically gathered by a maintenance job.

E.  

They provide real-time data about schema objects.

A.  

USER1 can connect to CDB1.

B.  

USER1 can connect to APP1_ROOT and APP1_PDB1.

C.  

USER1 can connect to APP1_ROOT, APP1_ROOT$SEED, and APP1_PDB1.

D.  

USER1 is defined in APP1_PDB2. E) USER1 can connect only to APP1_PDB1.

E.  

USER1 can connect only to APP1_ROOT.

A.  

It can be created only by using RMAN.

B.  

It always includes all data files, the current control file, the server parameter file, and archived redo logs.

C.  

It can be consistent.

D.  

It is the only possible backup type for a database in NOARCHIVELOG mode.

E.  

It can consist of either backup sets or image copies.

F.  

It can be inconsistent.

A.  

TheC# # B_ADMIN user can perform all back up and recovery operation susing RMAN only.

B.  

The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.

C.  

The C # # A_ADMIN user can perform wallet operations.

D.  

The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).

E.  

The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.

A.  

The password for the encryption must be set up.

B.  

Oracle wallet for the encryption must be set up.

C.  

All the tablespaces in the database must be encrypted

D.  

Oracle Database Vault must be enabled.

A.  

to allow database duplication without a connection to the target instance.

B.  

to store backup metadata that would cause the controlfile to become too large.

C.  

to store backups that would cause the controlfile to become too large.

D.  

to report on the database schema at an earlier point in time.

E.  

to allow database duplication without a connection to the auxiliary instance.

A.  

It can configure Automatic Storage Management (ASM) diskgroups.

B.  

It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host.

C.  

It can be used to add a new tablespace.

D.  

It can be used to create a database template from an existing database.

E.  

It can generate SQL database creation scripts.

A.  

The CONTAINERS clause cannot be used in queries on the REVENUE table.

B.  

The REVENUE table must be a list-partitioned table.

C.  

The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.

D.  

The MAPTABLE table is a metadata-linked table.

E.  

A container map exists for the REVENUE table, but is not enabled.

F.  

The REVENUE table partitions are not pruned across the PDBs automatically.

A.  

converting an application seed to an application PDB

B.  

converting a regular PDB to an application PDB

C.  

converting an application PDB to an application root

D.  

copying an application container into another application container in the same CDB

E.  

copying an application container into another application container in a different CDB

F.  

converting an application PDB to an application seed G) converting an application PDB to a regular PDB

A.  

CDB1 and CDB2 must be in shared undo mode.

B.  

A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.

C.  

All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.

D.  

Cloning HR_ROOT automatically clones HR_PDB1.

E.  

The HR_PDB1clone created in CDB2 will be in mount state when cloning ends.

A.  

APP1_USER1can be created in PDB1.

B.  

APP1_USER1can be created in CDB1.

C.  

APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.

D.  

C##_APP_USER1 can be created in CDB1.

E.  

P1_USER1can be created in CDB1.

F.  

C##_USER1will have the same privileges and roles granted in all PDBs in CDB1.

A.  

using Database Replay

B.  

using SQL Developer

C.  

using Oracle Data Pump

D.  

using operating system file copy utilities

E.  

using Database Upgrade Assistant

F.  

using the CREATE TABLE AS SELECT SQL statement

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.

A.  

The base catalog owner must give the Virtual Private Catalog access to metadata for one or more PDBs.

B.  

The target PDB must be registered in both the base catalog and the Virtual Private Catalog.

C.  

The base catalog must be used by RMAN when performing point-in-time recovery for the PDB registered in the Virtual Private Catalog.

D.  

The base catalog must be enabled for Virtual Private Catalog use.

E.  

The target PDB must be registered in a Virtual Private Catalog.

F.  

The target PDB must be registered in a base catalog.

A.  

CDB1, PDB$SEED, PDB1, and PDB2

B.  

PDB$SEED, PDB1, and PDB2 only

C.  

CDB1 and PDB$SEED only

D.  

CDB1, PDB1, and PDB2 only

E.  

CDB1, PDB$SEED, and PDB1 only

A.  

It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN or OE_ADMIN role.

B.  

It fails because the command does notspecify when the unified audit policy should be enforced.

C.  

It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.

D.  

It fails because system privileges cannot be granted with roles in the same audit policy.

A.  

1,3,6

B.  

1,2,5

C.  

3,4,5

D.  

2,3,5,6

A.  

The control file is backed up whenever a new tablespace is created.

B.  

The server parameter file (SPFILE) is automatically backed up each time the control file is backed up.

C.  

The control file is backed up whenever a new table is created.

D.  

The control file is backed up whenever an RMAN backup is successfully recorded in the catalog.

E.  

It requires the use of fast recovery area (FRA).

F.  

The control file is backed up automatically each time the SPFILE is backed up manually.

A.  

1,2,4,5,7,8

B.  

1,2,4,6,7,8

C.  

1,2,3,4,5,7,8

D.  

1,2,3,4,5,6,7,8

E.  

2,4,5,6,7

A.  

They are generated if STATISTICS_LEVEL is set to TYPICAL.

B.  

They are always created manually.

C.  

They are always created automatically.

D.  

They are generated if STATISTICS_LEVEL is set to BASIC.

E.  

They are generated if STATISTICS_LEVEL is set to ALL.

F.  

They can be retained forever.

A.  

The statistics_level parameter is set to all when any of the PDBs is reopened.

B.  

The statistics_level parameter is set to all only for PDB2 when it is reopened.

C.  

The statistics_level parameter is set to all when the root database is restarted.

D.  

The statement is ignored because there is no SPFILE for a PDB.

A.  

DataisredactedfortheEMP.SALcolumnonlyiftheSCOTTsessiondoesnothavetheMGR role set.

B.  

DataisredactedforEMP.SALcolumnonlyiftheSCOTTsessionhastheMGRroleset.

C.  

Data is never redacted for the EMP_VW.SAL column.

D.  

Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.

E.  

Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set. Correct

A.  

All historical data older than two years, if any, is purged from the flashback archive FDA1.

B.  

An error is returned because the retention period cannot be reduced.

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.

A.  

It can manage database resources on the server where it is installed or on a different server.

B.  

The CSS daemon runs from the Grid Infrastructure home.

C.  

It supports volume management, file system, and automatic restart capabilities.

D.  

It requires Oracle Automatic Storage Management (ASM) components to be installed separately.

E.  

It must be installed before the Oracle database software is installed.

A.  

Flashback logs are written sequentially, and are archived.

B.  

Flashback Database uses a restored control file to recover a database.

C.  

The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.

D.  

Flashback Database can recover a database to the state that it was in before a reset logs operation.

E.  

Flashback Database can recover a data file that was dropped during the span of time of the flashback.

F.  

Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

A.  

Re-enableredactionpoliciesthatuseFULLdataredaction.

B.  

Re-createredactionpoliciesthatuseFULLdataredaction.

C.  

Re-connect the sessions that access objects with redaction policies defined on them.

D.  

Flushthesharedpool.

E.  

Restart the database instance. Correct

A.  

It recompiles all stored PL/SQL code by using utlrp.sql.

B.  

It empties the RECYCLE BIN.

C.  

It performs prerequisite checks to verify if the Oracle database is ready for upgrade.

D.  

It sets all user tablespaces to “read-only” before starting the upgrade.

E.  

It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles

F.  

It increases tablespace size, if required, to meet upgrade requirements.

A.  

A PDB can be plugged into a CDB only if both are of the same Oracle Database release.

B.  

An unplugged PDB can be plugged into multiple CDBs simultaneously by sharing data files.

C.  

A PDB unplugged from a container database (CDB) can be plugged into a different CDB without altering any of its schemas.

D.  

A non-CDB can be converted into a PDB.

E.  

A PDB in a remote CDB can be accessed transparently thereby aggregating results from local and remote PDBs.

F.  

A PDB created from PDB$SEED must be set to READ WRITE after loading data.

G.  

A PDB created from PDB$SEED must be set to READ ONLY after loading data.

A.  

log writer performance

B.  

database writer performance

C.  

general operating system health

D.  

SQL statements

E.  

database instance memory management and sizes

A.  

the data dictionary in CDB$ROOT

B.  

the log writer process (LGWR)

C.  

SYSAUX tablespaces

D.  

temporary tablespaces

E.  

the Process Monitor Process (PMON)

F.  

undo tablespaces

A.  

It can contain a single application

B.  

Two application containers can share an application seed PD

B.  

C.  

It must have an application root PDB.

D.  

An application PDB can belong to multiple application containers.

E.  

It must have an application seed PDB.

F.  

It can contain multiple applications.

A.  

Stateful alerts must be created by a DBA after resolving the problem.

B.  

Stateless alerts can be purged manually from the alert history.

C.  

Stateless alerts can be cleared manually.

D.  

Stateless alerts are automatically cleared.

E.  

Stateful alerts are purged automatically from the alert history

A.  

It does not require the setup wizard.

B.  

It can be used to install and upgrade Oracle Database for single-instance and cluster configurations.

C.  

It can be used for both Oracle Database and Oracle Grid Infrastructure installation.

D.  

It uses a single RPM that automatically extracts and installs the Oracle Database software.

E.  

It can only install and configure Oracle Database software. The database has to be created separately.

A.  

If the password file location changes, then the new location is used automatically by the Oracle Server.

B.  

Schema Only accounts can be granted administrator privileges.

C.  

All the Oracle-supplied accounts are Schema Only accounts.

D.  

Privilege Analysisisincluded in Oracle Enterprise Edition and no longer requires Database Vault. E) Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.

E.  

Unified Auditing can be configured to audit only events that are issued directly by an audited user.

A.  

It considers the filters in WHERE clauses when generating execution plans for SQL statements.

B.  

It obeys all hints.

C.  

It considers object statistics when generating execution plans for SQL statements.

D.  

It updates stale object statistics in the Data Dictionary.

E.  

It can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated.

F.  

It can re-optimize execution plans after previous executions detect suboptimal plans.

A.  

The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.

B.  

The inserts on USER1.EMP were committed when the session inserted a row into USER2. DEPT.

C.  

The insert on USER2.DEPT fails because of the active transaction in the parent container.

D.  

The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.

E.  

The inserts on USER1.EMP were rolled back when the session connected to PDB2

F.  

The insert on USER2.DEPT is uncommitted.

G.  

The inserts on USER1.EMP were committed when the session connected to PDB2.

A.  

It is used in both clustered and non-clustered environments.

B.  

You can add and remove components from an Oracle Restart configuration with Server Control (SRVCTL) commands.

C.  

It runs from the Oracle Grid Infrastructure home.

D.  

If you shut down a database instance with SQL*Plus, Oracle Restart interprets this as a database failure and attempts to restart the instance.

E.  

The Server Control (SRVCTL) utility can be used to start and stop Oracle Restart.

F.  

It can manage Oracle Database instances, Oracle Net Listeners, and Oracle Automatic Storage Management instances.

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.

A.  

creating a disk group using the CREATE DISKGROUP SQL statement

B.  

creating a database service using DBMS_SERVICE.CREATE_SERVICE

C.  

creating a database service using Oracle Database Configuration Assistant (DBCA)

D.  

creating a database using the CREATE DATABASE SQL statement

E.  

creating an Oracle Database service by modifying the SERVICE_NAMES parameter

F.  

creating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA)

A.  

Using the Data Recovery Advisor LIST FAILURE command always requires that the database for which failures are to be listed is in MOUNT state.

B.  

A failure can be closed only when it has been repaired.

C.  

Data Recovery Advisor can be used if a database is closed.

D.  

The Data Recovery Advisor CHANGE FAILURE command can be used only to change failure priorities.

E.  

Data Recovery Advisor can proactively check for failures.

A.  

It is not possible if an archived log is missing.

B.  

It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.

C.  

Setting FAST_START_MTTR_TARGET to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.

D.  

It is performed by the Recovery Writer (RVWR) background process.

E.  

Setting FAST_START_MTTR_TARGET to a higher value reduces instance recovery time by causing The log writer to write more frquently, thereby reducing the number of I/Os needed during instance recovery.

F.  

It is performed automatically while the database remains in MOUNT state. Then the database is opened.

A.  

Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.

B.  

All tablespaces belonging to a PDB must be duplicated when duplicating the PD

B.  

C.  

The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.

D.  

A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the PDB to duplicate it.

E.  

CDB$ROOT and PDB$SEED are automatically duplicated.

A.  

It has the same common users defined as does CDB1.

B.  

It has only local roles.

C.  

It has the same number of roles as CDB1.

D.  

Service PDB1 is created for remote logins to PDB1.

E.  

It is in mount state after creation.

F.  

It has no local users.

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.

A.  

It is integrated with the SQL Access Advisor.

B.  

It predicts the impact of system changes on SQL workload response time.

C.  

It provides before and after execution statistics for each SQL statement in the analysis task

D.  

It offers fine-grained analysis of all the SQL statements in the analysis task as a group.

E.  

SQL statements that were originally run concurrently are run concurrently by SPA.

A.  

Pre-existing backups of the database to be duplicated are required for the "push" method of duplication.

B.  

Pre-existing backups of the database to be duplicated are required for the "pull" method of duplication.

C.  

Pre-existing backups of the database to be duplicated are always used if they exist.

D.  

Image copies can be used to duplicate the active database.

E.  

The active database must be duplicated while in OPEN state.

F.  

No connection to the recovery catalog is required for active database duplication.

G.  

Backup sets can be used to duplicate the active database.

A.  

PDB1 and PDB2 are in MOUNT state.

B.  

Redo logs are opened.

C.  

PDB1 and PDB2 are in READ ONLY state.

D.  

CDB$ROOT is in MOUNT state.

E.  

PDB$SEED is in READ ONLY state.

A.  

A PDB snapshot is always a full copy of the source PDB.

B.  

A PDB snapshot is always a sparse copy of the source PD

B.  

C.  

A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.

D.  

A PDB snapshot depends on a storage snapshot which can be stored on any file system.

E.  

A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.

F.  

A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.

G.  

A snapshot copy PDB can be created from a stand-alone clone PDB.

A.  

Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.

B.  

Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

C.  

Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.

D.  

Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.

E.  

Re-createthepasswordfileintheOracleDatabase12cformat. Correct

A.  

orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.

B.  

root.sh can be executed automatically by the Database Installer only if it is provided with root credentials.

C.  

The sudo password can be specified in a response file.

D.  

root.sh can be executed automatically by the Database installer only by using sudo credentials.

E.  

The sudo password must be specified in a response file.

F.  

The root password cannot be specified in a response file.

A.  

It can recommend semantic changes to SQL statements.

B.  

It prevents performance regressions for SQL statements when changes are made.

C.  

It checks each query being analyzed for missing or stale statistics.

D.  

It considers all SQL statements being analyzed by the advisor task as a group.

E.  

It only recommends syntactic changes to SQL statements.

A.  

The four sections must be image copies.

B.  

Each of the file sections must be processed serially.

C.  

The four sections must be contained in backup sets.

D.  

The four sections can be created in parallel.

E.  

The four sections can be created serially.

A.  

V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.

B.  

V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.

C.  

V$SESSION_WAIT _CLASS displays waits broken down by wait class only for waiting sessions.

D.  

V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.

E.  

V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.

F.  

V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.

A.  

If an RMAN command fails, the output will only identify the command that failed.

B.  

Some messages in the error stack are not errors.

C.  

If an RMAN command fails, the output will identify the channel ID where the failure occurred. D)Media Management errors appear as a line with "Additional information" and a number.

D.  

Media Management errors appear as a line with "sbtio" and a number.

E.  

Media Management errors appear as a line with "sbtio".

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.

A.  

Decreased use ofstorage to store audit trail rowsin the database.

B.  

It improves overall auditing performance.

C.  

It guarantees zero-loss auditing.

D.  

The audit trail cannot be easily modified because it is read-only.

E.  

It automatically audits Recovery Manager (RMAN) events.

A.  

Updating client scripts with the new Oracle home.

B.  

Resetting passwords to enforce case-sensitivity.

C.  

Run OPatch commands from the new Oracle home.

D.  

Setting threshold values for tablespace alerts.

E.  

Migration to unified auditing.

F.  

Upgrading user tables that depend on Oracle-maintained abstract data types.

A.  

A DBA must specify either a redundancy retention policy or a recovery window retention policy. B)A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.

B.  

Backups older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.

C.  

Backups written to the fast recovery area (FRA) that are obsolete based on the redundancy retention policy can be deleted automatically to free space.

D.  

A target database's persistent RMAN configuration settings are always stored in the target's control file.

A.  

The runfixup.sh script can install missing RPMs.

B.  

The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group

C.  

It allows you to select the languages supported by the Oracle database server.

D.  

It can be done before installing Grid Infrastructure for a Standalone Server

E.  

The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group

F.  

It can be done after installing Grid Infrastructure for a Standalone Server.

G.  

The Oracle database administrator must be granted access to the root operating system account to run root privileged scripts.

A.  

Online Redo Log backups can be created while connected to CDB$ROOT

B.  

Control file backups can be created while connected to CDB$ROOT.

C.  

The BACKUP TABLESPACE command can back up a pDB tablespace even if RMAN is connected to CDB$ROOT.

D.  

Archived Redo Log backups can be created while connected to PDB

E.  

Control file backups can not be created while connected to a PDB

A.  

Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.

B.  

If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then read I/O is a likely bottleneck.F

C.  

If an RMAN BACKUP VALIDATE command takes noticeably less time than an actual backup, then write I/O is a likely bottleneck.

D.  

If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.

E.  

Data files with a high value in V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a potential performance bottleneck when synchronous I/O is used.

A.  

1,3,5, 6, 9

B.  

1,3, 5, 7, 10

C.  

1,2, 5, 7,4, 10

D.  

1,3, 5, 6, 10

E.  

1,3,5, 6, 10

F.  

1,3,5,8, 6, 10

A.  

A media manager always writes RMAN requested backups to tape.

B.  

A media manager is required to create RMAN image copies.

C.  

A media manager is required to create RMAN proxy copies.

D.  

The media manager layer (MML) routines provided by Oracle support any vendors' media management products.

E.  

By default, a request for a proxy copy may result in a backup set being created.

A.  

If a row lock is held by a nonexistent transaction, the block containing the row is media corrupt.

B.  

DB_BLOCK_CHECKING=TRUE causes a check sum to be added to each data block to help detect physical or media corruption.

C.  

A media corrupt block is one where the block is not formatted correctly.

D.  

The ANALYZE TABLE VALIDATE STRUCTURE CASCADE command verifies that each table row has an index entry pointing to it.

E.  

If a row lock is held by a nonexistent transaction, the block containing the row is logically corrupt.

F.  

DB_LOST_WRITE_PROTECT=TYPICAL causes extra logging overhead on the standby database.

A.  

A PDB snapshot depends on an existing storage snapshot of the source PDB.

B.  

APDB snapshot can be a full copy of a source PD

B.  

C.  

A PDB snapshot can be a sparse copy of a source PDB

D.  

A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.

E.  

A snapshot copy PDB can be a full copy of a source PDB

A.  

A non-CDB can be cloned into a PDB.

B.  

A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT when cloning a PD

B.  

C.  

Only one PDB can be cloned at a time.

D.  

Two or more PDBs can be cloned with the same command.

E.  

A user with SYSDBA or SYSBKUP must be logged in with RMAN to the non-CDB being cloned when cloning a non-CDB.

F.  

The target and auxiliary instance passwords must be the same.

A.  

1,3,5,7

B.  

2,5,6

C.  

1,5,6

D.  

3,4,1.6,8

E.  

1,3,5,6,7