F if the existing value of the dbwriterprocesses

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: lse . D. The database instance will simulate asynchronous input/output (I/O). E. The DISK_ASYNCH_IO initialization parameter will be set to True . F. If the existing value of the DB_WRITER_PROCESSES initialization parameter is set to greater than 1, then the DB_WRITER_PROCESSES parameter will be set to 1. Actualtests.com - The Power of Knowing 1Z0-036 Answer: D,F QUESTION 88: An application executes a set of SQL scripts on a daily basis. The application makes an entry to the ERROR_ENTRY table each time a script fails. Entries in the ERROR_ENTRY table are moved to a different table after the error is resolved. You want to be notified on the Oracle Enterprise Manager (OEM) console when the application finds more than three script failures. What would you do? A. - Create an event that includes the test named "User_defined SQL Event Test." Specify the following SQL statement as the script text: SELECT COUNT(*) FROM ERROR_ENTRY;-Set the Critical Threshold value to 3. -Select the Notify check box for the appropriate username. B. - Create a report that includes the element "Table from SELECT statement." - Specify the following SQL statement as the script text: SELECT COUNT(*) FROM ERROR_ENTRY HAVING COUNT(*)>3; -Publish the report to Enterprise Manager reporting Web site. C. - Create a job that includes the task named "Run SQL*Plus Script." - Specify the following SQL statement as the script text: SELECT COUNT(*) FROM ERROR_ENTRY HAVING COUNT(*)>3; -Mark the job as a Fixit Job. D. - Create a job that is marked as Fixit Job and includes the task named "Run SQL*Plus Script." - Specify the following SQL statement as the script text for the fixit job: SELECT COUNT(*) FROM ERROR_ENTRY HAVING COUNT(*)>3; -Create an event and include the Fixit job. Answer: A QUESTION 89: Which command would you use to upgrade the kernel packages and retain the configuration files? A. rpm -v B. rpm -U C. rpm -qa D. rpm -u Answer: B QUESTION 90: What results would you expect wit...
View Full Document

Ask a homework question - tutors are online