testking oracle 9i 1z0-036
Visited 582 times, 1 so far today
Exam 1z0-036: Managing Oracle9i on Linux
Exam Number: 1Z0-036
Associated Certifications: Managing Oracle9i on Linux OCP Special Accreditation
Exam Price: $125.00 USD
Exam Registration: Register
Duration: 120 minutes
Number of Questions: 59
Passing Score: 57%
Recommended Training and Preparation
Managing Oracle on Linux
Additional Information & Resources
View a list of additional preparation resources
Managing Oracle9i on LinuxSpecial Accreditation Candidate Guide
Exam Retake Policy
Exam Topics
Oracle9i on Linux: Overview
[ ] Choose a supported Linux distribution and version
[ ] Choose the proper Oracle database versions
[ ] Identify Enterprise Linux level distributions
Preparing the Operating System
[ ] Implement a dynamic shared memory
[ ] Configure the OS kernel
[ ] Install required OS patches
[ ] Configure the Linux network
[ ] Configure the X Window System
Installing Oracle9i Software
[ ] Create the OS user oracle
[ ] Configure the Oracle9i OS environment
[ ] Install Oracle9i software and Create a General Purpose database with OUI
Creating a Custom Oracle9i Database
[ ] Create a custom Oracle9i database
[ ] Configure and start Oracle Net components
[ ] Test the Oracle9i components
Installing and Configuring Enterprise Manager
[ ] Configure Oracle Management Server (OMS)
[ ] Discover Oracle9i databases and nodes
[ ] Configure the HTTP server and Enterprise Manager Reporting
[ ] Configure and test jobs and events by using Oracle Enterprise Manager
Customizing the Oracle9i Database
[ ] Automate tasks using scheduling tools
[ ] Configure Linux startup and shutdown sequence
[ ] Create automated startup/shutdown scripts
Using Linux Measurement Tools
[ ] Identify and use basic measurement tools
[ ] Measure the CPU load
[ ] Gather and interpret memory usage statistics
[ ] Gather and interpret I/O load statistics
[ ] Collect and interpret network activity statistics
Using Oracle9i Measurement Tools
[ ] Use Statspack with OS tools
[ ] Use Oracle Enterprise Manager tools with OS tools
[ ] Configure System Global Area (SGA) and Program Global Area (PGA) and measure usage
Tuning Oracle9i and Linux
[ ] Evaluate file systems
[ ] Tune supported file systems
[ ] Configure initialization parameters
[ ] Implement asynchronous I/O
[ ] Implement advanced memory management techniques
Oracle Certification Program Fraudulent Activity Policy
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.
If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate’s Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate’s employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle’s authorized vendors, and may be required to pay additional fees for services rendered.
View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.
Recommended Training about 1z0-036 exam PDF
The following courses are the recommended training for 1z0-036 exam PDF.
1z0-036 Q & A with Explanations
1z0-036 Audio Exam
1z0-036 Study Guide
1z0-036 Preparation Lab
1z0-036 Exam: Freetestking’s Managing Oracle9i on linux PDF
The Managing Oracle9i on linux PDF for preparing for the 1z0-036 exam – Freetestking’s Managing Oracle9i on linux. Freetestking is your premier source for practice tests, and true testing environment. Nothing will prepare you for your next exam like a Freetestking. You find it all here at certbible.org.
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?
A. The entry sets the maximum number of open files for each process to 65536.
B. The entry sets the maximum number of files in the operating system (OS) file system
to 65536.
C. The entry sets the maximum number of background processes of the Oracle database
to 65536.
D. The entry sets the maximum number of subprocesses that a process can spawn to
65536. Answer: A
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
TK
1Z0-036
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
QUESTION 4:
You are creating a database using Database Configuration Assistant (DBCA). You need
to save the SQL scripts that are being used to create the database. Which set of options would you select?
A. Choose the “New Database” template and select the “Generate Database Creation
Scripts” option while creating the database
B. Enable SQL tracing for the DBCA session
C. Create the database using the “General Purpose” template and then create a new template from the existing database
D. Choose the “General Purpose” template and select the “Save as a Database Template”
option while creating the database
E. Choose the “New Database” template and select the “Save as a Database Template”
option while creating the database
Answer: A
QUESTION 5:
You need to enable the use of the extended buffer cache mechanism for 32-bit platforms that can support more than 4 GB of physical memory. Which three are steps that you
would take? (Choose three.)
A. Verify whether BUFFER_POOL_KEEP is not set. B. Verify that DB_CACHE_SIZE is not set.
C. Set WORKAREA_SIZE_POLICY to AUTO .
D. Verify whether BUFFER_POOL_RECYCLE is not set. E. Set USE_INDIRECT_DATA_BUFFERS to True .
F. Set the database buffer cache size with DB_BLOCK_BUFFERS . Answer: B,E,F
QUESTION 6:
A Linux distribution consists of _____.
TK
1Z0-036
A. depots and binaries
B. kernel and depots
C. kernel and shared objects
D. dynamic link libraries (DLLs) and executables
E. packages and kernel
F. packages and libraries
Answer: E
QUESTION 7:
Which command is used to identify the kernel version number? A. ulimit ulimit ?
B. chkconfig
C. uname uname ? D. which
E. whatis
Answer: C
QUESTION 8:
You need to minimize the possibility of unauthorized access to the database files through
Oracle HTTP Server. What would you do?
A. Run Oracle HTTP Server as a user who is a member of the dba group. B. Run Oracle HTTP Server as user root .
C. Run Oracle HTTP Server as a user with minimal privileges. D. Run Oracle HTTP Server in secure socket mode.
E. Run Oracle HTTP Server as a user with the oinstall group as its primary group.
F. Run Oracle HTTP Server as user oracle . Answer: C
QUESTION 9:
You want to view extended statistics of input/output (I/O) activity by partition. However, you want to suppress CPU statistics. Which command would you use to display 10
reports at 2-second intervals?
A. iostat -x 2 10
B. iostat -d -x 2 10
C. vmstat 2 10
D. sar -d 2 10
E. iostat -d 2 10 -x
TK
1Z0-036
Answer: B
QUESTION 10:
Which two statements are correct about the DB_WRITER_PROCESSES initialization parameter? (Choose two.)
A. The default value for DB_WRITER_PROCESSES is (CPU_COUNT+7)/8 .
B. You must set an appropriate value for the LOG_PARALLELISM initialization parameter before modifying the default value for DB_WRITER_PROCESSES .
C. You cannot set DB_WRITER_PROCESSES to greater than one if asynchronous I/O is enabled for the Oracle server.
D. You set DB_WRITER_PROCESSES to greater than one to simulate asynchronous input/output (I/O) .
E. You cannot set DB_WRITER_PROCESSES to greater than one if the
DBWR_IO_SLAVES initialization parameter is set to greater than zero. Answer: A,E
QUESTION 11:
What results would you expect with the netstat -sp command?
A. list of remote systems that have TCP connections with the local system
B. speed of transfer of packets
C. comparison of TCP values between runs
D. sources of TCP traffic
E. TCP statistics
Answer: E
QUESTION 12:
Which three initialization parameters should you set to enable asynchronous input/output
(I/O) for raw devices, file system files, and sequential devices? (Choose three.)
A. FILESYSTEMIO_OPTIONS = asynch
B. FILESYSTEMIO_OPTIONS = directIO C. TAPE_ASYNCH_IO = True
D. OPEN_LINKS = 10
E. DISK_ASYNCH_IO = True
F. BACKUP_TAPE_IO_SLAVES = True
G. FILE_MAPPING = False
Answer: A,C,E
Interactive Testing 9i 1z0-036 Engine Included!
144 Questions
Updated : 09/18/2008
Price : $87.99 $79.99
Exam Number/Code:1z0-036
Exam Name: Managing Oracle9i on linux
Testking 1z0-036 Exam will provide you with exam simulation questions and actual answers that reflect the actual exam
Preparing for the Testking 1z0-036 exam?Searching 1z0-036 Test Questions,
1z0-036 Practice Exam,1z0-036 Braindumps ? 1z0-036 practice exam covers all
the practice test objectives to pass 1z0-036 exam.
Pass your exam at first attempt with our Testking 1z0-036 study guide,1z0-036 Braindumps, As well Audio exam, Realistic
Practice Labs, and Interactive Testing Engine.
Our Testking practice test covers the information associated with each 1z0-036 exam topics in details and includes
information found in no other practice test sites on the web.
Our challenging questions with Correct Answers built to simulate the actual exam. Unlimited, FREE auto-updates so you’re
never behind on any topic. The whole package comes as an automatic download so there’s no waiting or shipping. Our most
questions and answers along with explanations. Our practice test will determine you to take your 1z0-036 certification exam
and pass the official exam on your first try, guaranteed
Now guaranteed Testking 1z0-036 exam training is available in various formats to best suit your needs and learning style.
Whether you are a hands-on tactile learner, visually or even a textbook training veteran, Real-Exams has the 1z0-036 pdf vce
format resources that will enable you to pass your 1z0-036 test with flying colors.
Comprehensive questions with complete explanations about actualtests 1z0-036 exam
download 1z0-036 exam questions accompanied by exhibits
Verified Answers Researched by Industry Experts and almost 100% correct
1z0-036 exam questions updated on regular basis
Oracle 1z0-036 Transcender Torrent
Oracle 1z0-036 P4S
Oracle 1z0-036 Study Guide
Oracle 1z0-036 Exams
Oracle 1z0-036 Braindumps
Oracle 1z0-036 Pass4sure
Oracle 1z0-036 Real Exams
Oracle 1z0-036 Exam
Oracle 1z0-036 Actual Tests
Oracle 1z0-036 Pdf
1z0-036 also gives new editions of Real Exams 1z0-036 for enhancing professional skills and knowledge. These Testking Real Practice Questions 000-
710 are useful for understanding 1z0-036 exam terminologies and these brain dumps also very useful for enhancing people brain
power. These Testking Real Practice Questions 1z0-036 are prepare by highly qualified and 1z0-036 professionals. 1z0-036 Certification experts’
teams always try to give you real exam environment in these 4shared training materials links.
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?
A. The entry sets the maximum number of open files for each process to 65536.
B. The entry sets the maximum number of files in the operating system (OS) file system
to 65536.
C. The entry sets the maximum number of background processes of the Oracle database
to 65536.
D. The entry sets the maximum number of subprocesses that a process can spawn to
65536.
Answer: A
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
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
QUESTION 4:
You are creating a database using Database Configuration Assistant (DBCA). You need
to save the SQL scripts that are being used to create the database. Which set of options
would you select?
A. Choose the “New Database” template and select the “Generate Database Creation
Scripts” option while creating the database
B. Enable SQL tracing for the DBCA session
C. Create the database using the “General Purpose” template and then create a new
template from the existing database
D. Choose the “General Purpose” template and select the “Save as a Database Template”
option while creating the database
E. Choose the “New Database” template and select the “Save as a Database Template”
option while creating the database
Answer: A
QUESTION 5:
You need to enable the use of the extended buffer cache mechanism for 32-bit platforms
that can support more than 4 GB of physical memory. Which three are steps that you
would take? (Choose three.)
A. Verify whether BUFFER_POOL_KEEP is not set.
B. Verify that DB_CACHE_SIZE is not set.
C. Set WORKAREA_SIZE_POLICY to AUTO .
D. Verify whether BUFFER_POOL_RECYCLE is not set.
E. Set USE_INDIRECT_DATA_BUFFERS to True .
F. Set the database buffer cache size with DB_BLOCK_BUFFERS .
Answer: B,E,F
QUESTION 6:
A Linux distribution consists of _____.
A. depots and binaries
B. kernel and depots
C. kernel and shared objects
D. dynamic link libraries (DLLs) and executables
E. packages and kernel
F. packages and libraries
Answer: E
QUESTION 7:
Which command is used to identify the kernel version number?
A. ulimit ulimit ?
B. chkconfig
C. uname uname ?
D. which
E. whatis
Answer: C
QUESTION 8:
You need to minimize the possibility of unauthorized access to the database files through
Oracle HTTP Server. What would you do?
A. Run Oracle HTTP Server as a user who is a member of the dba group.
B. Run Oracle HTTP Server as user root .
C. Run Oracle HTTP Server as a user with minimal privileges.
D. Run Oracle HTTP Server in secure socket mode.
E. Run Oracle HTTP Server as a user with the oinstall group as its primary group.
F. Run Oracle HTTP Server as user oracle .
Answer: C
QUESTION 9:
You want to view extended statistics of input/output (I/O) activity by partition. However,
you want to suppress CPU statistics. Which command would you use to display 10
reports at 2-second intervals?
A. iostat -x 2 10
B. iostat -d -x 2 10
C. vmstat 2 10
D. sar -d 2 10
E. iostat -d 2 10 -xAnswer: B
QUESTION 10:
Which two statements are correct about the DB_WRITER_PROCESSES initialization
parameter? (Choose two.)
A. The default value for DB_WRITER_PROCESSES is (CPU_COUNT+7)/8 .
B. You must set an appropriate value for the LOG_PARALLELISM initialization
parameter before modifying the default value for DB_WRITER_PROCESSES .
C. You cannot set DB_WRITER_PROCESSES to greater than one if asynchronous I/O is
enabled for the Oracle server.
D. You set DB_WRITER_PROCESSES to greater than one to simulate asynchronous
input/output (I/O) .
E. You cannot set DB_WRITER_PROCESSES to greater than one if the
DBWR_IO_SLAVES initialization parameter is set to greater than zero.
Answer: A,E
QUESTION 11:
What results would you expect with the netstat -sp command?
A. list of remote systems that have TCP connections with the local system
B. speed of transfer of packets
C. comparison of TCP values between runs
D. sources of TCP traffic
E. TCP statistics
Answer: E
QUESTION 12:
Which three initialization parameters should you set to enable asynchronous input/output
(I/O) for raw devices, file system files, and sequential devices? (Choose three.)
A. FILESYSTEMIO_OPTIONS = asynch
B. FILESYSTEMIO_OPTIONS = directIO
C. TAPE_ASYNCH_IO = True
D. OPEN_LINKS = 10
E. DISK_ASYNCH_IO = True
F. BACKUP_TAPE_IO_SLAVES = True
G. FILE_MAPPING = False
Answer: A,C,E
Testking 1z0-036
TK Questions&Answers(Q & As with Expert Explanations): 144 Q&A
Update: 31/07/2008
Free Down: Testking 1z0-036
Free Down: Pass4sure 1z0-036
Dowload PassGuide Practice Test Questions



6 Comments on “testking oracle 9i 1z0-036”