Free Download Oracle 1Z0-053 VCE Test Engine Full Version Now (331-340)

QUESTION 331
Which of the following options describes Segment Shrink?

A.    Reclaims space above and below the high-water mark without using additional space
B.    Moves rows to a new physical location, resetting the high-water mark, but uses additional space during the
operation
C.    Deallocates space above the high-water mark that is currently not in use
D.    None of the above

Answer: A

QUESTION 332
For which of the following can you use Segment Shrink? (Choose all that apply.)

A.    Heap tables
B.    Tables with function-based indexes
C.    Indexes
D.    Partitions and subpartitions
E.    None of the above

Answer: ACD

QUESTION 333
When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?

A.    INCLUDING DEPENDENCIES
B.    INCLUDING DEPENDENCIES CASCADE
C.    COMPACT
D.    CASCADE
E.    None of the above

Answer: D

QUESTION 334
Which of these represent the main components of Database Resource Manager? (Choose all that apply.)

A.    Resource consumer groups
B.    Resource plans
C.    Resource-plan groups
D.    Resource-plan directives
E.    All of the above

Answer: ABD

QUESTION 335
Every resource plan must contain an allocation to which consumer group?

A.    LOW_GROUP
B.    SYS_GROUP
C.    DEFAULT_GROUP
D.    BASE_GROUP
E.    OTHER_GROUPS

Answer: E

QUESTION 336
Which DBMS_RESOURCE_MANAGER procedure prioritizes consumer-group mappings?

A.    CREATE_MAPPING_PRIORITY
B.    SET_MAPPING_PRIORITY
C.    SET_MAPPING_ORDER
D.    PRIORITIZE_MAPPING_ORDER
E.    This functionality is not available through the DBMS_RESOURCE_MANAGER package.

Answer: B

QUESTION 337
Within a resource-plan definition, what differentiates a top-level plan from a subplan?

A.    A subplan has the PLAN_SUB parameter value set to SUB.
B.    A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in the resource-plan
definition.
C.    There is no difference in the resource-plan definition.
D.    A subplan always has the CPU_MTH parameter value set to RATIO.
E.    The string TOP_LEVEL is appended to the name of top-level resource plans.

Answer: C

QUESTION 338
When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?

A.    SET_JOB_ARGUMENT_VALUE
B.    SET_JOB_VALUE_ANYDATA
C.    SET_JOB_ANYDATA_VALUE
D.    SET_SPECIAL_JOB_VALUE
E.    SET_JOB_ANYTYPE_VALUE

Answer: C

QUESTION 339
Which DBMS_SCHEDULER procedures can be used to enable a program? (Choose all that apply.)

A.    ENABLE
B.    ENABLE_PROGRAM
C.    VALIDATE_PROGRAM
D.    SET_ATTRIBUTE
E.    SET_ENABLED

Answer: AD

QUESTION 340
Which of the following is not a valid calendaring syntax element?

A.    FREQ
B.    BYHOUR
C.    RUNDATE
D.    INTERVAL
E.    BYMINUTE

Answer: C

If you want to pass Oracle 1Z0-053 successfully, donot missing to read latest lead2pass Oracle 1Z0-053 practice exams.
If you can master all lead2pass questions you will able to pass 100% guaranteed.

http://www.lead2pass.com/1Z0-053.html