Managing-Oracle-9i-on-Linux-(1Z0-036).pdf - Oracle 1Z0-036 Managing Oracle 9i on Linux http\/killexams.com\/exam-detail\/1Z0-036 QUESTION 131 What is the

Managing-Oracle-9i-on-Linux-(1Z0-036).pdf - Oracle 1Z0-036...

This preview shows page 1 - 4 out of 8 pages.

1Z0-036 Oracle Managing Oracle 9i on Linux
Image of page 1
QUESTION: 131 What is the command to reinitialize the kernel with new values contained in the sysctl.conf file? A. sysctl -a B. sysctl -n C. sysctl -p D. sysctl -w Answer: C QUESTION: 132 Which three statements are true about the functions of the shared memory parameters? (Choose three.) A. The shmmni parameter controls the maximum number of semaphore sets. B. The shmmni parameter controls the maximum number of shared memory segments. C. The shmall parameter controls the maximum size of each shared memory segment. D. The shmseg parameter controls the minimum number of segments that must be available to a process. E. The shmall parameter controls the maximum amount of shared memory that may be in use at any time. F. The shmseg parameter controls the maximum number of shared memory segments that can be attached to a process. Answer: B, E, F QUESTION: 133 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 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. 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 50
Image of page 2
HAVING COUNT(*)> 3; - Publish the report to Enterprise Manager reporting Web site. 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 ERROR_ENTRY; - Set the Critical Threshold value to 3. - Select the Notify check box for the appropriate username.
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 8 pages?

  • Fall '20
  • Oracle Database

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture