Month End Sale Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

Activedumpsnet Logo
  1. Home
  2. Oracle
  3. Oracle Database 19c
  4. 1z0-083 - Oracle Database Administration II

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

Page: 1 / 28
Total 282 questions
Get 1z0-083 Full Access Download 1z0-083 PDF

Oracle Database Administration II Questions and Answers

Question 1

Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)

Options:

A.

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

B.

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

C.

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

D.

The RMAN SHOW ALL command displays only settings with nondefault values.

E.

A target database’s persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.

F.

The V$RMAN_CONFIGURATION view displays only settings with valuesthat have been modified. G)A DBA must specify either a redundancy retention policy or a recovery window retention policy.

Question 2

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 3

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.

Question 4

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 5

While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck. FORCE LOGGING is enabled for the database. Which two could improve read performance? (Choose two.)

Options:

A.

Increase the size of tape I/O buffers.

B.

Disable FORCE LOGGING for the database.

C.

Increase the size of the database buffer cache.

D.

Enable asynchronous disk I/O.

E.

Increase the level of RMAN multiplexing.

Question 6

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.

Question 7

Choose two. Your database is in ARCHIVELOG mode and you plan to use Flashback Database. Which two features or parameters manage space availability in the fast recovery area?

Options:

A.

the backup retention policy

B.

the backup optimization policy

C.

the DB_CREATE_ONLINE_LOG_DEST_n parameter setting

D.

the archived log deletion policy

E.

the DB_RECOVERY_FILE_DEST parameter setting

F.

using guaranteed UNDO retention

Question 8

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

Question 9

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.

Question 10

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.

Question 11

Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)

Options:

A.

cloning a remote container database in interactive mode

B.

cloning a remote pluggable database in silent mode

C.

relocating a remote pluggable database in interactive mode

D.

relocating a remote container database in silent mode

E.

cloning a remote container database in silent mode

F.

relocating a remote pluggable database in silent mode

G.

relocating a remote container database in interactive mode.

Question 12

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 13

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 14

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 15

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 16

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

Options:

A.

It can only be launched from the command line interface.

B.

It can be launched from both the command line and the Universal Installer (OUI) interfaces.

C.

It can be used to create container databases and non-container databases.

D.

It can be used to change the character set of an existing database.

E.

It can be used to convert a non-container database to a container database.

Question 17

Choose the best answer. Examine this configuration: 1. CDB1 is an Oracle container database from an older release. 2. PDB1, PDB2, PDB3, and PDB4 are pluggable databases in CDB1. A priority list UpgrdList has these entries: 1, pdb2 2, pdb1, pdb3 You execute this command: $ /u01/app/oracle/product/18.1.0/ db_1/rdbms/admin/dbupgrade -L UpgrdList In which order will the upgrade occur?

Options:

A.

CDB$ROOT, PDB$SEED, PDB2, PDB1, PDB3, and PDB4

B.

CDB$ROOT, PDB2, PDB1, and PDB3

C.

CDB$ROOT, PDB$SEED, PDB2, PDB1, and PDB3

D.

CDB$ROOT, PDB1, PDB2, PDB3, and PDB4

E.

CDB$ROOT, PDB$SEED, PDB1, PDB3, PDB2, and PDB4

Question 18

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)

Question 19

choose one You want to create a test database as a replica of your production database with minimum intervention from a DBA. Which method would you use?

Options:

A.

Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location.

B.

Use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure.

C.

Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump.

D.

Create the database by using the CREATE DATABASE . . . command and manually import data by using Data Pump.

Question 20

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.

Question 21

Choose two. Which two are true about the SQL Tuning Advisor?

Options:

A.

It can recommend semantic changes to SQL statements.

B.

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

C.

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

D.

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

E.

It only recommends syntactic changes to SQL statements.

Question 22

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.

Question 23

A user complains about poor database performance. You want to verify if the user’s session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?

Options:

A.

V$SESSION_EVENT

B.

V$SESSTAT

C.

V$SESSION_WAIT

D.

V$SESSION_WAIT_CLASS

E.

V$SESSION

Question 24

Choose the best answer. Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?

Options:

A.

It is a set of recommendations by the optimizer to change the access methods used.

B.

It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error.

C.

It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans.

D.

It is auxiliary information collected by the optimizer for a SQL statement to help use better joins orders.

E.

It is a set of recommendations by the optimizer to create new indexes.

Question 25

Choose two. Which two are true about RMAN persistent configuration settings, administration, and their effects?

Options:

A.

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

B.

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

C.

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

D.

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

Question 26

Which three are true about the SQL Tuning Advisor? (Choose three.)

Options:

A.

It checks each query being analyzed for stale statistics.

B.

It checks each query being analyzed for missing statistics.

C.

It only recommends syntactic changes to SQL statements.

D.

It can recommend semantic changes to SQL statements.

E.

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

F.

It builds SQL profiles for each poorly performing SQL statement to prevent regressions.

Question 27

Choose three. Which three are true about the tools for diagnosing Oracle Database failure situations?

Options:

A.

RMAN can always repair corrupt blocks.

B.

Flashback commands help with repairing physical errors.

C.

The ADR can store metadata in an Oracle Database repository.

D.

The Automatic Diagnostic Repository (ADR) has a separate home directory for each instance of each Oracle product that is installed and uses it.

E.

The ADR command-line utility (ADRCI) can package incident information to send to Oracle Support.

F.

The Data Recovery Advisor uses the ADR.

Question 28

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.

Question 29

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 30

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 31

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.

Question 32

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.

Question 33

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 34

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 35

choose two Which two are benefits of unified auditing in full mode?

Options:

A.

All audit data is written to both the traditional locations and to the unified location.

B.

The audit trail is in a single format.

C.

Pre 12c audit data is written to the traditional locations and new 12c audit data is written to the unified location.

D.

The audit trail is read-only.

E.

The audit trail uses less space.

Question 36

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.

Question 37

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 38

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?

Options:

A.

It will create a multitenant container database (CDB) with only the root opened.

B.

ItwillcreateaCDBwithrootopenedandseedreadonly.

C.

It will create a CDB with root and seed opened and one PDB mounted.

D.

It will create a CDB that must be plugged into an existing CDB.

E.

ItwillcreateaCDBwithrootopenedandseedmounted.

Question 39

choose two Which two statements are true about encrypted backups performed by using RMAN?

Options:

A.

Transparent encryption of backups uses an encryption wallet.

B.

Image copy backups can be created by using password encryption.

C.

A password encryption of backups uses the password while creating and restoring backups.

D.

Encrypted backups can only be written to disk.

E.

A database uses the same encryption key for every encrypted backup.

Question 40

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 41

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 comman

Options:

A.

It succeed

B.

It fails because no parallel channels are allocated for the auxiliary databa

C.

It fails because connection to the AUXILIARY instance must be as SYSD

D.

Itsucceeds only if the target database is greater than 40

E.

No catalogued backup of the TARGET is used to duplicate the databa

Question 42

Which two statements are true about RMAN duplexed backups?

Options:

A.

It is not supported for image copies.

B.

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

C.

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

D.

Duplex backups can contain only data files and control files.

E.

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

Load More 1z0-083 Questions 
Page: 1 / 28
Total 282 questions
Get 1z0-083 Full Access Download 1z0-083 PDF