Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 571:

  You installed Oracle Database 11g at fresh.

  Which statements are true regarding the default audit settings in this database? (Choose all that apply.)

  A. The audit trail is stored in an operating system file.

  B. Auditing is disabled for all privileges.

  C. The audit trail is stored in the database.

  D. Auditing is enabled for all privileges.

  E. Auditing is enabled for certain privileges related to database security.

  Correct Answer: CE

• Question 572:

  The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task.

  What is the reason for this?

  A. to prevent the creation of an excessive number of scheduler job classes

  B. to allow the Automated Maintenance Tasks to use system resources without any restriction

  C. to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window

  D. to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources

  Correct Answer: D

  Oracle Database Resource Manager (the Resource Manager) is an infrastructure that provides granular control of database resources allocated to users, applications, and services. The Resource Manager solves many resource allocation problems that an operating system does not manage well, including:

  Excessive overhead Inefficient scheduling Inappropriate allocation of resources Inability to manage database-specific resources

  The Resource Manager helps overcome these problems by giving the database more control over allocation of hardware resources and enabling you to prioritize work within the database. You can classify sessions into groups based on session attributes, and then allocate resources to these groups to optimize hardware utilization.

• Question 573:

  To control the execution of a server process when it is receiving bad packets from a potentially malicious client, you set the SEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter as follows: SQL> ALTER SYSTEM SET SEC_PROTOCOL_ERROR_FURTHER_ACTION = Drop,10;

  What is the significance of this setting?

  A. It terminates the client connection after 10 bad packets and the client cannot reconnect to the same instance.

  B. It terminates the client connection after 10 bad packets but the client can still reconnect, and attempt the same operation again.

  C. It terminates the client connection 10 seconds after receiving a bad packet and the client cannot reconnect to the same instance.

  D. It terminates the client connection after receiving a bad packet and the client can reconnect to the same instance after 10 minutes.

  Correct Answer: B

• Question 574:

  View the Exhibit to examine the error obtained during the I/O calibration process. There are no data files on raw devices. What is the reason for this error?

  

  A. The DISK_ASYNCH_IO parameter is set to TRUE.

  B. The FILESYSTEMIO_OPTIONS parameter is set to NONE.

  C. Another session runs the I/O calibration process concurrently.

  D. The pending area has not been created before running the I/O calibration process.

  Correct Answer: B

  9.1.1.2 FILESYSTEMIO_OPTIONS Initialization Parameter You can use the FILESYSTEMIO_OPTIONS initialization parameter to enable or disable asynchronous I/O or direct I/O on file system files. This parameter is platform-specific and has a default value that is best for a particular platform.

  FILESYTEMIO_OPTIONS can be set to one of the following values:

  ASYNCH: enable asynchronous I/O on file system files, which has no timing requirement for transmission.

  DIRECTIO: enable direct I/O on file system files, which bypasses the buffer cache. SETALL: enable both asynchronous and direct I/O on file system files. NONE: disable both asynchronous and direct I/O on file system files. To enable asynch

  I/O, set two values in the init.ora file (or spfile) and recycle the instances:

  disk_asynch_io = true

  filesystemio_options = asynch

  The first one is default; so you may not have to change it. The default of the second one is NONE; so you will probably have to change it. After setting these values and recycling the instance,

• Question 575:

  View the Exhibit and examine the resource consumption details for the current plan in use by the database instance. Which two statements are true based on the output? (Choose two.) Exhibit:

  

  A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an error

  B. A user belonging to DSS_QUERIES can log in to a new session but the session will be queued

  C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management

  D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management, I/O waits, and latch or enqueue contention

  Correct Answer: BC

  V$RSRC_CONSUMER_GROUP Use the V$RSRC_CONSUMER_GROUP view to monitor resources consumed, including CPU, I/O, and parallel servers. It can also be used to monitor statistics related to CPU resource management, runaway query management, parallel statement queuing, and so on. All of the statistics are cumulative from the time when the plan was activated.

  SELECT name, active_sessions, queue_length, consumed_cpu_time, cpu_waits, cpu_wait_time FROM v$rsrc_consumer_group;

  

  In the preceding query results, the DSS_QUERIES consumer group has four sessions in its active session pool and two more sessions queued for activation.

  A key measure in this view is CPU_WAIT_TIME. This indicates the total time that sessions in the consumer group waited for CPU because of resource management. Not included in this measure are waits due to latch or enqueue contention, I/O waits, and so on.

• Question 576:

  You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package. Which statement is true regarding the ACL created?

  A. It is a list of remote database links stored in the XML file that are available to the users of the database.

  B. It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts.

  C. It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts.

  D. It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.

  Correct Answer: B

  The DBMS_NETWORK_ACL_ADMIN package provides the interface to administer the network Access Control List (ACL).

  Refer to here for About Fin-Grained Access to External Network Services Configuring fine- grained access control for users and roles that need to access external network services from the database. This way, specific groups of users can connect to one or more host computers, based on privileges that you grant them. Typically, you use this feature to control access to applications that run on specific host addresses. To configure fine-grained access control to external network services, you create an access control list (ACL), which is stored in Oracle XML DB. You can create the access control list by using Oracle XML DB itself, or by using the

  DBMS_NETWORK_ACL_ADMIN and DBMS_NETWORK_ACL_UTILITY PL/SQL packages. This guide explains how to use these packages to create and manage the access control list. To create an access control list by using Oracle XML DB and for general conceptual information about access control lists, see Oracle XML DB Developer's Guide.

• Question 577:

  Which statement is true about a Scheduler-generated event?

  A. It can be generated when a file arrives on the file system.

  B. it indicates state changes that occur within the Scheduler itself.

  C. it is raised by an application that is consumed by the Scheduler to start a job.

  D. it requires jobs to be defined with an event condition and a queue specification.

  Correct Answer: D

  Consuming Job State Events with your Application

  To consume job state events, your application must subscribe to the Scheduler event queue SYS.SCHEDULER$_EVENT_QUEUE. This queue is a secure queue and is owned by SYS. To create a subscription to this queue for a user, do the following:

  1.

  Log in to the database as the SYS user or as a user with the MANAGE ANY QUEUE privilege.

  2.

  Subscribe to the queue using a new or existing agent.

  3.

  Run the package procedure DBMS_AQADM.ENABLE_DB_ACCESS as follows:

  DBMS_AQADM.ENABLE_DB_ACCESS(agent_name, db_username); where agent_name references the agent that you used to subscribe to the events queue, and db_username is the user for whom you want to create a subscription.

  There is no need to grant dequeue privileges to the user. The dequeue privilege is granted on the Scheduler event queue to PUBLIC.

• Question 578:

  You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation.

  The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system.

  How would you create these jobs?

  A. Create both jobs by using events raised by the scheduler

  B. Create both jobs by using events raised by the application

  C. Create a job to rebuild indexes by using events raised by the application and then create another job to perform bulk load by using events raised by the scheduler

  D. Create a job to rebuild indexes by using events raised by the Scheduler and then create another job to perform bulk load by using events raised by the application

  Correct Answer: D

  The bulk load operation can be done by setting up a file watcher, then raise the event to inform the scheduler, it is kind of application based event. After the bulk load job, you can use Scheduler raised event, e.g. JOB COMPLETE, to fire the index rebuild job.

  There are two kinds of events consumed by the Scheduler:

  Events raised by your application An application can raise an event to be consumed by the Scheduler. The Scheduler reacts to the event by starting a job. For example, when an inventory tracking system notices that the inventory has gone below a certain threshold, it can raise an event that starts an inventory replenishment job.

  See "Starting Jobs with Events Raised by Your Application".

  File arrival events raised by a file watcher You can create a file watcher--a Scheduler object introduced in Oracle Database 11g Release 2 --to watch for the arrival of a file on a system. You can then configure a job to start when the file watcher detects the presence of the file. For example, a data warehouse for a chain of stores loads data from end-of-day revenue reports uploaded from the point-of-sale systems in the stores. The data warehouse load job starts each time a new end-of-day report arrives.

• Question 579:

  The user SYS creates a job by using the following command:

  BEGIN

  DBMS_SCHEDULER.CREATE_JOB (

  job_name => 'update_sales',

  job_type => 'STORED-PROCEDURE',

  job_action => 'OPS.SALES_PKG.UPDATE_SALES_SUMMARY',

  start_date => '28-DEC-07 07.00.00 PM Australia/Sydney', repeat_interval => 'FREQ=DAILY;

  INTERVAL=2',

  end_date => '20-JAN-08 07.00.00 PM Australia/Sydney', comments => 'New sales job');

  END;

  /

  Which two statements are true about the job that was created by the preceding command? (Choose two.)

  A. The job is enabled by default after creation

  B. The job is automatically dropped after the end date

  C. The job executes with the privileges of the user SYS

  D. The globalization environment that exists at the time of the job creation prevails at the job runs

  Correct Answer: BC

  By default, jobs are created with auto_drop set to TRUE. end_date This attribute specifies the date and time after which the job expires and is no longer run. After the end_date, if auto_drop is TRUE, the job is dropped. If auto_drop is FALSE, the job is disabled and the STATE of the job is set to COMPLETED. If no value for end_date is specified, the job repeats forever unless max_runs or max_failures is set, in which case the job stops when either value is reached. The value for end_date must be after the value for start_date. If it is not, an error is generated when the job is enabled.

• Question 580:

  Which of the following are not disabled by default?

  A. Jobs

  B. Chains

  C. Windows

  D. Window groups

  E. Schedule

  Correct Answer: E