1z0-033 Oracle - Braindumps.com.ua: question list for "Oracle9i:Performance Tuning", page: 2

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

Oracle 1z0-033: Oracle9i:Performance Tuning

#11. You issued the following query on the V$INSTANCE_RECOVERY dynamic performance view:

 SELECT target_mttr, estimated_mttr FROM v$instance_recovery;

You noticed that the value for the ESTIMATED_MTTR column is greater than the value for the TARGET_MTTR. What would happen in this scenario?

#12. Exhibit:

View the Exhibit and examine the execution plan of the following query:

 SQL> SELECT s.prod_id, 
 2 t.fiscal_month_number, 
 3 SUM(s.amount_sold) AS sum_amount 
 4 FROM sales s, times t 
 5 WHERE s.time_id = t.time_id 
 6 AND t.fiscal_year = 2000 
 7 GROUP BY s.prod_id, t.fiscal_month_number 
 8 ORDER BY s.prod_id, t.fiscal_month_number;

Which statement regarding the SALES_PROD object in the execution plan is true?

#13. Which type of lock is held by SQL statements and PL/SQL objects in the Library Cache?

#14. The steps involved in copying statistics from the source database to the target database are given below in random order:
1) Export the statistics table from the source database and then import it into the target database.
2) Copy the statistics to a table in the source database.
3) Create a table to hold the statistics in the source database.
4) Copy the statistics into the data dictionary in the target database.
5) Run the Oracle-supplied csminst.sql script to create a schema and a table to hold the statistics in the source database.
6) Collect the system statistics in the target database.
What is the correct order to accomplish this task?

#15. Which statement correctly describes the purpose of the REFRESH COMPLETE option when used with materialized view?

#16. View the Exhibit and examine the TKPROF output.

While studying the TKPROF output, you find that the number of disk reads is close to the total number of buffers used (query + current) for some statements. What is the reason for this?

#17. You have the following requirements:
• Your transaction only queries the table, and requires a consistent set of the table’s data for the duration of the transaction.
• You can hold up other transactions that try to update the locked table, until all transactions that hold SHARE locks on the table either commit or roll back.
• Other transactions may acquire concurrent SHARE table locks on the same table, also allowing them the option of transaction-level read consistency.
Which type of locking strategy would you select to achieve this?

#18. You are working in a dedicated server environment. You discovered that your database performance is degraded due to a huge number of sort operations that are using the disk space instead of the memory area. The WORKAREA_SIZE_POLICY parameter is set to AUTO. What would be one of the solutions to improve database performance?

#19. You observed a lot of unused space below the high-water mark for a table. Which three methods could you use to deallocate the unused space? (Choose three.)

#20. Which two statements are correct regarding users in a shared server environment? (Choose two.)

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] ... [17]

gen. 0.094

Server date 06:21 02-12-2008

Oracle 1z0-033

Forum

Start online exam simulation

Master braindump

User braindumps