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

1z0-083 Exam Dumps - Oracle Database Administration II

Go to page:
Question # 33

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

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.

Full Access
Question # 34

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

A.

It can be used to deploy Grid Infrastructure homes, including Oracle Restart.

B.

It can be used to deploy Oracle Database homes.

C.

It is an Oracle Database service.

D.

It cannot be used to provision applications.

E.

It cannot be used to provision middleware.

F.

It is an Oracle Grid Infrastructure service.

Full Access
Question # 35

choose three Which three are true about unified auditing in full mode?

A.

The unified audit trail is written to a read-only table.

B.

The unified audit trail is written to a read-only external file.

C.

Audit records are created for COMMIT, ROLLBACK, and SAVEPOINT statements.

D.

Audit records are created for SYS.

E.

Audit records are created for non-sys users.

Full Access
Question # 36

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

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.

Full Access
Question # 37

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

A.

Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.

B.

Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

C.

Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.

D.

Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.

E.

Re-createthepasswordfileintheOracleDatabase12cformat. Correct

Full Access
Question # 38

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

Full Access
Question # 39

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

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.

Full Access
Question # 40

Choose three. Which three are true about upgrading an application in an application container?

A.

An application root clone gets created automatically.

B.

The upgrade can be performed when connected either to CDB$ROOT or to PDB$SEED.

C.

After an application upgrade, the application container's PDBs remain synchronized with the existing application root.

D.

The upgrade must be performed when connected to CDB$ROOT.

E.

An application name and version number must be specified to upgrade the application.

F.

After an application upgrade, the application container's PDBs are automatically synchronized with the application root clone.

Full Access
Go to page: