Free Access Oracle.1z0-063.v2022-04-21.q171 Practice Test (Page 24)

Question 111

You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC? (Choose three.)

A.ASM disk groups with ASM disks consisting of Exadata Grid Disks.

B.ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array

C.ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files

D.Database files stored in ZFS and accessed using conventional NFS mounts.

E.Database files stored in ZFS and accessed using the Oracle Direct NFS feature

F.Database files stored in any file system and accessed using the Oracle Direct NFS feature

G.ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

Question 112

Examine the RMAN commands:

Which statement is true about the DUPLICATE command?

A.It fails because no parallel channels are allocated for the auxiliary database.

B.It succeeds only if the target database is in MOUNT state.

C.It succeeds and creates multisection backup sets that are used for active database duplication.

D.It fails because there is no connection to a recovery catalogue.

Question 113

Which three RMAN persistent settings can be set explicitly? (Choose three.)

A.redo log backup duplexing

B.controlfile autobackup formats

C.image copy duplexing

D.archivelog deletion policy

E.SPFILE backup duplexing

F.archivelog backup duplexing

Question 114

You issue the RMAN command:
RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;
Which statement is true about the execution of the command?

A.The resulting backupset has backup pieces that cannot exceed 300 MB.

B.RMAN uses multiplexing to perform the backup.

C.RMAN always performs this type of backup in parallel.

D.The backup succeeds only if the USERS tablespace is locally managed.

E.The backup set size is limited to 300 MB.

Question 115

LDAP_DIRECTORY_SYSAUTH is set to YES.
Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory (OID).
SSL has been configured for the database and OID and the password file has been configured for the database.
User scott with sysdba privilege tries to connect remotely using this command:
$sqlplusscott/tiger@DB0l As sysdba where DB01 is the net service name.
Which authentication method will be attempted first?

A.authentication by using the Oracle Internet Directory

B.authentication by password file

C.authentication by using certificates over SSL

D.authentication by using the local OS of the database server

Other Version: 2159Oracle.1z0-063.v2022-10-18.q151

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; 157PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 146Salesforce.Data-Architect.v2025-09-05.q216; 141Adobe.AD0-E605.v2025-09-05.q50

Question 111

Question 112

Question 113

Question 114

Question 115

Download PDF File