Free Access Oracle.1z0-062.v2022-06-21.q305 Practice Test (Page 53)

Question 256

You set the following parameters in the parameter file and restart the database instance:

Which two statements are true? (Choose two.)

A.The MEMORY_MAX_TARGETparameter is automatically set to 500 MB.

B.The PGA_AGGREGATE_TARGETand SGA_TARGETparameters are automatically set to zero.

C.The lower limits of the PGA_AGGREGATE_TARGETand SGA_TARGETparameters are set to 90 MB and 270 MB respectively.

D.The instance does not start up because Automatic Memory Management (AMM) is enabled but PGA_AGGREGATE_TARGETand SGA_TARGETparameters are set to nonzero values.

E.The value of the MEMORY_MAX_TARGETparameter remains zero for the database instance.

Question 257

In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.
Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement? (Choose two.)

A.The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

B.Setting the target tablespace to read-only

C.The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

D.Setting the target tablespace offline

E.The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

Question 258

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?

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

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 an volume in a disk group.

Question 259

You use the segment advisor to help determine objects for which space may be reclaimed.
Which three statements are true about the advisor given by the segment advisor? (Choose three.)

A.It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained
rows.

B.It may advise the use of online table redefinition for tables in dictionary managed tablespace.

C.It will detect and advise about chained rows.

D.It may advise the use of online table redefinition for tables in locally managed tablespaces

E.It may advise the use of segment shrink for free list managed tables.

Question 260

The DEFERRED_SEGMENT_CREATION parameter is set to TRUE in your database instance.
You execute the following command to create a table:

Which two statements are true?

A.A segment is allocated for the table if the ALTER TABL.. ALLOCATE EXTENT command is issued.

B.The table is created and extents are immediately allocated as per the default storage defined for its tablespace.

C.A segment is allocated when an index is created for any column in the table.

D.A segment is allocated when the first row is inserted in the table.

E.The table is created without a segment because the storage clause is missing.

Other Version: 3608Oracle.1z0-062.v2022-12-05.q411; 37Oracle.Braindumpspass.1z0-062.v2021-09-25.by.hayden.259q.pdf

Latest Upload: 103OCEG.GRCP.v2025-09-11.q211; 102HP.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; 147Salesforce.Data-Architect.v2025-09-05.q216; 141Adobe.AD0-E605.v2025-09-05.q50

Question 256

Question 257

Question 258

Question 259

Question 260

Download PDF File