Create Next App

Exam contains 181 questions

Page 14 of 31

Question 79 🔥

The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode.Which two are true about using RMAN to perform an open database back up of this tablespace? (Choose two.)

Which database solution meets these requirements?

A. Backups must be done incrementally.

Highly voted

B. Backups must be contained in backup sets.

Highly voted

C. Backups can be taken only if the database is in ARCHIVELOG mode.

Highly voted

D. Backups can be done incrementally.

Highly voted

E. The database must be registered in an RMAN catalog.

Highly voted

F. Only consistent backups can be created.

Highly voted

Discussion of the question

Question 80 🔥

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

Which database solution meets these requirements?

A. A backup piece can belong to only one backup set.

Highly voted

B. A data file can be split into multiple sections stored in different backup sets.

Highly voted

C. A data file can be split into multiple sections stored in different backup pieces in the same backup set.

Highly voted

D. Blocks from multiple data files can be contained in one backup piece.

Highly voted

E. A backup set can contain only one backup piece.

Highly voted

F. A backup set must be written to media.

Highly voted

G. A backup set must be written to disk.

Highly voted

H. Blocks from multiple data files can be contained in one backup set.

Highly voted

Discussion of the question

Question 81 🔥

Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)

Which database solution meets these requirements?

A. Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.

Highly voted

B. The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected to a PD

Highly voted

C. SPFILE backups can be created while connected to an application root PDB.

Highly voted

D. The BACKUP DATABASE PLUS ARCHIVELOG command will back up archive logs when RMAN is connected to a PDB.

Highly voted

E. The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT.

Highly voted

Discussion of the question

Question 82 🔥

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

Which database solution meets these requirements?

A. cloning a remote container database in interactive mode

Highly voted

B. cloning a remote pluggable database in silent mode

Highly voted

C. relocating a remote pluggable database in interactive mode

Highly voted

D. relocating a remote container database in silent mode

Highly voted

E. cloning a remote container database in silent mode

Highly voted

F. relocating a remote pluggable database in silent mode

Highly voted

G. relocating a remote container database in interactive mode

Highly voted

Discussion of the question

Question 83 🔥

Examine these queries and their output:An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created.You want to recover PDB1 to Restore Point R1.How do you achieve this?

Which database solution meets these requirements?

A. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1.

Highly voted

B. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1.

Highly voted

C. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT.

Highly voted

D. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT.

Highly voted

E. This cannot be done due to the lack of a clean restore point.

Highly voted

Discussion of the question

Question 84 🔥

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

Which database solution meets these requirements?

A. All metrics are instance related.

Highly voted

B. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.

Highly voted

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

Highly voted

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

Highly voted

E. Metrics are statistical counts for a specific unit.

Highly voted

F. STATISTICS_LEVEL must be set to ALL to generate alerts.

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_083

Exam contains 181 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us