Summer Special Flat 65% Limited Time Discount offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

Oracle 1z0-083 Oracle Database Administration II Exam Practice Test

Page: 1 / 29
Total 286 questions

Oracle Database Administration II Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$42  $119.99

PDF Study Guide

  • Product Type: PDF Study Guide
$36.75  $104.99
Question 1

Choose three. Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant?

Options:

A.

Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.

B.

After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new ORACLE_HOME.

C.

Time zone files must be upgraded manually using the DBMS_DST PL/SQL package.

D.

The new extended data type capability must be enabled by running the utlrp.sql script

E.

The Oracle Application Express configuration should be updated after upgrading Oracle Database.

Question 2

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

Options:

A.

Control file backups can be created while connected to the root container.

B.

Archived Redo Log backups can be created while connected to an application root CDB.

C.

Control file backups can be created while connected to a nonroot container.

D.

Online Redo Log backups can be created while connected to the root container.

E.

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

Question 3

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

Question 4

A redaction policy was added to the SAL column of the SCOTT.EMP table: BEGIN DBMS_REDACT.ADD_POLICY( object_schema object_name column_name policy_name function_type expression => 'SCOTT', => 'EMP', => 'SAL', => 'SCOTT_EMP', => DBMS_REDACT.FULL, => 'SYS_CONTEXT(''SYS_SESSION_ROLES'',''MGR'') END; All users have their default set of system privileges. For which three situations will data not be redacted?

Options:

A.

SYSsessions,regardlessoftherolesthataresetinthesession

B.

SYSTEMsessions,regardlessoftherolesthataresetinthesession

C.

SCOTT sessions, only if the MGR role is set in the session

D.

SCOTT sessions, only if the MGR role is granted to SCOTT

E.

SCOTTsessions,becauseheistheownerofthetable

F.

SYSTEM session, only if the MGR role is set in the session

Question 5

You plan to create a database by using the Database Configuration Assistant (DBCA), with t he following specifications: Applications will connect to the database via a middle tier. The number of concurrent user connections will be high. The database will have mixed workload, with t he execution of complex BI queries scheduled at night. Which DBCA option must you choose to create the database?

Options:

A.

a General Purpose database template with default memory allocation

B.

a Data Warehouse database template, with t he dedicated server mode option and AMM enabled

C.

a General Purpose database template, with t he shared server mode option and Automatic Memory Management (AMM) enabled

D.

a default database configuration

Question 6

In one of your databases, unified auditing is enabled and an SH.SALES table exists. You successfully execute these commands: SQL> CREATE AUDIT POLICY sales_pol ACTIONS select on sh.sales; SQL> AUDIT POLICY sales_pol; Which statement is true about SALES_POL?

Options:

A.

It is enabled for all users having SELECT privilege on SH.SALES.

B.

Only successful queries of SH.SALES are written to the audit trail.

C.

It is only enabled for user SH.

D.

Audit records are always stored in an external audit file.

Question 7

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.

Question 8

Choose two. Which two are true about gathering optimizer statistics?

Options:

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.

Question 9

Choose three. You must migrate a non-CDB Oracle 11g Database to a CDB without first performing an upgrade to the non-CDB. User-defined objects are stored in several tablespaces in the non-CDB. Which three methods can you use?

Options:

A.

Data Pump full database export and import

B.

cloning the non-CDB as a PDB

C.

replication using GoldenGate

D.

Data Pump transportable tablespaces

E.

Data Pump full transportable database

F.

the DBMS_PDB package

Question 10

Choose two. Examine this command: $ rhpctl move database -sourcehome Oracle_home_path ¬destinationhome Oracle_home_path For which two purposes can you use this command?

Options:

A.

to switch to a patched Oracle Database home

B.

to upgrade an Oracle Database on the centralized Rapid Home Provisioning server

C.

to move an Oracle Database to the centralized Rapid Home Provisioning server

D.

to switch back to the previous Oracle home as part of a rollback operation

E.

to switch to a read-only Oracle home

Question 11

Examine the command for creating pluggable database PDB2 in container database CDB2. Select three options, any one of which is required for it to execute successfully. (Choose three.)

Options:

A.

Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.

B.

Add only the CREATE_FILE_DEST clause to the statement.

C.

Set only the PDB_FILE_NAME_CONVERT parameter.

D.

Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.

E.

Enable only OMF.

F.

Add the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF)

Question 12

Choose three. Which three are true about a container database (CDB)?

Options:

A.

It can be created from a non-CDB.

B.

It can contain only one PDB$SEED, which is created when the CDB is created.

C.

It can have local users with the same name in different PDBs.

D.

It can contain only one Application Container seed, which is created when the Application Container is created.

E.

It can be created by cloning an existing CDB.

F.

It can have any number of pluggable databases (PDBs) limited only by space availability.

G.

It contains predefined common roles in both the root and the seed.

Question 13

Choose two. In which two situations can you use Database Upgrade Assistant?

Options:

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

Question 14

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.

Question 15

Examine this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are pluggable databases in CDB1. You execute these commands successfully: Which two are true? (Choose two.)

Options:

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.

Question 16

Choose the best answer. A schema owner truncated a table in error and must recover the data. Which Oracle Flashback feature could be used to recover the data?

Options:

A.

FLASHBACK DATABASE

B.

FLASHBACK TABLE

C.

FLASHBACK VERSION QUERY

D.

FLASHBACK DATA ARCHIVE

E.

FLASHBACK TRANSACTION

Question 17

Choose three. Which three are true about Rapid Home Provisioning of Oracle software?

Options:

A.

It can be used to patch existing Oracle software installations.

B.

It can be used only on nodes with Oracle Grid Infrastructure installed.

C.

It can be used to create a single-instance Oracle Database in an already-installed Oracle home. D)It can be used to deploy new homes without disrupting active databases.

D.

It can be used to create templates of Oracle homes as gold images of only Oracle databases.

E.

It can be used to upgrade only single-instance databases running on Oracle Restart.

Question 18

Choose three. Which three are true about Oracle pluggable databases (PDBs)?

Options:

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.

Question 19

Choose three. In which three situations can you use threshold server-generated alerts to help diagnose and fix problems?

Options:

A.

when free space in a dictionary managed tablespace falls below a specified percentage

B.

when free space in a locally managed tablespace falls below a specified percentage

C.

when the total number of locked user account exceeds a specific value

D.

when the number of logons per second exceeds a specific value

E.

when a resumable statement is suspended

F.

when the total number of logons exceeds a specific value

Question 20

Choose two. Which two are true about monitoring waits for sessions and services?

Options:

A.

V$SERVICE_EVENT displays wait counts for every wait event for each service even including counts of zero for waits that never occurred.

B.

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

C.

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

D.

V$SESSION_EVENT displays all waits events for those events that have occurred at least once for sessions that have now terminated.

E.

V$SESSION_WAIT_CLASS displays waits broken down by wait class only for terminated sessions.

Question 21

Choose the best answer. Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 container database (CDB). 2. PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1. After successfully performing all the preupgrade tasks, you execute these commands from the Oracle Database 18c environment: $ export ORACLE_SID=cdb1 $ sqlplus / as sysdba SQL> STARTUP UPGRADE; SQL> SHOW pdbs CON_ID CON_NAME OPEN MODE RESTRICTED -------------------------------------------------¬-------------2 PDB$SEED 3 PDB1 4 PDB2 MIGRATE YES MOUNTED YES MOUNTED YES SQL> ALTER PLUGGABLE DATABASE pdb1 OPEN UPGRADE; Pluggable database altered. SQL> exit $ $ORACLE_HOME/perl/bin/perl catctl.pl -C 'PDB2' What is the outcome?

Options:

A.

It fails because PDB$SEED is in MIGRATE state.

B.

Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded.

C.

Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded.

D.

It fails because PDB2 is not in UPGRADE state.

E.

CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.

F.

Only CDB$ROOT and PDB$SEED are upgraded.

Question 22

Which two are true about server-generated alerts? (Choose two.)

Options:

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

Question 23

While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup istaking too long and suspect a performance bottleneck. Which three are true about diagnosing and tuning these problems? (Choose three.)

Options:

A.

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

B.

Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using synchronous I/O.

C.

If an RMAN BACKUP VALIDATE command takes noticeably lessthan 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 read I/O is a likely bottleneck.

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.

F.

Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using asynchronous I/O/

G.

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

Question 24

For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)

Options:

A.

to specify a default tablespace in a PDB cloned from another PDB in the same CDB

B.

to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB

C.

to include specific user tablespaces only when relocating a PDB

D.

to specify the list of user tablespaces to include when moving a non-CDB to a PDB

E.

to exclude a temp tablespace when plugging in a PDB

F.

to specify the list of tablespaces to include when creating a PDB from the CDB seed

Question 25

Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c? (Choose two.)

Options:

A.

It is an Oracle Database service

B.

It cannot be used to upgrade Oracle Database homes.

C.

It can be used to provision applications.

D.

It can be used to patch Grid Infrastructure homes containing Oracle Restart.

E.

It can be used to provision middleware.

Question 26

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

Options:

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.

Question 27

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.

Question 28

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.

Question 29

Choose two. Which two are true about PDB archive files?

Options:

A.

DBMS_PDB.CHECK_PLUG_COMPATIBILITY can be run against a PDB archive.

B.

They contain a PDB manifest file and all the data files in uncompressed form for a PDB.

C.

They contain all the data files only in uncompressed form for a PDB.

D.

They must be created using the DBMS_PDB package.

E.

They contain a PDB manifest file and all the data files in compressed form for a PDB.

F.

They contain all the data files only in compressed form for a PDB.

Question 30

Examine this configuration:

1. CDB1 is a container database.

2. PDB1 and PDB2 are pluggable databases in CDB1.

3. PDB1 and PDB2 are OPEN in READ WRITE mode.

You execute these commands successfully: Which two are true? (Choose two.)

Options:

A.

Uncommitted transactions in PDB1 have been rolled back.

B.

PDB1 is closed.

C.

Uncommitted transactions in CDB1 and PDB1 have been rolled back.

D.

CDB1 is shut down.

E.

CDB1 is in MOUNT state

Question 31

Choose two. For which two tasks can you use the DBMS_PDB.DESCRIBE procedure?

Options:

A.

to generate an XML metadata file that describes a non-CDB Oracle 12c database so that it can be plugged in as a PDB

B.

to generate an XML metadata file from any unplugged PDB

C.

to determine whether an XML file describes a PDB that can be plugged into the CDB in which you run the procedure

D.

to generate a . pdb archive file for any PDB in the current CDB

E.

to generate an XML metadata file that describes the current plugged-in PDB

Question 32

Examine these queries and their output: An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to recover PDB1 to Restore Point R1. How do you achieve this?

Options:

A.

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using RMAN while connected to PDB1.

B.

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using SQL while connected to PDB1.

C.

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using SQL while connected to CDB$ROOT.

D.

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using RMAN while connected to CDB$ROOT.

E.

This cannot be done due to the lack of a clean restore point.

Question 33

Which three RMAN persistent settings can be set for a database?

Options:

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

Question 34

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.

Question 35

Choose three. In which three situations can you use threshold server-generated alerts to help diagnose and fix problems?

Options:

A.

when free space in a dictionary managed tablespace falls below a specified percentage

B.

when free space in a locally managed tablespace falls below a specified percentage

C.

when the total number of locked user account exceeds a specific value

D.

when the number of logons per second exceeds a specific value

E.

when a resumable statement is suspended

F.

when the total number of logons exceeds a specific value

Question 36

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

Options:

A.

Reduced logical I/O

B.

Reduced virtual memory utilization

C.

Improved Serial Execution performance

D.

Reduced physical I/O

E.

Reduced CPU utilization

Question 37

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

Options:

A.

The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.

B.

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

C.

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

D.

The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVE LOG mode.

E.

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

F.

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

G.

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

Question 38

Choose the best answer. Examine this configuration:

1. CDB1 is a container database running in ARCHIVELOG mode.

2. Multiple uncommitted transactions are running in CDB1.

3. Redo log groups 1 and 2 are INACTIVE.

4. Redo log group 3 is the CURRENT group.

All members of redo log group 3 are lost before it is archived. Examine these possible steps:

1. SHUTDOWN ABORT

2. STARTUP NOMOUNT

3. STARTUP MOUNT

4. ALTER DATABASE MOUNT

5. RESTORE DATABASE

6. RECOVER DATABASE NOREDO

7. RECOVER DATABASE UNTIL AVAILABLE

8. RESTORE ARCHIVELOG ALL

9. ALTER DATABASE OPEN

10. ALTER DATABASE OPEN RESETLOGS

Choose the minimum required steps in the correct order to recover the database.

Options:

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

Question 39

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.

Question 40

Which three statements are true about Flashback Database?

Options:

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.

Question 41

Choose the best answer. Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application. Examine these steps: 1. Install the SALES_APP application, including the common tables, in the application root. 2. Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root. 3. Create an application seed.; 4. Install the SALES_APP application in the application seed. 5. Create the SALES_APP1 and SALES_APP2 application PDBs. 6. Sync root. 7. Sync seed. 8. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application the SALES_APP1 and SALES_APP2 application PDBs with the application the application seed with the application root.

Which are the minimum required steps in the correct sequence?

Options:

A.

1,3,5,7

B.

3,4,1,6,8

C.

1,3,5,6,7

D.

1,5,6

E.

2,5,6

Question 42

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

Question 43

Choose three. Which three are true about OPatch ?

Options:

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.

Question 44

A container database, CDB1, contains a pluggable database PDB1. Another container database is called CDB2. You want to relocate PDB1 from CDB1 to CDB2 with near-zero down time. Which three are required?

Options:

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.

Question 45

Which three are true? (Choose three.)

Options:

A.

Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.

B.

Application-common TSDP policies are always container specific.

C.

Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.

D.

Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.

E.

Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.

F.

Application-common OLS policies can be created in an application root inside an install/patch BEGIN¬END block.

G.

Unified auditing can be automatically synchronized to all application PDBs in an application container.

Question 46

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.

Question 47

Which three are true about an application container?

Options:

A.

It can contain a single application

B.

Two application containers can share an application seed PDB.

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.

Question 48

Choose two. Which two are true about unplugging an application container from a container database and plugging it into a different container database?

Options:

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.

Question 49

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.

Question 50

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.

Question 51

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

Question 52

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

Question 53

Choose three. Which three capabilities require the use of the RMAN recovery catalog?

Options:

A.

using RMAN stored scripts

B.

creating encrypted backups

C.

creating customized reports about a single database's backups

D.

using the REPORT SCHEMA command to list a database's data files and tablespaces at times in the past

E.

using the KEEP FOREVER clause with the BACKUP command

F.

using the REPORT SCHEMA command to list a database's current data files and tablespaces

Question 54

You plan to install Oracle Grid Infrastructure for a Standalone Server and Oracle Database for the first time on a server. Examine this command and its outcome: Which two are true? (Choose two.)

Options:

A.

oracle will be an owner of the Oracle Inventory.

B.

oracle must be the owner of every Oracle Database installation.

C.

oracle can own an Oracle Database installation but not an Oracle Grid Infrastructure installation.

D.

oracle will be granted the SYSASM privilege when installing the Oracle Database software.

E.

The user account, oracle, and group, oinstall, can be used for all Oracle software installations.

Question 55

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.

Question 56

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

Question 57

Which two are true about creating RMAN backups for an Oracle container database?

Options:

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

Question 58

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.

Question 59

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.

Question 60

Choose three. Which three are true about Oracle Restart?

Options:

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.

Question 61

HR_ROOT is an application container with the HR_APP application installed. No application PDBs and no application seed have yet been created in HR_ROOT. An application PDB, PDB1,must be created so that the HR_APP application's common objects are accessible to it. Which two methods can be used?

Options:

A.

Create the PDB1 application PDB and synchronize it with poB$SEED.

B.

Create the PDB1 application PDB and synchronize it with HR_ROOT.

C.

Create the PDB1 application PDB and install HR_APP in it.

D.

Create an application seed, and install HR_APP in it.

E.

Create an application seed, synchronize it with HR_ROOT, and then create the PDB1.application PDB.

Question 62

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.

Question 63

choose one .Examine the 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 statement is true about the DUPLICATE command?

Options:

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.

Question 64

You are working on an Oracle Database 19c database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? (Choose two.)

Options:

A.

Flashback logs are not archived.

B.

Flashback logs are maintained in redo log files.

C.

Flashback logs are maintained in the Flash Recovery Area.

D.

Flashback logs are used to maintain Flashback Database related errors.

E.

Flashback logs need to be cleared manually after you disable Flashback Database.

Question 65

Choose three. Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PDB) starting from Oracle 19c?

Options:

A.

automatically dropping the database link to the remote database if it already exists

B.

opening the cloned PDB

C.

creating a new empty PDB in the local database from PDB$SEED

D.

creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned

E.

creating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database

F.

creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned

G.

creating a database link from CDB$ROOT in the remote database to the PDB in the local database

Question 66

Which four are true about RMAN backup sets? (Choose four.)

Options:

A.

A backup piece can belong to only one backup set.

B.

A data file can be split into multiple sections stored in different backup sets.

C.

A data file can be split into multiple sections stored in different backup pieces in the same backup set.

D.

Blocks from multiple data files can be contained in one backup piece,

E.

A backup set can contain only one backup piece.

F.

A backup set must be written to media.

G.

A backup set must be written to disk.

Question 67

Examine this output: Which two are true? (Choose two.)

Options:

A.

Any PDB not specified in the plan will be unable to execute statements in parallel.

B.

PDB3 can use all available parallel execution processes at times.

C.

PDB1 is always limited to 40% of the available system resources regardless of demand.

D.

Any PDB notspecified in the plan will be able to use a maximum of 16.5% of the available system resources.

E.

PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.

F.

PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.

Question 68

Which two are true about creating pluggable databases (PDBs) in Oracle 19c and later releases?

Options:

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

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

Question 69

Choose two. You want to install Oracle Grid Infrastructure for a Standalone Server using Oracle Universal Installer (OUI). There is no existing Oracle installation on the server. Which two are prerequisites?

Options:

A.

an operating system user to own this installation

B.

the Oracle Inventory group oinstall

C.

an operating system account called grid

D.

a group called dba

E.

the installation of Oracle ASMLIB

Question 70

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.

Question 71

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.

Question 72

Which three statements are true about Flashback Data Archive?

Options:

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.

Question 73

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.

Question 74

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.

Question 75

Choose three. PDB1 and PDB2 are pluggable databases in CDB1. Examine these commands: $ export ORACLE_SID=CDB1 $ sqlplus / as sysdba SQL> STARTUP ....... Database opened. SQL> SHOW PDBS CON_ID CON_NAME --------------------------------------------------------------------OPEN MODE READ ONLY NO MOUNTED MOUNTED SQL> ALTER PLUGGABLE Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE pdb1 SAVE STATE; Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE pdb1 CLOSE; Pluggable database altered. SQL> ALTER PLUGGABLE A DATABASE pdb2 OPEN; Pluggable database altered. CDB1 is then restarted. Which three are true?

Options:

A.

PDB2 will be opened READ WRITE.

B.

PDB1 will be opened READ WRITE.

C.

PDB1 will be MOUNTED.

D.

PDB$SEED will be opened READ ONLY.

E.

PDB$SEED will be MOUNTED

F.

PDB2 will be MOUNTED.

Question 76

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.

Question 77

Which three are true in Oracle 19c and later releases? (Choose three.)

Options:

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.

Question 78

Which two are true about poorly performing SQL statements and their tuning in Oracle database instances?

Options:

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.

Question 79

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.

Question 80

Choose two. Which two are true about the execution of operating system scripts starting from Oracle Database 19c?

Options:

A.

The root password cannot be specified in a response file.

B.

The sudo password must be specified in a response file.

C.

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

D.

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

E.

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

Question 81

Choose three. In a single-instance, multitenant container database (CDB), which three are only ever defined in or part of CDB$ROOT?

Options:

A.

redo logs

B.

control files

C.

all data dictionary metadata

D.

user-defined PL/SQL packages

E.

temporary tablespaces

F.

mandatory Oracle-supplied PL/SQL packages

G.

undo tablespaces

Question 82

choose four Which four are true about performance-related Oracle tools?

Options:

A.

The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two consecutive periods.

B.

SQL Performance Analyzer can suggest schema changes.

C.

SQL Performance Analyzer can identify regressed SQL statements.

D.

Database Replay always uses one replay client for all the original database sessions.

E.

Database Replay always uses one replay client for each original database session.

F.

The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two non¬consecutive periods.

G.

The Active Session History (ASH) report is based on wait event samples.

Question 83

Which two are true about the execution of operating system scripts starting from Oracle Database 19c? (Choose two.)

Options:

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.

Question 84

Choose three. Which three are true about the FLASHBACK DATABASE feature?

Options:

A.

FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time.

B.

It requires that the target database be in ARCHIVELOG mode.

C.

FLASHBACK LOGS are archived after a log switch.

D.

A database can be flashed back using SQL*PLUS.

E.

It always generates REDO and UNDO.

F.

Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database.

Question 85

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. APP_ROOT is an application root in CDB1. 3. APP_PDB1 is an application PDB in APP_ROOT. 4. FLASHBACK DATABASE is ON. You execute these commands: $ sqlplus sys/orac1e_4U@localhost:1521/cdb1 SQL> SELECT current_scn FROM v$database; CURRENT_SCN -----------------------2074756 SQL> CREATE TABLE cdb1_tab(c1 NUMBER) ; Table created. SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. SQL> CREATE TABLE app_root_tab (c1 NUMBER) ; Table created. SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered. SQL> CREATE TABLE app_pdb1_tab (c1 NUMBER) ; Table created. SQL> conn / as sysdba Connected. SQL> ALTER PLUGGABLE DATABASE app_root CLOSE; Pluggable database altered. SQL> FLASHBACK PLUGGABLE DATABASE app_root TO SCN 2074756; Flashback complete. Which table or set of tables will exist after the Flashback operation has completed?

Options:

A.

CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB

B.

CDB1_TAB and APP_PDB1_TAB

C.

CDB1_TAB and APP_ROOT_TAB

D.

CDB1_TAB only

E.

none of the tables, because all three tables will be dropped

Page: 1 / 29
Total 286 questions