YouissuedthefollowingcommandattheUNIXenvironment：%setenvORA_SDTZ’OZ_TZ’Whatwillbetheimpactofissuingtheabovecommand？（）

_area（startdateDATE，enddateDATE，classCHAR（20））ONCOMMITPRESERVEROWS；WhichstatementistrueabouttherowsinsertedintotheREPORT_WORK_AREAtableduringatransaction（）

A.Therowsstayinthetableonlyuntilsessiontermination.

B.Therowsstayinthetableonlyuntilthenexttransactionstartsonthetable.

C.Therowsarevisibletoallcurrentsessionsafterthetransactioniscommitted.

D.Therowsstayavailableforsubsequentsessionsafterthetransactioniscommitted

for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.How would you achieve this?（）

A. Implement job classes

B. Implement Scheduler windows

C. Implement the mapping rule for the consumer groups

D. Set the SWITCH_TIME resource plan directive for both the resource plans

A.Both technologies guarantee an identical copy of data on the secondary node

B.Only MySQL can maintain a time-delayed copy of data on the secondary node

C.Both technologies use the TCP/IP stack as their primary transmission medium

D.DRBD uses shared-disk technology

A.Filterversions

B.Filterloads

C.Filtertasks

D.Filteroptions

eEMP_CODEcolumnistheprimarykeycolumn.Attheendofeverymonth，youarerequiredtoperformsearchqueriesbasedontheBASIC_SAL+COMMcolumnvalues.Whichtypeofindexwillyoucreate？（）

A.B-treeIndex

B.BitmapIndex

C.Function-basedIndex

D.PartitionedIndex

tedinyourdatabasehasincreased.ThecharactersetofyourdatabaseisUTF8.YoudecidetomigrateyourdatabasetotheAL16UTF16nationalcharacterset.HowwillyoumigrateyourdatabasefromUTF8toAL16UTF16？（）

A.byusingtheRMANutility

B.byusingtheexport/importutility

C.byusingtheALTERDATABASEcommand

D.byenablingthechangetrackingfeature

threedatabasesessionsandexecutedthefollowingcommandinoneofhissessions：SQL>UPDATEpersonsSETccode=’U031’WHEREccode=’U029’；123rowsupdated.SQL>DELETEFROMpersonsWHEREexp=’Y’；3rowsdeleted.TheSYSuseropensanewsessionafterHRexecutedtheabovecommands.WhichsessionscanseetheeffectoftheUPDATEandDELETEcommands（）

A.allsessionsoftheHRuseronly

B.allsessionsoftheHRuserandtheSYSuser

C.thesessionoftheHRuserthatexecutedthecommands

D.allthesessionsforwhichthedatabaseusershaveaccessprivilegetothePERSONStable

dredcolumnvaluesforthecolumn.Youissuedthefollowingstatement：SQL>ALTERDATABASESETTIME_ZONE=’Europe/London’；Whatwillbetheresultofissuingtheabovestatement？（）

A.Thestatementwillbeexecutedsuccessfully，andanewtimezonewillbesetforthedatabase.

B.Thestatementwillbeexecutedsuccessfully，butanewtimezonewillnotbesetforthedatabase.

C.ThestatementwillnotbeexecutedsuccessfullybecausetheSETTIME_ZONEclausecanbeusedonlywiththeALTERSESSIONstatement.

D.ThestatementwillnotbeexecutedsuccessfullybecausetheALTERDATABASESETTIME_ZONEstatementisusedonlywhenthedatabasecontainsnotablewiththeTIMESTAMPTOLOCALTIMEZONEcolumn.

A.thevalueoftheNLS_LANGUAGEvariable

B.thevalueoftheNLS_TERRITORYvariable

C.thevalueoftheNLS_CURRENCYvariable

D.thecharacterencodingschemeusedbytheclientapplication

omplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you are asked to change the retention period from 5 years to 3 years. To accomplish this, you issued the following command:ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEARS;What is the outcome of this command?（）

A. The command produces an error because the retention period cannot be reduced

B. All historical data older than 3 years is purged from the flashback archive FLA1

C. All historical data is retained but the subsequent flashback data archives are maintained for only 3 years

D. All historical data is transferred to flashback logs and the flashback archive is refreshed to set a new retention time