Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: cramtreat

1z0-083 Oracle Database Administration II Questions and Answers

Questions 4

Which three are true about opatch auto? (Choose three.)

Options:

A.

It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.

B.

It must be invoked by a user with root user privileges.

C.

Patches are applied via opatchauto.

D.

Users must always input patch plans to opatchauto.

E.

It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.

F.

It applies patches in nonrolling mode by default.

G.

It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

Buy Now
Questions 5

Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)

Options:

A.

A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.

B.

The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.

C.

An existing Oracle base can be used.

D.

The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.

E.

Existing Oracle Database instances must be shut down before starting the upgrade.

F.

Only the grid user can perform the upgrade.

Buy Now
Questions 6

Choose two. Which two are true about a Recovery Manager (RMAN) duplication without a TARGET connection?

Options:

A.

The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

B.

RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

C.

The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

D.

The UNDO TABLESPACE clause is never required.

E.

RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.

Buy Now
Questions 7

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?

Options:

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.

Buy Now
Questions 8

Which two are true about Oracle instance recovery? (Choose three.)

Options:

A.

Recovery begins from the beginning of the CURRENT redo log group.

B.

Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.

C.

Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.

D.

Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the datanase is opened.

E.

Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).

F.

Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.

Buy Now
Questions 9

A database is configured in ARCHIVE LOG mode. A full RMAN backup exists but no control file backup to trace has been taken. A media failure has occurred. In which two scenarios is incomplete recovery required? (Choose two.)

Options:

A.

after losing a SYSAUX tablespace data file

B.

after losing all members of an INACTIVE online redo log group

C.

after losing all members of the CURRENT online redo log group

D.

after losing all copies of the control file

E.

after losing an UNDO tablespace that is in use

Buy Now
Questions 10

Choose three. Which three are true about cloning databases into an existing CDB with RMAN?

Options:

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 PDB.

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.

Buy Now
Questions 11

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

Options:

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.

Buy Now
Questions 12

You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command. Which two statements are true about the dependent objects of the CUSTOMERS table?

Options:

A.

All the triggers associated with the table are flashed back but are disabled.

B.

Materialized views that use the CUSTOMERS table are flashed back.

C.

LOB segments associated with the CUSTOMERS table are flashed back.

D.

All the constraints defined on the table, except the referential integrity constraints, are flashed back.

E.

Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.

Buy Now
Questions 13

Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

Options:

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.

Buy Now
Questions 14

choose two Examine these RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M; Which two statements are true about the DUPLICATE command?

Options:

A.

It succeeds.

B.

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

C.

It fails because connection to the AUXILIARY instance must be as SYSDBA.

D.

Itsucceeds only if the target database is greater than 400M.

E.

No catalogued backup of the TARGET is used to duplicate the database.

Buy Now
Questions 15

Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)

Options:

A.

Flashback logs are automatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.

B.

Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.

C.

Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.

D.

Flashback logs are monitored for being older than the retention period defined in DB_FLASHBACK_RETENTION_TARGET and can be deleted by an administrator written event trigger.

E.

Flashback logs are automatically purged whenever the value of DB_FLASHBACK_RETENTION_TARGET is changed.

Buy Now
Questions 16

Which three are true about Automatic Workload Repository (AWR) snapshots?

Options:

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.

Buy Now
Questions 17

Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

Options:

A.

Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance.

B.

A connection to an auxiliary instance is always required.

C.

A subset of the target database can be duplicated.

D.

A new DBID is always created for the duplicated database.

E.

A connection to the recovery catalog instance is always required.

F.

A backup of the target database is always required.

G.

Duplication can be done by having the target database instance push copies to the auxiliary database instance.

Buy Now
Questions 18

Choose three. Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN?

Options:

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.

Buy Now
Questions 19

A container database (CDB) contains two pluggable databases PDB1 and PDB2. The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB. Data file 24 of PDB2 was deleted and you need to restore and recover it. The only RMAN backup that exists was created with the BACKUP DATABASE command while connected to CDB$ROOT. Which three are true? (Choose three.)

Options:

A.

Data file 24 can be recovered only while connected to PDB2.

B.

Data file 24 can be restored and recovered while connected to CDB$ROOT.

C.

Data file 24 can be restored only while connected to CDB$ROOT.

D.

Data file 24 can be restored only while connected to PDB2.

E.

Data file 24 can be recovered while connected to PDB2.

F.

Data file 24 can be recovered while connected to CDB$ROOT.

Buy Now
Questions 20

Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?

Options:

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.

Buy Now
Questions 21

Which three are true about Automatic Workload Repository (AWR) snapshots?

Options:

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.

Buy Now
Questions 22

Choose three. Which three are true about SGA memory management in a multitenant database?

Options:

A.

SGA_MIN_SIZE cannot be set for a PDB.

B.

Setting SHARED_POOL_SIZE for a PDB guarantees a minimum amount of Shared Pool memory for that PDB.

C.

Setting SGA_TARGET for a PDB guarantees a minimum amount of SGA memory for that PDB.

D.

The SHARED_POOL_SIZE setting for a PDB can be up to 80% of the SHARED_POOL_SIZE setting of the root container.

E.

Setting DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database Buffer Cache memory for that PDB.

F.

The SGA_TARGET setting for a PDB cannot exceed 50% of the SGA_TARGET value of the root container.

Buy Now
Questions 23

Examine the command to duplicate a database: RMAN> DUPLICATE TARGET DATABASE TO cdb PLUGGABLE DATABASE pdb1, pdb5; Which two statements are true about the DUPLICATE command?

Options:

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 TRUE.

Buy Now
Questions 24

choose three Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).

Options:

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.

Buy Now
Questions 25

Choose three. Which three actions are mandatory post database upgrade?

Options:

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.

Buy Now
Questions 26

RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database: RMAN> DUPLICATE TARGET DATABASE TO dup1 FROM ACTIVE DATABASE NOFILENAMECHECK PASSWORD FILE SPFILE; Which two statements are true about the execution of the duplicate command?

Options:

A.

All archive redo log files are automatically copied to the duplicate database.

B.

The duplicate database has the same directory structure as the source database.

C.

The duplicate database is created by using the backups created during the execution of

D.

he duplicate command.

E.

The password file and SPFILE for the duplicate database dup1 are created in their respective default locations.

F.

The duplicate database is created without using RMAN backups and prod1 is allowed to remain open during duplication.

Buy Now
Questions 27

Choose two. RMAN has just been connected to a target database and the recovery catalog database. In which two cases would an automatic full resynchronization occur between this target database's control file and the RMAN recovery catalog?

Options:

A.

when control file metadata for archive log backups or image copies has been overwritten in the target database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME

B.

when a new tablespace is added to a registered target database

C.

when a backup of the current control file is created

D.

when control file metadata for data file backups or image copies has been overwritten in the target database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME

E.

when the target is first registered

Buy Now
Questions 28

Automatic Shared Memory Management is disabled for one of your database instances. Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance. What would be your next step?

Options:

A.

Run the SQL Access Advisor.

B.

Run the Memory Advisor for the shared pool.

C.

Run the SQL Tunning Advisor.

D.

Run the Memory Advisor for the Program Global Area.

E.

Run the Memory Advisor for the System Global Area.

Buy Now
Questions 29

Choose three. The HR_ROOT application container must support the execution of a query on a table shared by application local PDBs PDB1 and PDB2, and remote PDB PDB3. Which three are true?

Options:

A.

A proxy PDB must exist in the application root in the local CDB.

B.

PDB3's application root replica must exist in the local CDB.

C.

The HR_ROOT replica must exist in the remote CDB.

D.

A database link must exist in the remote CDB referring to the local CDB.

E.

A proxy PDB must exist in the application root in the remote CDB.

F.

A database link must exist in the local CDB root referring to the remoteCDB.

Buy Now
Questions 30

Choose three. Which three are true about recovery operations done without using Recovery Manager (RMAN)?

Options:

A.

A lost PFILE can be re-created from alert.log using SQL*PLUS.

B.

A lost index tablespace can be re-created without performing any recovery.

C.

A lost password file can be manually re-created with the orapwd utility.

D.

A lost password file can be re-created with SQL*PLUS.

E.

A lost SPFILE can be recovered from memory using SQL*PLUS.

F.

A lost TEMPFILE must always be re-created manually.

Buy Now
Questions 31

Choose two. You are managing this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are two pluggable databases in CDB1. 3. USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2 . CDB1 user SYS executes these commands after connecting successfully to PDB2: SQL> ALTER SESSION SET CONTAINER=pdb1; Session altered. SQL> INSERT INTO user1.emp VALUES (100, 'Alan' ,1) ; 1 row created. SQL> INSERT INTO user1.emp VALUES (101, 'Ben' ,1) ; 1 row created. SQL> ALTER SESSION SET CONTAINER=pdb2; Session altered. SQL> INSERT INTO user2.dept VALUES(1, 'IT'); Which two are true? Which two are true? (Choose two.)

Options:

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.

Buy Now
Questions 32

Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

Options:

A.

Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be started and the databased be in the MOUNT state.

B.

Backing up a database in ARCHIVE LOG mode using O/S utilities requires that the database instance be started and the database be in MOUNT state.

C.

An Oracle database can be restored from backup files copied using O/S utilities.

D.

Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.

E.

Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.

F.

Oracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.

G.

Backing up a database in ARCHIVE LOG mode using O/S utilities requires that the database instance be started and the database be in OPEN state.

Buy Now
Questions 33

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?

Options:

A.

Compare Period ADDM report

B.

AWR Compare Period report

C.

Active Session History (ASH) report

D.

Taking a new snapshot and comparing it with a preserved snapshot.

Buy Now
Questions 34

Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.)

Options:

A.

It is used to change failure priority only for HIGH or LOW priorities.

B.

It is used to execute the advised repair script.

C.

It is used to change failure priority only for the CRITICAL priority.

D.

It is used to explicitly close the open failures.

E.

It is used to inform the database about the repair after the repair script executes.

Buy Now
Questions 35

Which two are true about the Oracle database methodology? (Choose two.)

Options:

A.

The Oracle Database time model should be used to find the database and instance areas most in need of tuning.

B.

Tuning activities should stop once the user is satisfied with performance.

C.

Tuning activities should stop once agreed service levels for performance have been met.

D.

The database instance memory should always be tuned before tuning any file systems.

E.

SQL statements should always be tuned before tuning any file systems.

F.

The alert log should be used to find the database and instance areas most in need of tuning.

Buy Now
Questions 36

Choose three. Which are the three steps in the SQL tuning process for Oracle Database environments?

Options:

A.

Tune individual SQL statements using the SQL Tuning Advisor.

B.

Identify poorly tuned SQL statements using Automatic Database Diagnostic Monitor.

C.

Test the application as a whole using tuned SQL statements.

D.

Test tuned SQL statements one at a time for all statements in the application.

E.

Identify poorly tuned SQL statements using the SQL Tuning Advisor.

F.

Tune SQL statements as a group using the SQL Tuning and SQL Access Advisors.

Buy Now
Questions 37

Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)

Options:

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 PDB.

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.

Buy Now
Questions 38

Examine the statements that use flashback technologies:

FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYYMM¬DD HH:MI:SS');

SELECT * FROM customers AS OF SCN 123456;

FLASHBACK TABLE customers TO BEFORE DROP;

FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');

SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;

ALTER TABLE customers FLASHBACK ARCHIVE; Which set ofstatements depends on the availability of relevant undo data in the undo tablespace?

Options:

A.

1,3,6

B.

1,2,5

C.

3,4,5

D.

2,3,5,6

Buy Now
Questions 39

choose one You take regular backups of one of your production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which must be included in future backups. Which process occurs which allows the new backups to contain the new datafiles?

Options:

A.

The target database control file is synchronized from the recovery catalog with a partial resync at the next backup.

B.

The recovery catalog is synchronized from the target database control file with a full resync at the next backup.

C.

The target database control file is synchronized from the recovery catalog with a full resync at the next backup.

D.

The recovery catalog is synchronized from the target database control file with a partial resync at the next backup.

Buy Now
Questions 40

Which two are true about Oracle Flashback features? (Choose two.)

Options:

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.

Buy Now
Questions 41

Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

Options:

A.

It analyzes a period of time corresponding to the 12 hours of activity.

B.

It runs automatically after each AWR snapshot.

C.

A DBA can run it manually.

D.

Results are written to the alert log.

E.

It analyzes a period of time corresponding to the last day of activity.

Buy Now
Questions 42

Choose two. A database is configured in ARCHIVELOG mode. A full RMAN backup exists but no control file backup to trace has been taken. A media failure has occurred. In which two scenarios is incomplete recovery required?

Options:

A.

after losing all members of the CURRENT online redo log group

B.

after losing all copies of the control file

C.

after losing an UNDO tablespace that is in use

D.

after losing all members of an INACTIVE online redo log group

E.

after losing a SYSAUX tablespace data file

Buy Now
Questions 43

Which three are located by using environment variables?

Options:

A.

the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.

B.

the location of Oracle Net Services configuration files

C.

the list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup

D.

default directories for temporary files used by temporary tablespaces

E.

the temporary disk space used by Oracle Installer during installation

F.

the maximum number of database files that can be opened by a database instance

Buy Now
Questions 44

Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog. You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host. How would you achieve this?

Options:

A.

by using the RMAN switch command to set the new location for the data files

B.

by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host

C.

by using the RMAN duplicate command with dbid and set new name for tablespace to recover the database to the new host

D.

by creating a new database in the new host, and then using the RMAN recover command

Buy Now
Questions 45

Choose two. Which two are true about backup set compression using RMAN default compression?

Options:

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.

Buy Now
Questions 46

Choose the best answer. SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases. Which action could help in the performance management of these regressed SQL statements?

Options:

A.

Create SQL plan directives for each of the regressed statements.

B.

Use The SQL Tuning Advisor for each of the regressed statements.

C.

Create an adaptive execution plan for each of the regressed statements

D.

Use the SQL Access Advisor for each of the regressed statements.

Buy Now
Questions 47

Choose three. Which three are true about backing up the control file?

Options:

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.

Buy Now
Questions 48

Choose the best answer. On the 10th of August, you implement an incremental database backup strategy and configure a recovery window of five days. Level 0 backups are taken on the 10th, 17th, and 24th of August. Differential level 1 incremental backups are taken daily between the level 0 backups. Today is the 26th of August. Which backups will be obsolete?

Options:

A.

all backups prior to 10th of August

B.

all backups prior to 22nd of August

C.

all backups prior to 20th of August

D.

all backups prior to 24th of August

E.

all backups prior to 17th of August

Buy Now
Questions 49

The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode. Which two are true about using RMAN to perform an open database back up of this tablespace? (Choose two.)

Options:

A.

Backups must be done incrementally.

B.

Backups must be contained in backup sets.

C.

Backups can be taken only if the database is in ARCHIVE LOG mode.

D.

Backups can be done incrementally.

E.

The database must be registered in an RMAN catalog.

F.

Only consistent backups can be created.

Buy Now
Questions 50

Choose two. Which two restrictions apply when the RMAN BACKUP AS COPY command is used to create a backup?

Options:

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.

Buy Now
Questions 51

A database is configured in ARCHIVE LOG mode. Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred. In which two scenarios is complete recovery possible? (Choose two.)

Options:

A.

when any archived log from, before, or after the most recent backup is corrupt.

B.

after losing all copies of the control file

C.

after losing an archived log from after the most recent backup

D.

after losing an archived log from before the most recent backup

E.

after losing the SYSTEM tablespace

Buy Now
Questions 52

Choose three. Which three are true about Data Pump in an Oracle multitenant environment?

Options:

A.

It can be used to transport data from a non-CDB to a PDB.

B.

It can be used to clone a CDB.

C.

It can be used to transport data between PDBs.

D.

It can be used to transport data from a PDB to a non-CDB.

E.

It can be used to create a new PDB.

Buy Now
Questions 53

Choose two. Which two are true about the automatic execution of operating system scripts when performing silent mode installation starting from Oracle Database 19c?

Options:

A.

The response file can specify the path of the sudo program.

B.

The response file must contain the root or sudo password.

C.

Silent install always runs operating scripts automatically.

D.

The response file can specify the root or sudo password.

E.

The installer will prompt for the root or sudo password.

Buy Now
Questions 54

Choose two. Which two are true about RMAN duplexed backup sets?

Options:

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.

Buy Now
Questions 55

choose two You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA. Which two files are removed automatically if space is required in the FRA as per the retention policy?

Options:

A.

user-managed backups of data files and control files

B.

flashback logs

C.

RMAN backups that are obsolete

D.

archived redo log files that have multiple copies in a different archive location

Buy Now
Questions 56

Choose two. Which two are true about backup encryption?

Options:

A.

The Transparent Data Encryption (TDE) keystore is backed up using RMAN.

B.

Vendor-specific media management software can be used for making encrypted RMAN backups to media.

C.

The BACKUP BACKUPSET command can encrypt and decrypt backup sets.

D.

Image copies can be encrypted.

E.

Keystore-based encryption is the default mode for RMAN backup encryption.

F.

Backup encryption can be enabled selectively for specific tablespaces.

Buy Now
Questions 57

Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)

Options:

A.

The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.

B.

Oracle DBCA templates can store only logical structure and not database files.

C.

New templates can only be created by modifying an existing user-created template.

D.

The Data Warehouse template is most suitable when transaction response time is the key criterion.

E.

Oracle DBCA templates can be used to create new databases and duplicate existing databases.

Buy Now
Questions 58

You must transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write. The source and destination platforms have different endian formats.

Examine this list of actions:

1. Make the UNIVERSITY tablespace read-only on the source system.

2. Export the UNIVERSITY tablespace metadata using EXPDP.

3. Convert the UNIVERSITY tablespace data fies to the destination platform format using RMAN on the source system.

4. Copy the UNIVERSITY tablespace data files to the destination system.

5. Copy the Data Pump dump set to the destination system.

6. Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.

7. Import the UNIVERSITY tablespace metadata using IMPDP.

8. Make the UNIVERSITY tablespace read/write on the destination system.

Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

Options:

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

Buy Now
Questions 59

Identify three scenarios in which RMAN will use backup sets to perform active database duplication.

Options:

A.

when the duplicate ... from active database command contains the section size clause

B.

when you perform active database duplication on a database with flashback disabled

C.

when you specify set encryption before the duplicate ... from active database command

D.

when the number of auxiliary channels allocated is equal to or greater than the number of target channels

E.

when you perform active database duplication on a database that has readonly tablespaces

Buy Now
Questions 60

Choose three. Which three are true about the Oracle Optimizer?

Options:

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.

Buy Now
Questions 61

Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2. 2. PDB$SEED is open READ ONLY 3. PDB1 is open READ WRITE 4. PDB2 is MOUNTED. 5. ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1. You execute these commands before upgrading the database to the current release: For which databases will fixup scripts be created?

Options:

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

Buy Now
Questions 62

choose three Which three are true about RMAN duplexed backup sets or image copies?

Options:

A.

A backup set may be duplexed with both copies written to disk.

B.

An image copy on disk can be copied to disk.

C.

A backup set may be duplexed with both copies written to sbt.

D.

A backup set may be duplexed so that one copy is written to sbt and the other to disk.

E.

An image copy on disk can be copied to sbt.

F.

An image copy on sbt can be copied to disk.

Buy Now
Questions 63

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?

Options:

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

Buy Now
Questions 64

Choose the best answer. Which operating system group is NOT needed to perform an Oracle Database installation?

Options:

A.

OSASM

B.

OSRACDBA

C.

OSKMDBA

D.

OSDBA

E)OSOPER

Buy Now
Questions 65

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

Options:

A.

If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

B.

In a PDB plan, subplans may be used with up to eight consumer groups.

C.

If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.

D.

If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

E.

If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Buy Now
Questions 66

Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)

Options:

A.

It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.

B.

It is always possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.

C.

A Virtual Private Catalog used to register a container database must be created in a pluggable database.

D.

A Virtual Private Catalog used to register a container database can be created in a pluggable database.

E.

It is always possible for RMAN to connect to a pluggable database as a target.

F.

A Virtual Private Catalog used to register a container database can be created in a non-container database.

Buy Now
Questions 67

Which three are true about an application seed pluggable database (PDB)? (Choose three.)

Options:

A.

It is automatically synchronized with its application root PDB when an application is upgraded. B)It cannot be added to an application container after the application container has already been created.

B.

A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.

C.

It is automatically synchronized with its application root PDB when an application is installed.

D.

It cannot be dropped from its application container.

E.

A new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes.

F.

It is not required in an application container.

Buy Now
Questions 68

Choose three. Which three are true about corrupted data blocks and their recovery in an Oracle Database?

Options:

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.

Buy Now
Questions 69

Choose two. Which two are true about an Oracle gold image-based installation in Oracle 18c and later releases?

Options:

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.

Buy Now
Questions 70

Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES APP application. Examine these steps:

Install the SALES_APP application, induding the common tables, in the application root.

Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root.

Create an application seed.

Install the SALES_APP application in the application seed.

Create the SALES_APP1 and SALES_APP2 application PDBs.

Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.

Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.

Sync the application seed with the application root. Which are the minimum required steps in the correct sequence?

Options:

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

Buy Now
Questions 71

Choose two. Your SALES_ROOT application container has two application PDBs. The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs. Examine this query and its output: SELECT containers_default, container_map, table_name FROM dba_tables WHERE owner='FIN' ; CONTAINERS_DEFAULT CONTAINER_MAP CONTAINER_MAP_OBJECT TABLE_NAME -------------------------------------------------------------------------------------------------------------------------------NO YES NO REVENUE NO NO YES MAPTABLE Which two are true?

Options:

A.

The REVENUE table must be a list-partitioned table.

B.

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

C.

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

D.

The REVENUE table must be a composite-partitioned table.

E.

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

Buy Now
Questions 72

Which three are true about managing memory components in an Oracle database instance? (Choose three.)

Options:

A.

With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.

B.

With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.

C.

Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.

D.

Automatic Memory Management must be used together with locking the System Global Area into physical memory.

E.

With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.

F.

On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

Buy Now
Questions 73

Choose three. Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege?

Options:

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.

Buy Now
Questions 74

Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1. You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT. Which two are always true? (Choose two.)

Options:

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.

Buy Now
Questions 75

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)

Options:

A.

ADDM can recommend shrinking the buffer cache.

B.

ADDM can recommend extending the buffer cache.

C.

By default, MMON creates an AWR snapshot every 30 minutes.

D.

ADDM performs its analysis only when a DBA requests it.

E.

By default, AWR snapshots are automatically purged after eight days.

F.

AWR snapshots must be deleted when no longer required by ADDM.

Buy Now
Questions 76

Choose the best answer You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog. You create an auxiliary instance and want to execute the command: RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE; What is a prerequisite for the successful execution of this command

Options:

A.

RMAN must be connected to the target database instance and the auxiliary instance.

B.

A most recent backup set of the PROD database must exist.

C.

Flashback must be enabled for the PROD database.

D.

The target database must be in MOUNT state.

Buy Now
Questions 77

Choose two. Which two are true about a read-only Oracle home?

Options:

A.

It is enabled by performing a software-only Oracle Database installation and then running the roohctl ¬enable script.

B.

It requires the Rapid Home Provisioning service.

C.

Its configuration data and log files reside in subdirectories under the Oracle home.

D.

It is enabled by performing an Oracle Database installation with database creation and then running the roohctl -enable script.

E.

It contains an image that can be distributed across multiple servers.

Buy Now
Questions 78

Choose three. Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases?

Options:

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.

Buy Now
Questions 79

Choose the best answer. How do you configure a CDB for local undo mode?

Options:

A.

Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and then restart the CDB instance.

B.

Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.

C.

Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.

D.

Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON. create an UNDO tablespace in each PDB, and then restart the CDB instance.

E.

Open the CDB in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.

Buy Now
Questions 80

choose two Which two are true about RMAN image copies?

Options:

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.

Buy Now
Questions 81

Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)

Options:

A.

Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.

B.

The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected to a PDB.

C.

SPFILE backups can be created while connected to an application root PDB.

D.

The BACKUP DATABASE PLUS ARCHIVE LOG command will back up archive logs when RMAN is connected to a PDB.

E.

The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT.

Buy Now
Questions 82

Choose two. Which two are true about Oracle Grid Infrastructure for a Standalone Server?

Options:

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.

Buy Now
Questions 83

1.Which two are prerequisites for creating a backup-based duplicate database?

Options:

A.

connecting to the target database and a recovery catalog to execute the duplicate command

B.

creating a password file for an auxiliary instance

C.

connecting to an auxiliary instance

D.

matching the database identifier (DBID) of the source database and the duplicate database

E.

creating an SPFILE for the target database

Buy Now
Questions 84

Choose two. Which two are true about RMAN backups when using a media manager?

Options:

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.

Buy Now
Questions 85

Which two are true about RMAN encryption? (Choose two.)

Options:

A.

RMAN encryption keys are stored in a database keystore.

B.

RMAN can encrypt the Oracle Database password file.

C.

Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.

D.

The SET ENCRYPTION command overrides encryption settings specified by the CONFIGURE ENCRYPTION command.

E.

Password encryption can be persistently configured using the CONFIGURE ENCRYPTION command.

Buy Now
Exam Code: 1z0-083
Exam Name: Oracle Database Administration II
Last Update: Jun 15, 2025
Questions: 286
1z0-083 pdf

1z0-083 PDF

$29.75  $84.99
1z0-083 Engine

1z0-083 Testing Engine

$35  $99.99
1z0-083 PDF + Engine

1z0-083 PDF + Testing Engine

$47.25  $134.99