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

1z0-083 Oracle Database Administration II Questions and Answers

Questions 4

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 5

Choose two. Which two are true about the Optimizer Statistics Advisor?

Options:

A.

It always analyzes all schemas in the database.

B.

It can recommend changes to improve the statistics gathering process.

C.

It can be run only manually.

D.

It runs automatically every night by default. E) It can be run only automatically.

Buy Now
Questions 6

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 7

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.

Buy Now
Questions 8

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

Options:

A.

All AWR tables belong to the SYSTEM schema.

B.

The AWR data is stored in memory and in t he database.

C.

The snapshots collected by AWR are used by the self-tuning components in the database

D.

AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.

E.

AWR contains system wide tracing and logging information.

Buy Now
Questions 9

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 10

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 11

Examine these actions: 1. Create a new database for a recovery catalog. 2. Create a tablespace with sufficient space in the catalog database for the recovery catalog. 3. Configure ARCHIVE LOG mode for the catalog database. 4. Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog. 5. Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner. 6. Grant the SYSBACKUP privilege to the recovery catalog schema owner. Which are the minimum actions that must be performed before executing the CREATE CATALOG command?

Options:

A.

2,4,5,6

B.

1,2,3,4,5,6

C.

1,2,4,5

D.

2,4,5

E.

1,3,4,5

Buy Now
Questions 12

Choose three. Which three are true about block media recovery?

Options:

A.

To use it, Flashback Database must be enabled.

B.

A block being recovered is not accessible.

C.

It cannot repair logical corruption.

D.

It can be performed on noncorrupt blocks.

E.

The target database for which one or more blocks are to be recovered must be in the OPEN state.

F.

The data file containing the block being recovered remains online.

Buy Now
Questions 13

Choose three. Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)?

Options:

A.

the data dictionary in CDB$ROOT

B.

the log writer process (LGWR)

C.

SYSAUX tablespaces

D.

temporary tablespaces

E.

the Process Monitor Process (PMON)

F.

undo tablespaces

Buy Now
Questions 14

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 15

hoose two. Which two are true about Recovery Manager (RMAN) diagnostic message output?

Options:

A.

The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.

B.

The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output.

C.

RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.

D.

Media Management messages for SBT devices are written to an Oracle trace file.

E.

MAN error stacks should be read from the top down as that is the order in which errors are generated.

Buy Now
Questions 16

You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs. How can you detect the cause of the degraded performance?

Options:

A.

by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis

B.

by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots

C.

by using Active Session History (ASH) data and performing hang analysis

D.

by running ADDM in diagnostic mode

Buy Now
Questions 17

A container database called CDB1 is OMF-enabled. PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will be executed in CDB1: CREATE PLUGGABLE DATABASE pdb1 USING ‘/u01/app/oracle/oradata/pdb1.xml’ SOURCE_FILE_NAME_CONVERT = (‘/u01/app/oracle/oradata/’, ‘/u02/app/oracle/oradata/’);

Which two are true? (Choose two.)

Options:

A.

PDB1 data files already exist in the correct location.

B.

DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.

C.

PDB_FILE_NAME_CONVERT must be set before executing the command.

D.

/u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.

E.

PDB1 must be dropped from CDB1.

Buy Now
Questions 18

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

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

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 22

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 23

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 24

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 25

choose two You take your database backups by using the RMAN media management interface (MMI). Which two are true about the use of the RMAN MMI?

Options:

A.

You can

B.

You can

C.

You can

D.

You can

E.

You can

Buy Now
Questions 26

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.

Buy Now
Questions 27

Examine the RMAN command: RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE sbt; ALLOCATE CHANNEL c2 DEVICE TYPE sbt; ALLOCATE CHANNEL c3 DEVICE TYPE sbt; BACKUP INCREMENTAL LEVEL = 0 (DATAFILE 1,4,5 CHANNEL c1) (DATAFILE 2,3,9 CHANNEL c2) (DATAFILE 6,7,8 CHANNEL c3); SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT'; } Which statement is true about the command?

Options:

A.

It uses multisection backup.

B.

It uses parallelization for the backup set.

C.

It uses asynchronousI/O for the backup.

D.

It creates compressed backup sets.

Buy Now
Questions 28

You have configured RMAN SBT channels to write backups to media. You then take an RMAN backup by using this command: Which three are true? (Choose three.)

Options:

A.

The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.

B.

The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.

C.

All archive logs created after this backup are kept for two years.

D.

The SPFILE is included in the self-contaied archival backup.

E.

The control file is included in the self-contained archival backup.

F.

The restore point is a label for the system change number (SCN) before the archival backup was taken.

Buy Now
Questions 29

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 30

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.

Buy Now
Questions 31

Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)

Options:

A.

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

B.

Data files can be converted on the destination system.

C.

Data files can be converted on the source system.

D.

A new DBID is automatically created for the transported database.

E.

Databases can be transported between systems with different endian formats.

F.

The password file is automatically converted by RMAN.

Buy Now
Questions 32

Choose the best answer. Examine this configuration:

1. CDB1 is a container database.

2. There are several pluggable databases (PDBs) in CDB1.

5. Each PDB has several tables with referential integrity constraints.

6. FLASHBACK DATABASE is ON.

7. UNDO RETENTION GUARANTEE is enabled.

Multiple undesired multitable changes were made in all the PDBs.

Which method can be used to undo the changes using a single command?

Options:

A.

restore and recover database

B.

flashback transaction

C.

flashback database

D.

flashback table and transaction

E.

flashback table

Buy Now
Questions 33

Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)

Options:

A.

using Database Replay

B.

using SQL Developer

C.

using Oracle Data Pump

D.

using operating system file copy utilities

E.

using Database Upgrade Assistant

F.

using the CREATE TABLE AS SELECT SQL statement

Buy Now
Questions 34

Examine this configuration: While CDB1 is open, ‘/u02/app/oracle/fast_recover_area/cdb1/CDB1/ controlfile02.ctl’is accidentally deleted. To recover from this critical failure, you execute these commands:

What will be the outcome?

Options:

A.

It will create ‘$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl’

B.

It will create ‘/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl’.

C.

It will re-create ‘/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl’

D.

It will create ‘/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl’.

E.

It will fail because there is no autobackup of the controlfiles.

Buy Now
Questions 35

Choose two. Which two are true about RMAN Multisection backups when a very large data file is divided into four sections?

Options:

A.

The four sections must be image copies.

B.

Each of the file sections must be processed serially.

C.

The four sections must be contained in backup sets.

D.

The four sections can be created in parallel.

E.

The four sections can be created serially.

Buy Now
Questions 36

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 an application seed, synchronize it with HR_ROOT, and then create the PDB1 application PDB.

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 the PDB1 application PDB and synchronize it with PDB$SEED.

E.

Create an application seed, and install HR_APP in it.

Buy Now
Questions 37

After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows: SQL> select number_value from REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE ------------0 SQL> exec DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES(-1); SQL> select number_value from REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE -------------1 After changing the value, you notice that FULL redaction continues to redact numeric data with zero.What must you do to activate the new default value for numeric full redaction?

Options:

A.

Re-enableredactionpoliciesthatuseFULLdataredaction.

B.

Re-createredactionpoliciesthatuseFULLdataredaction.

C.

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

D.

Flushthesharedpool.

E.

Restart the database instance. Correct

Buy Now
Questions 38

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 39

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

Options:

A.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.

B.

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

C.

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

D.

System statistics can be gathered only while connected to CDB$ROOT.

E.

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

Buy Now
Questions 40

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

Buy Now
Questions 41

Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment?

Options:

A.

AWR snapshots can be created in CDB$ROOT.

B.

ADDM can run in a nonroot container.

C.

AWR reports can be generated while connected to any container.

D.

All AWR data is stored in the CDB$ROOT SYSAUX tablespace.

E.

AWR snapshots can be created in a PDB.

F.

No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

Buy Now
Questions 42

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.

Buy Now
Exam Code: 1z0-083
Exam Name: Oracle Database Administration II
Last Update: May 30, 2023
Questions: 282

PDF + Testing Engine

$140

Testing Engine

$105

PDF (Q&A)

$90