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

Question 161

Which three operations can be performed as multipartition operations in Oracle? (Choose three.)

A.Merge partitions of a list partitioned table

B.Drop partitions of a list partitioned table

C.Coalesce partitions of a hash-partitioned global index.

D.Move partitions of a range-partitioned table

E.Rename partitions of a range partitioned table

F.Merge partitions of a reference partitioned index

Question 162

Examine the parameters:
Your database instance is started with a PFILE.

You want to increase the size of the buffer cache. Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
Which is the outcome?

A.Change is applied to the current instance, but does not persist after instance restart.

B.It fails because the SCOPE clause is missing.

C.The value is changed only in the PFILE and takes effect at the next instance startup.

D.The value is changed for the current instance and in the PFILE.

Question 163

As part of a manual upgrade of your database to Oracle Database 12c, you plan to issue the command:
SQL> STARTUP UPGRADE
Which three statements are true about the upgrade process? (Choose three.)

A.All system triggersare disabled during the upgrade process.

B.TheCOMPATIBLEparameter must be set to at least 12.1.0 before issuing the command.

C.Only connectionsAS SYSDBAare allowed during the upgrade process.

D.Only queries on fixed views execute without errors until you run thecatctl.plscript.

E.All job queues remain active duringthe upgrade process.

Question 164

Which two tasks can be performed on an external table? (Choose two.)

A.partitioning the table

B.creating an invisible index

C.updating the table by using an update statement

D.creating a public synonym

E.creating a view

Question 165

Which two statements are true about Automatic Storage Management (ASM)? (Choose two.)

A.It mounts databases and diskgroups to make ASM files available to database instances.

B.It spreads files proportionally across all disks in a diskgroup, aiming to ensure that all the disks in a diskgroup have the same I/O load.

C.It automatically places each disk from an external redundancy diskgroup in its own failure group.

D.It divides files into extents and allows an extent to span disks.

E.It mirrors data at the allocation unit (AU) level across failure groups within anormal or high redundancy diskgroup.

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

Latest Upload: 105OCEG.GRCP.v2025-09-11.q211; 105HP.HPE0-V27.v2025-09-11.q78; 120Oracle.1Z0-1057-23.v2025-09-10.q47; 156Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 136SAP.C-S4EWM-2023.v2025-09-08.q83; 171TheSecOpsGroup.CNSP.v2025-09-08.q20; 237CFAInstitute.ESG-Investing.v2025-09-08.q173; 220PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 155Salesforce.Data-Architect.v2025-09-05.q216; 149Adobe.AD0-E605.v2025-09-05.q50

Question 161

Question 162

Question 163

Question 164

Question 165

Download PDF File