Which two new features of the Oracle 10g database could you use to automate this task?

In an online transaction processing (OLTP) environment, you find that the transaction tables
get heavily fragmented during the week. You decide to defragment the transaction tables on
every Friday at 9:30 p.m. to gain performance. Which two new features of the Oracle 10g
database could you use to automate this task? (Choose two.)

In an online transaction processing (OLTP) environment, you find that the transaction tables
get heavily fragmented during the week. You decide to defragment the transaction tables on
every Friday at 9:30 p.m. to gain performance. Which two new features of the Oracle 10g
database could you use to automate this task? (Choose two.)

A.
the DBMS_AQ package

B.
Enterprise Managerjob scheduling

C.
the DBMS_SCHEDULER package

D.
the OS level job automation tool

E.
the DBMS_IJOB package



Leave a Reply 0

Your email address will not be published. Required fields are marked *