Free Access Oracle.1z0-062.v2022-12-05.q411 Practice Test (Page 8)

Question 31

Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.
Which two RMAN commands may be; used to back up only the PDB1 pluggable database?
(Choose two.)

A.BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container

B.BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container

C.BACKUP DATABASE while connected to the PDB1 container

D.BACKUP DATABASE while connected to the boot container

E.BACKUP PLUGGABLE database PDB1 while connected to PDB2

Question 32

You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server.
All databases of all versions use Automatic Storage Management (ASM).
Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group? (Choose three.)

A.The ASM compatibility attribute controls the format of the disk group metadata.

B.RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.

C.The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.

D.The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.

E.The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10 g database.

Correct Answer: A,B,D

Explanation/Reference:
Explanation:
AD: The value for the disk group COMPATIBLE.ASM attribute determines the minimum software version for an Oracle ASM instance that can use the disk group. This setting also affects the format of the data structures for the Oracle ASM metadata on the disk.
B: The value for the disk group COMPATIBLE.RDBMS attribute determines the minimum COMPATIBLE database initialization parameter setting for any database instance that is allowed to use the disk group.
Before advancing the COMPATIBLE.RDBMS attribute, ensure that the values for the COMPATIBLE initialization parameter for all of the databases that access the disk group are set to at least the value of the new setting for COMPATIBLE.RDBMS.
For example, if the COMPATIBLE initialization parameters of the databases are set to either 11.1 or 11.2, then COMPATIBLE.RDBMS can be set to any value between 10.1 and 11.1 inclusively.
Not E:
/The value for the disk group COMPATIBLE.ADVM attribute determines whether the disk group can contain Oracle ASM volumes. The value must be set to 11.2 or higher. Before setting this attribute, the COMPATIBLE.ASM value must be 11.2 or higher. Also, the Oracle ADVM volume drivers must be loaded in the supported environment.
/ You can create an Oracle ASM Dynamic Volume Manager (Oracle ADVM) volume in a disk group. The volume device associated with the dynamic volume can then be used to host an Oracle ACFS file system.
The compatibility parameters COMPATIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for the disk group.
Note:
* The disk group attributes that determine compatibility are COMPATIBLE.ASM, COMPATIBLE.RDBMS.
and COMPATIBLE.ADVM. The COMPATIBLE.ASM and COMPATIBLE.RDBMS attribute settings determine the minimum Oracle Database software version numbers that a system can use for Oracle ASM and the database instance types respectively. For example, if the Oracle ASM compatibility setting is 11.2, and RDBMS compatibility is set to 11.1, then the Oracle ASM software version must be at least 11.2, and the Oracle Database client software version must be at least 11.1. The COMPATIBLE.ADVM attribute determines whether the Oracle ASM Dynamic Volume Manager feature can create a volume in a disk group.

Question 33

Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not
database auditing is enabled?

A.configuration of unified auditing mode

B.creation of a fine-grained audit policy

C.execution of SQL statements by users connected with the SYSDBA privilege

D.usage of the AUDIT statement

Question 34

Examine the memory-related parameters set in the SPFILE of an Oracle database:

Which statement is true?

A.Only SGA components are sized automatically.

B.The value of the MEMORY_TARGET parameter cannot be changed dynamically.

C.Memory is dynamically re-allocated between the SGA and PGA as needed.

D.The size of the PGA cannot grow automatically beyond 500 MB.

Question 35

The HR.DEPARTMENTS table is the parent of the HR.EMPLOYEES table. The
EMPLOYEES.DEPARTMENT_ID column has a foreign key constraint with the ON DELETE CASCADE option that refers to the DEPARTMENTS.DEPARTMENT_ID column.
An index exists on the DEPARTMENTS.DEPARTMENT_ID column. A transaction deletes a primary key in the DEPARTMENTS table, which has child rows in the EMPLOYEES table.
Which statement is true?

A.Only the rows that are deleted in the DEPARTMENTS and EMPLOYEES tables are locked until the transactions on the DEPARTMENTS table is complete.

B.The transaction acquires a table lock on the DEPARTMENTS table. This lock enables other sessions to query but not update the DEPARTMENTS table until the transaction on the DEPARTMENTS table is complete.

C.The transaction acquires a table lock only on the DEPARTMENTS table until the transaction is complete.

D.The transaction acquires a table lock on the EMPLOYEES table. This lock enables other sessions to query but not update the EMPLOYEES table until the transaction on the DEPARTMENTS table is complete.

Other Version: 5240Oracle.1z0-062.v2022-06-21.q305; 37Oracle.Braindumpspass.1z0-062.v2021-09-25.by.hayden.259q.pdf

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; 155TheSecOpsGroup.CNSP.v2025-09-08.q20; 206CFAInstitute.ESG-Investing.v2025-09-08.q173; 152PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 140Salesforce.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 31

Question 32

Question 33

Question 34

Question 35

Download PDF File