Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 551:

  You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os.

  Which statement describes a solution to the above?

  A. Set a threshold for the default system-defined moving window baseline.

  B. Add directives to the Automatic Database Diagnostic Monitor (ADDM).

  C. Modify the profile for the targeted users for which control needs to be imposed.

  D. Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.

  Correct Answer: D

• Question 552:

  View the Exhibit to examine the parameters set for your database instance. You execute the following command to perform I/O calibration after the declaration of bind variables in the session that are used in the command:

  SQL> EXECUTE dbms_resource_manager.calibrate_io(

  num_physical_disks=>1,

  max_latency=>50,

  max_iops=>:max_iops,

  max_mbps=>:max_mbps,

  actual_latency=>:actual_latency);

  Which statement describes the consequence?

  Exhibit:

  

  A. The command produces an error.

  B. The calibration process runs successfully and populates all the bind variables.

  C. The calibration process runs successfully but the latency time is not computed.

  D. The calibration process runs successfully but only the latency time is computed.

  Correct Answer: A

  Requisition of Calibrate I/O (link)

  Before running I/O calibration, ensure that the following requirements are met:

  The user must be granted the SYSDBA privilege

  timed_statistics must be set to TRUE

  Asynchronous I/O must be enabled

  When using file systems, asynchronous I/O can be enabled by setting the FILESYSTEMIO_OPTIONS initialization parameter to SETALL. Ensure that asynchronous I/O is enabled for data files by running the following query:

  COL NAME FORMAT A50

  SELECT NAME,ASYNCH_IO FROM V$DATAFILE F,V$IOSTAT_FILE I WHERE F.FILE#=I.FILE_NO

  AND FILETYPE_NAME='Data File';

  Additionally, only one calibration can be performed on a database instance at a time.

• Question 553:

  Which three statements correctly describe the features of the I/O calibration process? (Choose three.)

  A. Only one I/O calibration process can run at a time.

  B. It automates the resource allocation for the Automated Maintenance Tasks.

  C. It improves the performance of the performance-critical sessions while running.

  D. It can be used to estimate the maximum number of I/Os and maximum latency time for the system.

  E. The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE.

  Correct Answer: ADE

• Question 554:

  You upgraded Oracle Database 10g to Oracle Database 11g. How would this affect the existing users' passwords?

  A. All passwords automatically become case-sensitive.

  B. All passwords remain non-case-sensitive till they are changed.

  C. All passwords remain non-case-sensitive and cannot be changed.

  D. All passwords remain non-case-sensitive until their password attribute in the profile is altered.

  Correct Answer: B

• Question 555:

  You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time.

  How would you accomplish this task?

  A. Set metric threshold

  B. Implement Database Resource Manager

  C. Enable resumable timeout for user sessions

  D. Add directives to Automatic Database Diagnostic Monitor (ADDM)

  Correct Answer: B

• Question 556:

  View the Exhibit and examine the steps that you executed to create a database resource plan.

  Subsequently, you execute the following procedure which results in an error: SQL> EXECUTE dbms_resources_manager.validate_pending_area ( ); What could be the reason?

  

  A. The pending area is automatically submitted after the plan creation

  B. The procedure must be executed before creating the resources plan directive

  C. The SYS_GROUP resource consumer group is not included in the resource plan directive

  D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

  Correct Answer: D

• Question 557:

  Your database initialization parameter file has the following entry:

  SEC_MAX_FAILED_LOGIN_ATTEMPTS=3

  Which statement is true regarding this setting?

  A. It drops the connection after the specified number of login attempts fail for any user.

  B. It is enforced only if the password profile is enabled for the user.

  C. It locks the user account after the specified number of attempts.

  D. It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.

  Correct Answer: A

• Question 558:

  View the exhibit and examine the output. Which statement can be an inference from the output? Exhibit:

  

  A. The FRA disk group has an asynchronous I/O bottleneck

  B. The least number of I/Os are performed on the last data file in the list

  C. The number of times that the backup or restore process directed the OS to wait until an I/O was complete is the highest for the last data file in the list

  D. The number of times that the backup or restore process made an OS call to poll for I/O completion in Nonblocking mode is the least for the FRA disk group

  Correct Answer: A

• Question 559:

  You observed the following output for a user session:

  

  What do you infer from the preceding output?

  A. Resumable set for session with sid 18

  B. The user session has entered into a deadlock

  C. The database instance is enabled to use asynchronous commit

  D. The threshold warning limit is exceeded for the tablespace that is used by the user session

  Correct Answer: A

• Question 560:

  The database users regularly complain about the difficulty in performing transactions. On investigation, you find that some users perform long-running transactions that consume huge amounts of space in the undo tablespace, which caused the problem. You want to control the usage of the undo tablespace only for these user sessions and you do not want these sessions to perform long-running operations.

  How would you achieve this?

  A. Implement a profile for the users.

  B. Implement external roles for the users.

  C. Set the threshold for the undo tablespace.

  D. Implement a Database Resource Manager plan.

  Correct Answer: B