{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

1Z0-036 - Exam 1Z0-036 Title Managing Oracle 9i on Linux...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Exam : 1Z0-036 Title : Managing Oracle 9i on Linux Ver : 0 9 . 1 4 .06
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
1Z0-036 Actualtests.com - The Power of Knowing QUESTION 1: Which set of steps must user21a perform to schedule a cron task? A. Log in as user21a . Specify the crontab -l command. Save the cron task to the /etc/crontab file. B. Log in as root . Specify the crontab -e command. C. Log in as root . Specify the crontab -l command. Save the cron task to the /var/spool/cron/user21a file. D. Log in as user21a . Specify the crontab -e command. Answer: D QUESTION 2: Examine the following entry in the sysctl.conf file: fs.file-max = 65536 What is the significance of this entry? 65536. QUESTION 3: 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 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. B. - 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. C. - 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
Background image of page 2
1Z0-036 Actualtests.com - The Power of Knowing ERROR_ENTRY;-Set the Critical Threshold value to 3.-Select the Notify check box for the appropriate username. D. - 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. Answer: C
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

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