关于分包，下列属于非法分包行为的是()。

A. Flash recovery area must be defined

B. Undo retention guarantee must be enabled.

C. Database must be running in archivelog mode.

D. Automatic undo management must be enabled.

E. The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).

03 and 115. The UPDATE statement you specify should update the rows with the values specified below:Which UPDATE statement meets the requirements?（）

A.

B.

C.

D.

E.

Youhaveconfiguredtheflashrecoveryareatostoreonlineredologfiles，controlfiles，archivedredologsandRMANbackups.Whichofthefollowingfilescanyousuccessfullydeletefromtheflashrecoveryareaifyouwanttoreclaimthespacewithinit？（）

A.multiplexedcontrolfiles

B.RMANobsoletebackups

C.multiplexedonlineredologfiles

D.archivedredologsthathavenotbeencopiedtotape

A. The data file backup is done with multiple channels

B. The data files is in the read-write mode after being backed up in the read only mode

C. The backup was taken after the data files was taken offline-normal or is in the read only mode

D. The data file backup complies with the back retention policy and the backup duplexing feature

A.whenrowdirectoriesneedmorerowentries

B.whenthereisrowmigrationinthedatablock

C.whenthereisanincreaseinthePCTFREEvalueforthedatablock

D.whenmoretransactionslotsarerequiredthanareinitiallyconfigured

YourOracleDatabase10gisonlinewhenyouexecutethefollowingstatement：SQL>ALTERTABLESPACEMY_TABLESPACEFLASHBACKOFF；WhatistheresultofexecutingthisstatementiftheFlashbackDatabasefeatureisalreadyenabledinthedatabase？（）

A.ThedatabasedoesnotrecordflashbacklogsforMY_TABLESPACE

B.ThetablesresidinginMY_TABLESPACEarenotprotectedbytheRecycleBin.

C.AllthetablespacesexceptMY_TABLESPACEcanberecoveredusingFlashbackDatabasefeature.

D.Noneoftheflashbacktechnologies，suchasFlashbackTable，FlashbackTransactionQueryandFlashbackVersionQuerycanbeusedtorecoverindividualrowswithintheobjectsfromMY_TABLESPACE

A.Itcanspanmultipledatabases.

B.Itcanconsistofmultipledatafiles.

C.Itcancontainblocksofdifferentsizes.

D.Itcancontainsegmentsofdifferentsizes.

E.Itcancontainapartofanonpartitionedsegment.

HIVE_DEST_1 = ‘LOCATION=/disk1/arch‘LOG_ARCHIVE_DEST_2 = ‘LOCATION=/disk2/arch‘LOG_ARCHIVE_DEST_3 = ‘LOACTION=/disk3/arch‘LOG_ARCHIVE_DEST_4 = ‘LOCATION=/disk4/arch MANDATORY‘Identify the statement that correctly describes this setting.（）

A. The MANDATORY location must be a flash recovery area.

B. The optional destinations may not use the flash recovery area.

C. This setting is not allowed because the first destination is not set as MANDATORY.

D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

At10：30A.M.，youranabatchjobbymistake，whichexecutedatransactioninthedatabase.Thetransactionidentifierofthetransactionthatmadetothechangesinthedatabaseis0500A00627B000.At11：10A.M.，youstoppedthebatchjob.Now，youwanttoidentifythechangesmadetothedatabasetablesbythebatchjob.Whichviewwillyouquery？（）

A.DBA_PENDING_TRANSACTIONS

B.DBA_AUDIT_STATEMENT

C.V$FLASHBACK_DATABASE_STATS

D.FLASHBACK_TRANSACTION_QUERY

A.shutdownabort

B.shutdownkill

C.Shutdownnowait

D.shutdownimmediate

E.shutdownhalt