11i Applications DBA Fundamentals II : 1z0-236 Exam
Exam Number: 1Z0-236
Associated Certifications: Oracle 11i Applications DBA
Exam Price: $195 USD
Exam Registration: Register

Duration: 120 minutes
Number of Questions: 66
Passing Score: 72%
Recommended Training and Preparation
Oracle9i Database Administration Fundamentals II
Oracle9i Database Performance Tuning

Additional Information & Resources
Oracle 11i Application Developer DBA Candidate Guide
Exam Retake policies
Exam Topics
Overview of Tuning
[ ]
Describe the dependency between tuning in different development phases

[ ]
Describe appropriate tuning goals

[ ]
Describe the most common tuning problems

Diagnostic and Tuning Tools
[ ]
Describe how the alert.log file is used

[ ]
Describe the statistics kept in the dynamic performance views

[ ]
Collect statistics using StatsPack

[ ]
Use other tuning tools

Database Configuration and I/O Issues
[ ]
Diagnose tablespace usage problems

[ ]
Describe how checkpoints work

[ ]
Monitor and tune checkpoints

[ ]
Monitor and tune redo logs

Tuning the Shared Pool
[ ]
Measure and tune the library cache hit ratio

[ ]
Measure and tune the dictionary cache hit ratio

[ ]
Size and pin objects in the shared pool

[ ]
Tune the shared pool reserved space

[ ]
Describe the user global area (UGA) and session memory considerations

[ ]
Explain other tuning issues related to the shared pool

Tuning the Buffer Cache
[ ]
Describe how the buffer cache is used by different Oracle processes

[ ]
Describe the tuning issues related to the buffer cache

[ ]
Monitor the use of buffer cache, and the different pools within buffer cache

[ ]
Implement dynamic SGA allocation

[ ]
Set the DB_CACHE_ADVICE parameter

[ ]
Create and size multiple buffer pools

[ ]
Detect and resolve free list contention

Sizing Other SGA Structures
[ ]
Monitor and size the redo log buffer

[ ]
Monitor and size the java pool

Optimizing Sort Operations
[ ]
Identify the SQL operations which require sorts

[ ]
Create and monitor temporary tablespaces

[ ]
Reduce total sorts and disk sorts

SQL Statement Tuning
[ ]
Describe how the Optimizer is used

[ ]
Use stored outlines

[ ]
Use SQL Trace and TKPROF

[ ]
Collect statistics on indexes and tables

[ ]
Copy statistics between databases

Using Oracle Blocks Efficiently
[ ]
Describe the correct usage of extents and Oracle blocks

[ ]
Explain space usage and the high-water mark

[ ]
Recover space from sparsely populated segments

[ ]
Describe and detect chaining and migration of Oracle blocks

[ ]
Perform index reorganization

[ ]
Monitor indexes to determine usage

Application Tuning
[ ]
Explain the different types of indexes

[ ]
Describe materialized views and the use of query rewrites

Resolving Locking Issues
[ ]
Define levels of locking

[ ]
List possible causes of contention

[ ]
Use Oracle utilities to detect lock contention

[ ]
Resolve contention in an emergency

[ ]
Prevent locking problems

Backup and Recovery Overview
[ ]
Describe the basics of database backup, restore and recovery

[ ]
List the types of failure that may occur in an Oracle environment

[ ]
Define a backup and recovery strategy

Instance and Media Recovery Structures
[ ]
Identify the importance of checkpoints, redo log files, and archived log files

Configuring the Database Archiving Mode
[ ]
Describe the differences between Archivelog and Noarchivelog modes

[ ]
Configure a database for Archivelog mode

[ ]
Enable automatic archiving

User-Managed Backups
[ ]
Describe user-managed backup and recovery operations

[ ]
Perform closed database backups

[ ]
Perform open database backups

[ ]
Back up the control file

User-Managed Complete Recovery
[ ]
Perform recovery in Noarchivelog mode

[ ]
Perform complete recovery in Archivelog mode

[ ]
Restore datafiles to different locations

[ ]
Relocate and recover a tablespace by using archived redo logfiles

[ ]
Describe read-only tablespace recovery

User-Managed Incomplete Recovery
[ ]
Describe the steps of incomplete recovery

[ ]
Perform an incomplete database recovery

[ ]
Identify the loss of current online redo log files

Transporting Data Between Databases
[ ]
Describe the uses of the Export and Import utilities

[ ]
Describe Export and Import concepts and structures

[ ]
Perform simple Export and Import operations

Loading Data into a Database
[ ]
Demonstrate usage of direct-load insert operations

[ ]
Describe the usage of SQL*Loader

[ ]
Perform basic SQL*Loader operations

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-236 exam PDF
The following courses are the recommended training for 1z0-236 exam PDF.
1z0-236 Q & A with Explanations
1z0-236 Audio Exam
1z0-236 Study Guide
1z0-236 Preparation Lab
1z0-236 Exam: Freetestking’s 11i Applications DBA Fundamentals II PDF
The 11i Applications DBA Fundamentals II PDF for preparing for the 1z0-236 exam – Freetestking’s 11i Applications DBA Fundamentals II. 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
You plan to perform a backup of the control file in your database. Which two statements regarding the control file backup are true? (Choose two.)

A. You can back up the control file to a binary file.
B. You must bring the database to the NOMOUNT state to perform the control file backup. C. You must store all types of control file backups in the location defined by
USER_DUMP_DEST.
D. You can back up the control file by generating a script that can be used to re-create the control file.
Answer: A, D Question: 2
Which type of lock is held by SQL statements and PL/SQL objects in the Library Cache?

A. breakable parse locks
B. row-level (TX type) lock
C. table-level manual locks
D. table-level (TM type) locks
Answer: A Question: 3
In an online transaction processing (OLTP) system, which is configured in shared server mode, you execute the following query to examine the sort performance:

SQL> SELECT d.value “Disk”, m.value “Mem”, (d.value/m.value)*100 “Ratio” FROM v$sysstat m, v$sysstat d
WHERE m.name=’sorts (memory)’ and d.name=’sorts (disk)’; Disk Mem Ratio
———- ———- ————-
23 206 11.165049
What action would you take after observing the output? A. increase the value of SORT_AREA_SIZE
B. increase the size of the temporary tablespace
C. increase the value of PGA_AGGREGATE_TARGET
D. no action required because the ratio is perfect for an OLTP system
Answer: A Question: 4
Users complain of slow response time in your online transaction processing (OLTP) system. You compare current statistics with baseline statistics. You notice that in the current statistics library
cache, the hit ratio has decreased and there are request misses for shared pool reserved are
a. Given below are the sizes of shared pool and shared pool reserved area: SHARED_POOL_SIZE = 500 MB
SHARED_POOL_RESERVED_SIZE = 50 MB
What kind of strategy would you suggest for performance tuning? A. increase the size of only the shared pool
B. decrease the size of the shared pool reserved area

TK

Exam Name: 11i Applications DBA Fundamentals II
Exam Type Oracle
Exam Code: 1z0-236 Total Questions: 114

C. increase the size of only the shared pool reserved area
D. increase the sizes of both the shared pool and the shared pool reserved area
E. increase the size of the shared pool and decrease the size of the shared pool reserved area
Answer: D Question: 5
You are working in an OLTP environment. You wish to reduce the virtual memory requirements for the Oracle instance due to Operating system paging or swap overheads. You need to
determine whether the buffer cache is oversized and could tolerate being reduced. In which two
cases can you afford to reduce the buffer cache size? (Choose two.)

A. if the cache hit ratio is very high
B. if there are no waits for free buffers
C. if the rate of physical I/O is very high
D. if the number of full table scans is very low
E. if the number of index accesses is very high
Answer: A, B Question: 6
When starting up the test database, you encounter the following error after mounting the database:

ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: ‘/u01/oracle/app/oradata/log2.log’ ORA-27037: unable to obtain file status

While investigating the reason, you find that the status of the redo log group 2 is CURRENT. Which type of recovery would you perform to ensure that the database is functional?

A. Open Database recovery
B. Time-Based incomplete recovery
C. recovery using the backup control file
D. Cancel-Based incomplete recovery
E. Change-Based incomplete recovery
Answer: D Question: 7
What provides the information about the free extents in a temporary tablespace before a sort operation?

A. LRU chain
B. sort extent pool
C. resource free list
D. free extent table (FET$) E. used extent table (UET$)
Answer: B Question: 8
What action can you take to reduce the recovery time in case of instance failures?

A. use an SPFILE

TK

Exam Name: 11i Applications DBA Fundamentals II
Exam Type Oracle
Exam Code: 1z0-236 Total Questions: 114

B. multiplex the control files
C. reduce the number of data files used by the database
D. reduce the number of redo log members in each group
E. configure database parameters to increase the frequency of checkpoints
Answer: E Question: 9
The HR team is complaining about the poor response time of SQL statements on certain tables. On investigation, you find that the generation of recursive calls (in addition to SQL statements) to
perform space management operations is the cause for the poor response time. To solve the problem, you executed the following command as the first step:
SQL> SELECT owner, table_name, blocks, empty_blocks
2 FROM dba_tables
3 WHERE empty_blocks/(blocks+empty_blocks)<.1; OWNER TABLE_NAME BLOCKS EMPTY_BLOCKS
--------------- ----------------- ----------- --------------------- HR REGIONS 1205 30
HR LOCATIONS 110 5

Select the next step that you would perform.

A. allocating extent to the tables by using the ALTER TABLE command
B. changing the block size by using the ALTER TABLESPACE command
C. exporting, dropping, and importing the REGIONS and LOCATIONS tables
D. creating the necessary indexes on the REGIONS and LOCATIONS tables
Answer: A Question: 10
Which three types of objects can you keep in the shared pool by using the dbms_shared_pool.keep procedure? (Choose three.)

A. types
B. triggers
C. LOB segments
D. SQL cursor objects
E. PL/SQL procedures
Answer: B, D, E Question: 11
You have joined an organization as a DB A. While examining one of the databases you notice the following settings:

LOG_ARCHIVE_START = FALSE LOG_ARCHIVE_MAX_PROCESS = 4

What do you understand from this settings?

A. Manual archiving is enabled and no archiver processes are started.
B. Archiving is not enabled, so the database is in NOARCHIVELOG mode.
C. Automatic archiving is enabled and four archiver processes will be started on demand.
D. Manual archiving is enabled and four archiver processes will be started for manual archiving.

TK

Exam Name: 11i Applications DBA Fundamentals II
Exam Type Oracle
Exam Code: 1z0-236 Total Questions: 114

Answer: A

Question: 12
Smith is a DBA with XYZ Corp. There are 500 data entry users in an online transaction processing (OLTP) environment. The current response time is 15-20 seconds. The company wants the response time to be brought down to 10 seconds or less. What is the first thing that
Smith should do to diagnose the cause of the slow response time?

A. determine whether there is contention for locks
B. determine whether the file system is fast enough
C. determine whether more memory needs to be allocated to PGA D. determine whether more memory needs to be allocated to SGA
E. determine whether the slow response is wait bound or CPU bound
Answer: E Question: 13
Smith is a DBA with ABC Corp. He is in the process of tuning the database. He has received various problem statements from the customers. Identify three appropriately defined problem statements that Smith can use to tune the database correctly. (Choose three.)

PassGuide offers free demo for Certification Exams You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products. Download links:PassGuide Braindumps Exams

A. The system is too slow.
B. Online response is very slow.
C. Sometimes the batch process throws errors.
D. The weekly backup took 30 minutes, and earlier it used to take 5 minutes.
E. The batch process is taking 2 hours, whereas it should take only 30 minutes.
F. The system currently has 100 users. We wish to increase the number of users to 250. The users' response time should not be affected.
Answer: D, E, F Question: 14
You created an index on the pdcost column of the PDLIST table in your database, and then
executed the following command to find the total number of rows sorted until now: SQL> SELECT name, value FROM v$sysstat WHERE name=’sorts (rows)’;
NAME VALUE
———————————————– ———- sorts (rows) 54762
Execution of which two queries would increase the sorts(rows) value? (Choose two.)

A. SELECT sum(pdcost) FROM pdlist; B. SELECT max(pdcost) FROM pdlist;
C. SELECT DISTINCT pdcost FROM pdlist;
D. SELECT * FROM pdlist ORDER BY pdcost;
Answer: C, D Question: 15
Which statements are true regarding configuring multiple buffer pools in the Database Buffer
Cache that is using only the standard block size? (Choose all that apply.)

A. Both the KEEP and RECYCLE pools must be configured.
B. The RECYCLE pool needs to be configured before dropping an object.
C. The DEFAULT pool needs to be removed if multiple buffer pools are being configured.
D. Either the KEEP pool or the RECYCLE pool can be configured along with the DEFAULT pool.

Product Description
Exam Number/Code: 1z0-236
Exam Name: 11i Applications DBA Fundamentals II

“11i Applications DBA Fundamentals II”, also known as 1z0-236 exam, is a Oracle certification.
Preparing for the 1z0-236 exam? Searching 1z0-236 Test Questions, 1z0-236 Practice Exam, 1z0-236 Dumps?

With the complete collection of questions and answers, Pass4sure has assembled to take you through 132 Q&As to your 1z0-236 Exam preparation. In the 1z0-236 exam resources, you will cover every field and category in Oracle 11i helping to ready you for your successful Oracle Certification.

Exam Number/Code:1z0-236
Exam Name: 11i Applications DBA Fundamentals II

Testking 1z0-236 Exam will provide you with exam simulation questions and actual answers that reflect the actual exam
Preparing for the Testking 1z0-236 exam?Searching 1z0-236 Test Questions,
1z0-236 Practice Exam,1z0-236 Braindumps ? 1z0-236 practice exam covers all the practice test objectives to pass 1z0-236 exam.

Pass your exam at first attempt with our Testking 1z0-236 study guide,1z0-236 Braindumps, As well Audio exam, Realistic Practice Labs, and Interactive Testing Engine.

Our Testking practice test covers the information associated with each 1z0-236 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-236 certification exam and pass the official exam on your first try, guaranteed

Now guaranteed Testking 1z0-236 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-236 pdf vce format resources that will enable you to pass your 1z0-236 test with flying colors.

Comprehensive questions with complete explanations about actualtests 1z0-236 exam
download 1z0-236 exam questions accompanied by exhibits
Verified Answers Researched by Industry Experts and almost 100% correct
1z0-236 exam questions updated on regular basis

Oracle 1z0-236 Transcender Torrent
Oracle 1z0-236 P4S
Oracle 1z0-236 Study Guide
Oracle 1z0-236 Exams
Oracle 1z0-236 Braindumps
Oracle 1z0-236 Pass4sure
Oracle 1z0-236 Real Exams
Oracle 1z0-236 Exam
Oracle 1z0-236 Actual Tests
Oracle 1z0-236 Pdf

1z0-236 also gives new editions of Real Exams 1z0-236 for enhancing professional skills and knowledge. These Testking Real Practice Questions 000-710 are useful for understanding 1z0-236 exam terminologies and these brain dumps also very useful for enhancing people brain power. These Testking Real Practice Questions 1z0-236 are prepare by highly qualified and 1z0-236 professionals. 1z0-236 Certification experts’ teams always try to give you real exam environment in these 4shared training materials links.

Question: 1
You plan to perform a backup of the control file in your database. Which two statements
regarding the control file backup are true? (Choose two.)
A. You can back up the control file to a binary file.
B. You must bring the database to the NOMOUNT state to perform the control file backup.
C. You must store all types of control file backups in the location defined by
USER_DUMP_DEST.
D. You can back up the control file by generating a script that can be used to re-create the control
file.
Answer: A, D
Question: 2
Which type of lock is held by SQL statements and PL/SQL objects in the Library Cache?
A. breakable parse locks
B. row-level (TX type) lock
C. table-level manual locks
D. table-level (TM type) locks
Answer: A
Question: 3
In an online transaction processing (OLTP) system, which is configured in shared server mode,
you execute the following query to examine the sort performance:
SQL> SELECT d.value “Disk”, m.value “Mem”, (d.value/m.value)*100 “Ratio”
FROM v$sysstat m, v$sysstat d
WHERE m.name=’sorts (memory)’ and d.name=’sorts (disk)’;
Disk Mem Ratio
———- ———- ————-
23 206 11.165049
What action would you take after observing the output?
A. increase the value of SORT_AREA_SIZE
B. increase the size of the temporary tablespace
C. increase the value of PGA_AGGREGATE_TARGET
D. no action required because the ratio is perfect for an OLTP system
Answer: A
Question: 4
Users complain of slow response time in your online transaction processing (OLTP) system. You
compare current statistics with baseline statistics. You notice that in the current statistics library
cache, the hit ratio has decreased and there are request misses for shared pool reserved are
a. Given below are the sizes of shared pool and shared pool reserved area:
SHARED_POOL_SIZE = 500 MB
SHARED_POOL_RESERVED_SIZE = 50 MB
What kind of strategy would you suggest for performance tuning?
A. increase the size of only the shared pool
B. decrease the size of the shared pool reserved area
C. increase the size of only the shared pool reserved area
D. increase the sizes of both the shared pool and the shared pool reserved area
E. increase the size of the shared pool and decrease the size of the shared pool reserved area
Answer: D
Question: 5
You are working in an OLTP environment. You wish to reduce the virtual memory requirements
for the Oracle instance due to Operating system paging or swap overheads. You need to
determine whether the buffer cache is oversized and could tolerate being reduced. In which two
cases can you afford to reduce the buffer cache size? (Choose two.)
A. if the cache hit ratio is very high
B. if there are no waits for free buffers
C. if the rate of physical I/O is very high
D. if the number of full table scans is very low
E. if the number of index accesses is very high
Answer: A, B
Question: 6
When starting up the test database, you encounter the following error after mounting the
database:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: ‘/u01/oracle/app/oradata/log2.log’
ORA-27037: unable to obtain file status
While investigating the reason, you find that the status of the redo log group 2 is CURRENT.
Which type of recovery would you perform to ensure that the database is functional?
A. Open Database recovery
B. Time-Based incomplete recovery
C. recovery using the backup control file
D. Cancel-Based incomplete recovery
E. Change-Based incomplete recovery
Answer: D
Question: 7
What provides the information about the free extents in a temporary tablespace before a sort
operation?
A. LRU chain
B. sort extent pool
C. resource free list
D. free extent table (FET$)
E. used extent table (UET$)
Answer: B
Question: 8
What action can you take to reduce the recovery time in case of instance failures?
A. use an SPFILE
B. multiplex the control files
C. reduce the number of data files used by the database
D. reduce the number of redo log members in each group
E. configure database parameters to increase the frequency of checkpoints
Answer: E
Question: 9
The HR team is complaining about the poor response time of SQL statements on certain tables.
On investigation, you find that the generation of recursive calls (in addition to SQL statements) to
perform space management operations is the cause for the poor response time. To solve the
problem, you executed the following command as the first step:
SQL> SELECT owner, table_name, blocks, empty_blocks
2 FROM dba_tables
3 WHERE empty_blocks/(blocks+empty_blocks)<.1;
OWNER TABLE_NAME BLOCKS EMPTY_BLOCKS
--------------- ----------------- ----------- ---------------------
HR REGIONS 1205 30
HR LOCATIONS 110 5
Select the next step that you would perform.
A. allocating extent to the tables by using the ALTER TABLE command
B. changing the block size by using the ALTER TABLESPACE command
C. exporting, dropping, and importing the REGIONS and LOCATIONS tables
D. creating the necessary indexes on the REGIONS and LOCATIONS tables
Answer: A
Question: 10
Which three types of objects can you keep in the shared pool by using the
dbms_shared_pool.keep procedure? (Choose three.)
A. types
B. triggers
C. LOB segments
D. SQL cursor objects
E. PL/SQL procedures
Answer: B, D, E
Question: 11
You have joined an organization as a DB A. While examining one of the databases you notice the
following settings:
LOG_ARCHIVE_START = FALSE
LOG_ARCHIVE_MAX_PROCESS = 4
What do you understand from this settings?
A. Manual archiving is enabled and no archiver processes are started.
B. Archiving is not enabled, so the database is in NOARCHIVELOG mode.
C. Automatic archiving is enabled and four archiver processes will be started on demand.
D. Manual archiving is enabled and four archiver processes will be started for manual archiving.
Answer: A
Question: 12
Smith is a DBA with XYZ Corp. There are 500 data entry users in an online transaction
processing (OLTP) environment. The current response time is 15-20 seconds. The company
wants the response time to be brought down to 10 seconds or less. What is the first thing that
Smith should do to diagnose the cause of the slow response time?
A. determine whether there is contention for locks
B. determine whether the file system is fast enough
C. determine whether more memory needs to be allocated to PGA
D. determine whether more memory needs to be allocated to SGA
E. determine whether the slow response is wait bound or CPU bound
Answer: E
Question: 13
Smith is a DBA with ABC Corp. He is in the process of tuning the database. He has received
various problem statements from the customers. Identify three appropriately defined problem
statements that Smith can use to tune the database correctly. (Choose three.)
A. The system is too slow.
B. Online response is very slow.
C. Sometimes the batch process throws errors.
D. The weekly backup took 30 minutes, and earlier it used to take 5 minutes.
E. The batch process is taking 2 hours, whereas it should take only 30 minutes.
F. The system currently has 100 users. We wish to increase the number of users to 250. The
users' response time should not be affected.
Answer: D, E, F
Question: 14
You created an index on the pdcost column of the PDLIST table in your database, and then
executed the following command to find the total number of rows sorted until now:
SQL> SELECT name, value FROM v$sysstat WHERE name=’sorts (rows)’;
NAME VALUE
———————————————– ———-
sorts (rows) 54762
Execution of which two queries would increase the sorts(rows) value? (Choose two.)
A. SELECT sum(pdcost) FROM pdlist;
B. SELECT max(pdcost) FROM pdlist;
C. SELECT DISTINCT pdcost FROM pdlist;
D. SELECT * FROM pdlist ORDER BY pdcost;
Answer: C, D

Testking 1z0-236
TK Questions&Answers(Q & As with Expert Explanations): 114 Q&A
Update: 28/06/2008

Free Down: Testking 1z0-236
Free Down: Pass4sure 1z0-236

PassGuide Test engine :High quality IT Certification Training Exam Questions, Study Guides and Practice Tests are in Downloadable PassGuide Testing Engine,Successful for IT Certification or Full Refund for you.

Dowload PassGuide Practice Test Questions,Training Materials

1. Free testking-oracle-9i DBA-exams
2. Free testking oracle 9i 1z0-141
3. Free testking oracle 9i 1z0-033
4. Free Testking Oracle 10g 1z0-048
5. Free Testking Oracle 11g 1z0-050
6. Free testking-oracle-10g DBA-exams
7. Free testking oracle 10g 1z0-045
8. Free Testking Oracle 1z0-055
9. Free testking oracle 9i 1z0-032
10. Free testking oracle 10g 1z0-042
11. Free testking-oracle-8i DBA-exams
12. Free testking oracle 10g 1z0-043