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

examout.co

Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database?

A.

DBUA must be launched from the target Oracle Home.

B.

Multiple databases with the same ORACLE_HOME can be upgraded simultaneously.

C.

A whole database backup must exist before upgrade.

D.

The Pre-Upgrade Information Tool script is executed by DBUA.

E.

All pluggable databases are automatically upgraded as part of a container database upgrade.

F.

The database must be opened in read-only mode.

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?

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

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

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.

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

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.

Choose two. In performance management, which two factors might reduce the ability of an application to scale to a larger number of users?

A.

poorly trained users who do not commit transactions

B.

the number of tablespaces containing tables updated by a transaction

C.

issuing multiple savepoints during a transaction

D.

the number of data files containing extents belonging to tables updated by a transaction

E.

poorly written SQL

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

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.

Which three are true about Optimizer Statistics Advisor? (Choose three.)

A.

It can be run only manually.

B.

It is part of the DBMS_ADVISOR package.

C.

It can recommend changes to improve the statistics gathering process.

D.

It always analyzes all schemas in the database.

E.

It runs automatically every night by default.

F.

It is part of the DBMS_STATS package.

RMAN is connected to a target database instance and an auxilary instance. You execute 3625the command: RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE SECTION SIZE 1G; What is the outcome?

A.

RMAN uses the pull method to restore files using image copies

B.

RMAN uses the push method to transfer image copies

C.

RMAN uses the push method to transfer backup sets

D.

RMAN uses the pull method to restore files using backup sets

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?

A.

Tracking the most recent read time for a table segment in a user tablespace

B.

Tracking the most recent write time for a table segment in a user tablespace

C.

Tracking insert time by row for table rows

D.

Tracking the most recent write time for a table block

E.

Tracking the most recent read time for a table segment in the SYSTEM tablespace

F.

Tracking the most recent write time for a table segment in the SYSAUX tablespace Correct

Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)

A.

All metrics are instance related.

B.

Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.

C.

A space usage management alert is automatically cleared after the underlying problem is resolved

D.

They are generated by SMON when a tablespace is 97% full.

E.

Metrics are statistical counts for a specific unit.

F.

STATISTICS_LEVEL must be set to ALL to generate alerts.