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?

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?

A.
the DBMS_AQ package

B.
th DBMS_IJOB package

C.
the OS levl job automation tool

D.
the DBMS_SCHEDULER package

E.
Enterprise Manager job scheduling



Leave a Reply 0

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