Free Access Oracle.1Z0-060.v2022-02-12.q102 Practice Test (Page 2)

Question 1

Your multitenant container database (CDB) is running in ARCHIVELOG mode.
Examine this command and its output:

You issue this command in RMAN:
RMAN>BACKUP PLUGGABLE DATABASE "CDB$ROOT", pdb2_1;
What is the outcome?

A.The backup fails because PDB2_1should be placed in the mount stage.

B.The backup succeeds and all the data files belonging to both the root container and PDB2_1are backed up.

C.The backup succeeds, but only the SYSTEMand SYSAUXtablespaces in the root container are backed up along with all the data files in PDB2_1.

D.The backup fails because the root container cannot be backed up with PDB2_1.

Question 2

You performed an incremental level 0 backup of a database:
RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;
To enable block change tracking after the incremental level 0 backup, you issued this command:
SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/
rman_change_track.f';
To perform an incremental level 1 cumulative backup, you issued this command:
RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which three statements are true? (Choose three.)

A.Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.

B.The change tracking file must always be backed up when you perform a full database backup.

C.Block change tracking will always reduce I/O performed during cumulative incremental backups.

D.More than one database block may be read by an incremental backup for a change made to a single block.

E.The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

Question 3

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the DB_SMART_FLASH_FILE parameter: DB_FLASH_CACHE_FILE= '/dev/flash_device_1 ',' /dev/flash_device_2'
How should the DB_FLASH_CACHE_SIZE be configured to use both devices?

A.Set DB_FLASH_CACHE_ZISE = 64G.

B.Set DB_FLASH_CACHE_ZISE = 64G, 64G

C.Set DB_FLASH_CACHE_ZISE = 128G.

D.DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.

Question 4

What is the result of executing a TRUNCATE TABLE command on a table that hasFlashback Archivingenabled?

A.It fails with the ORA-665610 Invalid DDL statement on history-tracked message

B.The rows in the table are truncated without being archived.

C.The rows in the table are archived, and then truncated.

D.The rows in both the table and the archive are truncated.

Question 5

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-create the password file in the Oracle Database 12c format.

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

Question 1

Question 2

Question 3

Question 4

Question 5

Download PDF File