TestInside Oracle 1z0-033 9i DBA Certification

1z0-033 9i DBA
Oracle Oracle9i Database:Performance Tuning

Practice Exam: 1z0-033 Exams

Exam Number/Code: 1z0-033
Exam Name: Oracle9i Database:Performance Tuning
Questions and Answers: 149 Q&As
( 9i DBA )

"Oracle9i Database:Performance Tuning", also known as 1z0-033 exam, is a

Oracle [Link] the complete collection of questions and answers, E x a m : 1z0-033
TestInside has assembled to take you through 149 Q&As to your 1z0-033
Exam preparation. In the 1z0-033 exam resources, you will cover every field and category in Oracle Certification
helping to ready you for your successful Oracle Certification.

Quality and Value for the 1z0-033 Exam TestInside Practice Exams for Oracle 9i DBA Certification 1z0-033 are
written to the highest standards of technical accuracy, using only certified subject matter experts and published
authors for development.

TestInside provide the professional Q&A.

1. We offer free update service for three month.

After you purchase our product, we will offer free update in time for three month.

2. High quality and Value for the 1z0-033 Exam.

1z0-033 simulation test questions, including the examination question and the answer, complete by our senior IT
lecturers and the 9i DBA product experts, included the current newest 1z0-033 examination questions.

3. 100% Guarantee to Pass Your 9i DBA exam and get your 9i DBA Certification.
If you do not pass the Oracle Certification 1z0-033 exam (Oracle9i Database:Performance Tuning) on your first
attempt using our TestInside testing engine and pdf file, we will give you a FULL REFUND of your purchasing fee.

use TestInside 1z0-033 Q&A ensure you pass the exam at your first try.

TestInside professional provide 9i DBA 1z0-033 the newest Q&A, completely covers 1z0-033 test original topic. With
our complete 9i DBA resources, you will minimize your 9i DBA cost and be ready to pass your 1z0-033 tests on Your
First Try, 100% Money Back Guarantee included!

Oracle 1z0-033 Test belongs to one of the 9i DBA certified test, if needs to obtain the 9i DBA certificate, you also
need to participate in other related test, the details you may visit the 9i DBA certified topic, in there, you will see all
related 9i DBA certified subject of examination.

TestInside Testing Engine Features

Comprehensive questions and answers about 1z0-033 exam

1z0-033 exam questions accompanied by exhibits

Verified Answers Researched by Industry Experts and almost 100% correct

1z0-033 exam questions updated on regular basis
Same type as the certification exams, 1z0-033 exam preparation is in multiple-choice questions (MCQs).
Tested by multiple times before publishing
Try free 1z0-033 exam demo before you decide to buy it in [Link].
Note:This pdf demo do not include the question's picture.

Exam : Oracle 1Z0-033

Title : Oracle 9I Database:Performance Tuning

1. The following are the tasks that you need to perform to create a resource plan:
A) Creating resource consumer groups
B) Validating pending area
C) Creating a pending area
D) Creating resource plans
E) Creating plan directives
F) Submitting pending area
In which order would you perform these tasks?
A.C, D, A, E, B, F
B.C, B, F, E, A, D
C.C, B, E, D, A, F
D.C, F, E, A, D, B
tings with users once each two weeks to discuss performance
Answer: A

2. You need to size the KEEP pool. Which calculation would you use to determine the initial size of the KEEP pool?
A.50% of the DEFAULT pool
B.50% of the RECYCLE pool
[Link] total number of blocks of all the candidate objects that you need in the KEEP pool / the number of objects that
you need in the KEEP pool
[Link] number of blocks of all the candidate objects that you need in the KEEP pool + additional space to allow for
object growth
Answer: D

3. 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.)
[Link] system is too slow.
[Link] response is very slow.
[Link] the batch process throws errors.
[Link] weekly backup took 30 minutes, and earlier it used to take 5 minutes.
[Link] batch process is taking 2 hours, whereas it should take only 30 minutes.
[Link] system currently has 100 users. We wish to increase the number of users to 250. The users' response time
should not be affected.
Answer: DEF

4. View the Exhibit.

In your database, you find that the fy05q1 table in a dictionary managed tablespace has excess space. Further, you
find that the table consists of three extents. The size of the first extent is 100KB, the second is 200KB, and the third
is 300K. The high water mark is in the middle of the second extent, and there is 400KB of unused space.
You want to release the unused space so that it can be used by other segments. You execute the following
command to achieve this task:
SQL> ALTER TABLE fy05q1 DEALLOCATE UNUSED;
What would this command do?
[Link] the third and second extents
[Link] the third extent; the second extent remains as it is
[Link] the third extent, and the second extent is sized to 100KB
[Link] an error because the unused space is above the high water mark
Answer: C

5. ABC Corp. plans to build an online transaction processing (OLTP) system. The company plans to tune all the
components during the development life cycle.
From the list given below, identify the order in which the components should be tuned.
1: logical and physical model
2: cursor sharing
3: Oracle instance memory structures
4: operating system
5: data file I/O
A.1, 2, 3, 5, 4
B.1, 3, 2, 4, 5
C.1, 2, 3, 4, 5
D.1, 2, 5, 3, 4
Answer: A

6. Which two activities would adversely affect database performance? (Choose two.)
[Link] a soft parse
[Link] archiving
[Link] frequent checkpointing
[Link] multiple buffer pools
[Link] online back up of data files
Answer: BE

7. You create a stored outline and apply it for use. What strategy would you adopt to verify that the stored outline is
being used for a statement?
[Link] OL$,OL$HINTS, and OL$NODES tables after running the statement with USE_STORED_OUTLINES set
[Link] the V$SQL dynamic performance view after running the statement with the USE_STORED_OUTLINES set
[Link] the explain plan output for the statement when running with and without the USE_STORED_OUTLINES
set
[Link] the statspack output by taking snaps before and after running the statement with the
USE_STORED_OUTLINES set
Answer: C

8. 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?
[Link] whether there is contention for locks
[Link] whether the file system is fast enough
[Link] whether more memory needs to be allocated to PGA
[Link] whether more memory needs to be allocated to SGA
[Link] whether the slow response is wait bound or CPU bound
Answer: E

9. In an online transaction processing (OLTP) system, you notice that the transactions are waiting. Which two
techniques would you use to determine if it is a locking problem? (Choose two.)
[Link] V$SESSION to determine the sessions waiting for locks
[Link] V$LOCKED_OBJECT to diagnose the deadlocked sessions
[Link] the [Link] script to find the list of locking and waiting transactions
[Link] the [Link] script to populate DBA_BLOCKERS and DBA_WAITERS views
[Link] the DBA_WAITERS view to determine the sessions that are waiting for a locked resource
Answer: CE

10. When tuning a database server, which three goals should you focus on? (Choose three.)
[Link] response time for OLTP users
[Link] throughput for batch processing
[Link] response time for batch processing
[Link] load capability for the decision-support systems
[Link] parallelism for online transaction processing (OLTP) systems
Answer: ABD

11. ABC Corp. has an online transaction processing (OLTP) system that has just gone into production. The system
was rigorously tested during the development phases.
What is the first recommended activity that the DBA should perform before starting to monitor the performance of the
system on a regular basis?
[Link] SQL*Trace
[Link] baseline statistics
[Link] indexes and user tables
[Link] meetings with users once each two weeks to discuss performance
Answer: B

12. View the Exhibit and examine the steps to create a database resource plan. Execution of the following procedure
resulted in an error:
SQL> EXECUTE dbms_resource_manager.validate_pending_area();
What could be the reason for this?
[Link] ADMINISTER_RESOURCE_MANAGER privilege is not granted to the user.
[Link] procedure should be executed before creating the resource plan directive.
[Link] SYS_GROUP resource consumer group is not included in the resource plan directive.
[Link] OTHER_GROUPS resource consumer group is not included in the resource plan directive.
Answer: D

13. View the Exhibit and examine the output to check the resource plan directives associated with the groups in a
plan.
Which three statements are true regarding the output? (Choose three.)
[Link] users belonging to OTHER_GROUPS will never be able to run a query.
[Link] if there is only one active session running, that session is allowed to utilize all the available CPU resources
according to the directives of the plan.
[Link] is possible to raise the priority for the online transaction processing (OLTP) group from 80% to 90% without
changing the priority for any other group.
[Link] a fully loaded system, sessions for OTHER_GROUPS have to wait for other sessions to finish work if all CPU is
used by first three groups.
[Link] a heavily used system, the sessions in the OLTP group have the ability to consume 80% or more of the total
CPU resources available.
Answer: BDE

14. You executed the following query to know about users and their consumer groups:
SQL> SELECT * FROM DBA_RSRC_CONSUMER_GROUP_PRIVS;
GRANTEE GRANTED_GROUP GRANT_OPTION INITIAL_GROUP
--------------- ------------------------- --------------- ---------------
SCOTT LOW_GROUP NO NO
PUBLIC LOW_GROUP NO NO
PUBLIC DEFAULT_CONSUMER_GROUP YES YES
SYSTEM SYS_GROUP NO YES
If the user SCOTT starts a session, to which consumer group will the session belong?
[Link] session belongs to LOW_GROUP.
[Link] session belongs to SYS_GROUP.
[Link] session belongs to DEFAULT_CONSUMER_GROUP.
[Link] session does not belong to any group because the user is not assigned to any group.
Answer: C

15. A customer has various dictionary-managed tablespaces with past data. The extents in dictionary-managed
tablespaces are not uniformly sized. Newly created tablespaces are locally managed. You want to make all the
tablespaces locally managed. What approach would you use to change the dictionary-managed tablespaces to
locally managed tablespaces to get all the performance benefits of local extent management?
[Link] only the DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL procedure
[Link] new locally managed tablespaces and move data from existing dictionary-managed tablespaces to locally
managed tablespaces
[Link] the DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL procedure, followed by
DBMS_SPACE_ADMIN.TABLESPACE_FIX_SEGMENT_STATES
[Link] the ALTER TABLESPACE command to change extent management to local, and then use the
DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL procedure
Answer: B

16. Oracle Shared Server is best used when _____ and _____. (Choose two.)
[Link] database is experiencing database-intensive work
[Link] database is primarily used for batch or DSS operations
[Link] usage on your machine is consistently at 90% or higher
[Link] OLTP application is running on a machine approaching memory resource limits
[Link] do not need to scale up the number of concurrent connections to the database
[Link] database is primarily used for an interactive application where dedicated servers are mainly idle
Answer: DF

17. You have online application users who are interested in seeing a few initial results of a query. Therefore you
require the query to produce a few initial rows quickly regardless of the presence of statistics. Which optimizer mode
would you choose?
[Link]
[Link]
C.ALL_ROWS
D.FIRST_ROWS_n
Answer: D

18. You have reserved memory within the Shared Pool by using the SHARED_POOL_RESERVED_SIZE parameter to
accommodate large space allocations while compiling PL/SQL blocks and database triggers.
While observing the performance of the reserved area, you find that the value of the REQUEST_FAILURES column in
the V$SHARED_POOL_RESERVED view is continuously increasing.
Which statement is true in this scenario?
[Link] parsing of the statement fails due to invalidations.
[Link] execution of the statement fails due to invalidations.
[Link] space allocated for the reserved area is not enough.
[Link] syntax in the PL/SQL blocks is causing the compilation failure.
Answer: C

19. The values for the resource plan directives are set as follows:
SWITCH_GROUP = OLAP
SWITCH_TIME = 1000
SWITCH_ESTIMATE = True
What are the two implications of these values on a running session belonging to the consumer group for which these
directives are set? (Choose two.)
[Link] settings are useful to limit the resources consumed by short-running operations.
[Link] resource manager switches the session to the OLAP group if the session is active for more than 1,000
seconds and after the operation the session becomes part of the OLAP group.
[Link] resource manager can switch the session to the OLAP group before an operation even starts running.
[Link] resource manager switches the session to the online analytical processing (OLAP) group if the session is
active for more than 1,000 seconds and after the operation the session is moved back to the original group.
Answer: CD

20. Why does performance degrade when many UPDATE, INSERT, or DELETE statements are issued on a table that
has an associated Bitmap index?
[Link] DML operations re-create the Bitmap index blocks.
[Link] Bitmap index is rebuilt automatically after a DML operation.
[Link] smallest amount of a bitmap that can be locked is a bitmap segment.
[Link] time is taken to remove NULL values from the Bitmap index after a DML operation.
Answer: C

More 1z0-033 Information

Related 1z0-033 Exams

1z0-007 Introduction to Oracle9i: SQL

1z0-032 orcacle9l datab ase:fundamentals ii

1z0-031 orcacle9i datab ase:fundamentals i

1z0-033 Oracle9i Datab ase:Performance Tuning

1z0-030 orcacle9i datab ase:new features for administrators

1z0-035 orcacle9i db a new features for oracle7.3 and oracle9 ocps

Other Oracle Exams

1z0-036 1z0-221 1z0-226 1Z0-207 1z0-263 1Z0-144 1z0-605 1z0-272

1Z1-402 1z0-033 1Z0-052 1z0-211 1z0-212 1z0-255 1z0-610 1z0-035

1Z0-520 1Z0-200 1z0-232 1z0-222