A.When uptime is critical
B.When data must be refactored
C.When application concurrency is static
D.When data loss is unacceptable
E.When application is a single point of failure
第1题
A.DROPUSERSMITH;
B.DROPTABLEEMPLOYEES;
C.DROPTABLESPACEUSERS;
D.ALTERTABLESALES_REPDROPPARTITIONP1;
E.ALTERTABLEEMPLOYEESDROPCOLUMNDESIG_ID;
第2题
A.Theuserisauthenticatedbytheoperatingsystem.
B.TheobjectscreatedbytheuserareplacedintheUSERStablespace.
C.TheuserdoesnotrequirequotaontheTEMPtablespacetoperformsortoperations.
D.Theuserisforcedtochangethepasswordatthefirstlogintothedatabaseinstance.
E.Theobjectscreatedbytheuserinfutureareunlockedtobeaccessedbyalltheusersinthedatabasebydefa
第3题
A.Thisclauseisnotvalidforatemporaryorundotablespace.
B.IfthetablespaceisintheNOLOGGINGmode,nooperationonthetablespacewillgenerateredo.
C.ThetablespacewillbeintheNOLOGGINGmodebydefault,ifnotspecifiedwhilecreatingatablespace.
D.Thetablespace-levelloggingattributecanbeoverriddenbyloggingspecificationsatthetable,index,materializedview,materializedviewlog,andpartitionlevels.
第4题
A.TheSKDusercannotlogintothedatabaseinstance.
B.TheobjectsownedbytheSKDuserarenotaccessibletoanyuser.
C.TheotheruserscanaccesstheobjectsownedbytheSKDuser,onwhichtheyhaveaccess.
D.ThepasswordfortheSKDuserexpiresandtheuserisforcedtochangethepasswordatthenextlogin.
第5题
misc EXTERNAL REDUNDANCYDISK ‘ORCL: FRA3‘ NAME misc1, ‘ORCL: FRA4‘ NAME misc2;In which situation would you use this method of disk group creation?()
A. When two-way disk mirroring is required for the allocation units
B. When three-way disk mirroring is required for the allocation units
C. When using hardware mirroring or RAID
D. When disk mirroring is required for the Automatic Storage Management (ASM) disks
第6题
A.restoredatafilesuntiltime‘09/28/2008:21:03:11‘
B.restoredatabasefilesuntiltime‘09/28/2008:18:00:00‘
C.restoredatabaseuntiltime‘09/28/2008:18:00:00‘
D.recoverdatabaseuntiltime‘09/28/2008:18:00:00‘
E.recoverdatabaseuntiltimestamp‘09/28/2008:18:00:00‘
第7题
A. Testing the backup and recovery procedures
B. Testing the upgrade of an Oracle database to a new release
C. Testing the effect of an application changes on database performance
D. Continuously updating archive log files from the target database to support failover
第8题
OTE_OS_AUTHENT=FALSEREMOTE_OS_ROLES=FALSETIMED_OS_STATISTICS=0YouhavealocaloperatingsystemuserSKD.YoucreateadatabaseuserOPS$SKD,andthenassignexternalauthentication.TheuserOPS$SKDhastheCREATESESSIONprivilege.Whatwouldyouachievebytheaboveprocess()
A.ThedatabaseuserOPS$SKDwillbeabletoadministerthedatabase.
B.TheauthenticationdetailforthedatabaseuserOPS$SKDisrecordedinthepasswordfile.
C.ThelocaloperatingsystemuserSKDwillbeabletoaccessthedatabaseinstancewithoutspecifyingtheusernameandpassword.
D.ThedatabaseuserOPS$SKDhastologinwiththepasswordofthelocaloperatingsystemuserSKDtoaccessthedatabaseinstance.
第9题
countingrecords.Duringthebatchrunprocess,someincorrectentrieswereinsertedintotheACCOUNTtable.Youidentifiedthebugandimmediatelystoppedthebatchrunprocess,but3000incorrectrecordswereinsertedintotheACCOUNTtablebeforethebatchprocesswasstopped.Youwanttorecoverthetabletothestateitwasat11:50P.M.Whichflashbackfeaturewillyouuse?()
A.FlashbackDrop
B.FlashbackDatabase
C.FlashbackTable
D.FlashbackVersionQuery
第10题
A.UsetheDatabaseResourceManager.
B.Setthelimitsintheprofilesusedbyusers.
C.ModifytheSESSIONSinitializationparameter.
D.SetthewarningthresholdfortheCurrentLogonsCountmetric.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!