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

Question 41

You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years.
You execute the following command to change the requirement:
SQL> ALTER FLASHBACK ARCHIVE fda1 MODIFY RETENTION 2 YEAR;
What is the outcome?

A.All historical data older than two years, if any, is purged from the flashback archive FDA1.

B.An error is returned because the retention period cannot be reduced.

C.All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time.

D.All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years.

Question 42

Which three statements are true about a job chain? (Choose three.)

A.It can contain a nested chain of jobs.

B.It can be used to implement dependency-based scheduling.

C.It cannot invoke the same program or nested chain in multiple steps in the chain.

D.It cannot have more than one dependency.

E.It can be executed using event-based or time-based schedules.

Question 43

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 44

You are administering a multitenant container database (CDB) CDB1 with two pluggable databases (PDBs), PDB1 and PDB2. You execute the following commands on CBD$ROOT as the SYS user:
SQL> CREATE USER c##scott IDENTIFIED BY scottorcll;
SQL> GRANT CREATE SESSION TO c##scott user?
Which statement is true about the C##SCOTT user?

A.It is created only in CDB$ROOT and has the CREATE SESSION privilege.

B.It is created and has the CREATE SESSION privilege only in a PDB that is open.

C.It is created in all the PDBs but has the CREATE SESSION privilege only in CDB$ROOT.

D.It is created in all the PDBs with the CREATE SESSION privilege.

Question 45

Your database is running in ARCHIVELOGmode. Examine the initialization parameters you plan to set for
your database instance.
LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch'
LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/3rch'
LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch'
L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/3rch MANDATORY'
Identify the statement that correctly describes these settings.

A.Optional destinations cannot use the fast recovery area.

B.An online redo log file is not allowed to be overwritten if the archived log file cannot be created in any of
the LOG_ARCHIVE_DEST_.ndestinations.

C.An online redo log file is not allowed to be overwritten if the archived log file cannot be created in the
location specified for LOG_ARCHIVE_DEST_4.

D.These settings work only if LOG__ARCHIVE_MIN_SUCCEED_DESTis set to a value of 4.

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

Latest Upload: 106Oracle.1Z0-1057-23.v2025-09-10.q47; 146Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 149TheSecOpsGroup.CNSP.v2025-09-08.q20; 200CFAInstitute.ESG-Investing.v2025-09-08.q173; 150PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 139Salesforce.Data-Architect.v2025-09-05.q216; 136Adobe.AD0-E605.v2025-09-05.q50; 173Nutanix.NCP-MCI-6.10.v2025-09-05.q55; 114Oracle.1z0-591.v2025-09-05.q104

Question 41

Question 42

Question 43

Question 44

Question 45

Download PDF File