A.DROPUSERSMITH;
B.DROPTABLEEMPLOYEES;
C.DROPTABLESPACEUSERS;
D.ALTERTABLESALES_REPDROPPARTITIONP1;
E.ALTERTABLEEMPLOYEESDROPCOLUMNDESIG_ID;
第1题
A.Theuserisauthenticatedbytheoperatingsystem.
B.TheobjectscreatedbytheuserareplacedintheUSERStablespace.
C.TheuserdoesnotrequirequotaontheTEMPtablespacetoperformsortoperations.
D.Theuserisforcedtochangethepasswordatthefirstlogintothedatabaseinstance.
E.Theobjectscreatedbytheuserinfutureareunlockedtobeaccessedbyalltheusersinthedatabasebydefa
第2题
A.Thisclauseisnotvalidforatemporaryorundotablespace.
B.IfthetablespaceisintheNOLOGGINGmode,nooperationonthetablespacewillgenerateredo.
C.ThetablespacewillbeintheNOLOGGINGmodebydefault,ifnotspecifiedwhilecreatingatablespace.
D.Thetablespace-levelloggingattributecanbeoverriddenbyloggingspecificationsatthetable,index,materializedview,materializedviewlog,andpartitionlevels.
第3题
A.TheSKDusercannotlogintothedatabaseinstance.
B.TheobjectsownedbytheSKDuserarenotaccessibletoanyuser.
C.TheotheruserscanaccesstheobjectsownedbytheSKDuser,onwhichtheyhaveaccess.
D.ThepasswordfortheSKDuserexpiresandtheuserisforcedtochangethepasswordatthenextlogin.
第4题
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
第5题
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‘
第6题
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
第7题
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.
第8题
countingrecords.Duringthebatchrunprocess,someincorrectentrieswereinsertedintotheACCOUNTtable.Youidentifiedthebugandimmediatelystoppedthebatchrunprocess,but3000incorrectrecordswereinsertedintotheACCOUNTtablebeforethebatchprocesswasstopped.Youwanttorecoverthetabletothestateitwasat11:50P.M.Whichflashbackfeaturewillyouuse?()
A.FlashbackDrop
B.FlashbackDatabase
C.FlashbackTable
D.FlashbackVersionQuery
第9题
A.UsetheDatabaseResourceManager.
B.Setthelimitsintheprofilesusedbyusers.
C.ModifytheSESSIONSinitializationparameter.
D.SetthewarningthresholdfortheCurrentLogonsCountmetric.
第10题
A. The job is enabled by default after creation
B. The job is automatically dropped after the end date
C. The job executes with the privileges of the user SYS
D. The globalization environment that exists at the time of the job creation prevails at the job runs
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!