1Z0-083 Online Practice Questions and Answers

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

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.

Which four are true about performing Tablespace Point -In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?

A. It can be performed using an auxiliary instance managed by a DBA.

B. It can be used to recover a truncated table.

C. RMAN automatically adds any required tablespaces to the recovery set to make it self-contained.

D. RMAN always includes tablespaces containing undo segments in the recovery set.

E. It can be performed repeatedly until the correct time is found without using an RMAN catalog.

F. flashback database must be enabled for it to work.

G. It can be used to recover a dropped tablespace.

H. It can be performed using an auxiliary instance managed by RMAN.

The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup.

A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;

B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

C. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

D. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;

E. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;

F. BACKUP SPFILE SECTION SIZE 1M;

G. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges.

You execute the command:

SQL>CREATE AUDIT POLICY tab1e_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin, oe_admin;

Which statement is true?

A. It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN or OE_ADMIN role.

B. It fails because the command does notspecify when the unified audit policy should be enforced.

C. It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.

D. It fails because system privileges cannot be granted with roles in the same audit policy.

You take regular backups of one of your production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which must be included in future backups. Which process occurs which allows the new backups to contain the new datafiles?

A. The target database control file is synchronized from the recovery catalog with a partial resync at the next backup.

B. The recovery catalog is synchronized from the target database control file with a full resync at the next backup.

C. The target database control file is synchronized from the recovery catalog with a full resync at the next backup.

D. The recovery catalog is synchronized from the target database control file with a partial resync at the next backup.

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?

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

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

A. It is an Oracle Database service.

B. It can be used to deploy Oracle Database homes.

C. It cannot be used to provision applications.

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

E. It cannot be used to provision middleware.

F. It is an Oracle Grid Infrastructure service.

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

A. SQL statements performing many physical I/Os can always have their performance improved by creating indexes.

B. SQL statements doing only logical reads never require tuning because they do no physical I/O.

C. The solution that best optimizes one SQL statement can degrade the performance of others.

D. SQL statements doing joins always do more physical I/O than single table queries.

E. Poorly performing SQL statements can be tuned automatically by the Oracle server.

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? (Choose two.)

A. the archived log deletion policy

B. the backup optimization policy

C. the backup retention policy

D. using guaranteed UNDO retention

E. the DB_CREATE_ONLINE_LOG_DEST_n parameter setting

F. the DB_RECOVERY_FILE_DEST parameter setting

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

A. Each of the file sections must be processed serially.

B. The four sections can be created serially.

C. The four sections must be image copies.

D. The four sections can be created in parallel.

E. The four sections must be contained in backup sets.