Free Access Oracle.1z0-063.v2022-10-18.q151 Practice Test (Page 15)

Question 66

RMAN is configured to create backupset backups for your database. You issue the command to back up the database:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which two statements are true about the backup performed by the command? (Choose two.)

A.Only the used blocks in the data files are backed up.

B.It backs up all the data files and deletes obsolete backups after the backup is complete.

C.It backs up only those archived log files that are not backed up at least once.

D.It backs up all the archived log files and deletes the ones that were just backed up.

E.It backs up all archived redo log files and online log files and deletes the archived log files after the backup is complete.

Question 67

Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests? (Choose three.)

A.RMAN preauthorization on the host

B.OSB encryption for data in transport and on tape

C.matching the OS user identity of the Oracle instance associated with the database username

D.assigned to a class with rights to back up or restore Oracle database

E.scheduling of the RMAN backup to occur automatically at user-defined intervals

F.assigned to a class with rights to browse all directories and catalogs

Question 68

Examine the RMAN command:

Which statement is true about the command?

A.It creates compressed backup sets.

B.It uses asynchronous I/O for the backup.

C.It uses parallelization for the backup set.

D.It uses multisection backup.

Question 69

You issue the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which three tasks are performed by the BACKUP DATABASE command? (Choose three.)

A.switching the online redo log

B.backing up all used and unused blocks in the data files

C.backing up all data files as image copies and archive logs, and deleting those archive logs

D.backing up only the used blocks in the data files

E.backing up all archived logs and marking them as obsolete

Question 70

Which two statements are true when row-archival management is enabled?

A.The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.

B.The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.

C.Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.

D.The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.

E.The row archival visibility session parameter defaults to all rows.

Other Version: 3075Oracle.1z0-063.v2022-04-21.q171

Latest Upload: 101OCEG.GRCP.v2025-09-11.q211; 101HP.HPE0-V27.v2025-09-11.q78; 117Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 164TheSecOpsGroup.CNSP.v2025-09-08.q20; 222CFAInstitute.ESG-Investing.v2025-09-08.q173; 156PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 146Salesforce.Data-Architect.v2025-09-05.q216; 140Adobe.AD0-E605.v2025-09-05.q50

Question 66

Question 67

Question 68

Question 69

Question 70

Download PDF File