Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 561:

  Evaluate the following block of code:

  

  What is the outcome of the above code?

  A. It produces an error because a fully qualified host name needs to be specified.

  B. It produces an error because the range of ports associated with the hosts has not been specified.

  C. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.

  D. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.

  Correct Answer: C

• Question 562:

  Which statement is true about a running session that belongs to the online transaction processing (OLTP) group?

  

  A. It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests or 2,500 MB of data transfer.

  B. It performs the first 10000 I/O requests or 2,500 MB of data transfer in the LOW-GROUP consumer group, and then switches to the original group.

  C. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer and returns to the original group after the operation.

  D. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer for queries, but not for data manipulation language (DML) operations.

  Correct Answer: C

  Refer to here.

  Example 2

  The following PL/SQL block creates a resource plan directive for the OLTP group that temporarily switches any session in that group to the LOW_GROUP consumer group if the session exceeds 10,000 I/O requests or exceeds 2,500

  Megabytes of data transferred. The session is returned to its original group after the offending top call is complete.

  

• Question 563:

  Which of the following objects can be directly referenced by a window object? (Choose all that apply.)

  A. Schedule object

  B. Program object

  C. Job object

  D. Resource plan

  E. Resource consumer group

  Correct Answer: AD

• Question 564:

  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

  Correct Answer: E

• Question 565:

  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.

  Correct Answer: B

• Question 566:

  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.

  Correct Answer: C

• Question 567:

  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

  Correct Answer: ABD

• Question 568:

  Which of the following describes how a distributed resumable transaction behaves?

  A. The resumable setting on the initiating session determines the resumable conditions for the entire distributed transaction.

  B. The resumable setting for the initiating instance determines the resumable conditions for the entire distributed transaction.

  C. The resumable setting on the initiating session controls only that part of the transaction that occurs within the local instance; remote resumable settings determine the behavior of the distributed parts of the transaction.

  D. None of the above.

  Correct Answer: C

• Question 569:

  Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)

  A. It can be used to allow the access privilege settings for users but not roles.

  B. It can be used to allow the access privilege settings for users as well as roles.

  C. It can be used to control the time interval for which the access privilege is available to a user.

  D. It can be used to selectively restrict the access for each user in a database to different host computers.

  E. It can be used to selectively restrict a user's access to different applications in a specific host computer.

  Correct Answer: BCD

• Question 570:

  For which two situations would you use functionality provided by the Resource Manager? (Choose two.)

  A. setting idle timeout limits on resource plans

  B. saving storage space by using compressed backup sets

  C. creating jobs that will run automatically at a scheduled time

  D. assigning priorities to jobs to manage access to system resources

  E. creating alerts to perform notification when tablespaces are low on available space resources

  Correct Answer: AD