A.Theuserisauthenticatedbytheoperatingsystem.
B.TheobjectscreatedbytheuserareplacedintheUSERStablespace.
C.TheuserdoesnotrequirequotaontheTEMPtablespacetoperformsortoperations.
D.Theuserisforcedtochangethepasswordatthefirstlogintothedatabaseinstance.
E.Theobjectscreatedbytheuserinfutureareunlockedtobeaccessedbyalltheusersinthedatabasebydefa
第1题
A.Thisclauseisnotvalidforatemporaryorundotablespace.
B.IfthetablespaceisintheNOLOGGINGmode,nooperationonthetablespacewillgenerateredo.
C.ThetablespacewillbeintheNOLOGGINGmodebydefault,ifnotspecifiedwhilecreatingatablespace.
D.Thetablespace-levelloggingattributecanbeoverriddenbyloggingspecificationsatthetable,index,materializedview,materializedviewlog,andpartitionlevels.
第2题
A.TheSKDusercannotlogintothedatabaseinstance.
B.TheobjectsownedbytheSKDuserarenotaccessibletoanyuser.
C.TheotheruserscanaccesstheobjectsownedbytheSKDuser,onwhichtheyhaveaccess.
D.ThepasswordfortheSKDuserexpiresandtheuserisforcedtochangethepasswordatthenextlogin.
第3题
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
第4题
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‘
第5题
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
第6题
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.
第7题
countingrecords.Duringthebatchrunprocess,someincorrectentrieswereinsertedintotheACCOUNTtable.Youidentifiedthebugandimmediatelystoppedthebatchrunprocess,but3000incorrectrecordswereinsertedintotheACCOUNTtablebeforethebatchprocesswasstopped.Youwanttorecoverthetabletothestateitwasat11:50P.M.Whichflashbackfeaturewillyouuse?()
A.FlashbackDrop
B.FlashbackDatabase
C.FlashbackTable
D.FlashbackVersionQuery
第8题
A.UsetheDatabaseResourceManager.
B.Setthelimitsintheprofilesusedbyusers.
C.ModifytheSESSIONSinitializationparameter.
D.SetthewarningthresholdfortheCurrentLogonsCountmetric.
第9题
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
第10题
YouareworkingasaDBAatNetFxCorporation.Auser,Scott,ismaintainingtherecordsofalltheemployeesintheEMPLOYEEtable.Initially,thesalaryoftheemployee,’E0025’,was$1800.On1May2004,thesalaryoftheemployee,’E0025’,wasincreasedby$200.
Theuser,Scott,issuedthefollowingstatementtomodifytherecordoftheemployee,’E0025’:
SQL>UPDATEEMPLOYEESETSALARY=2000
WHEREEMPNO=’E0025’;
SQL>COMMIT;
OnDecember1,2004,thesalaryoftheemployee,’E0025’,wasincreasedby$400.Theuser,Scott,issuedthefollowingstatementtomodifytherecordoftheemployee,’E0025’:
SQL>UPDATEEMPLOYEESETSALARY=2400
WHEREEMPNO=’E0025’;
SQL>COMMIT;
OnJuly1,2005,thesalaryoftheemployee,’E0025’,wasincreasedby$500.Theuser,Scott,issuedthefollowingstatementtomodifytherecordoftheemployee,’E0025’
SQL>UPDATEEMPLOYEESETSALARY=2900
WHEREEMPNO=’E0025’;
SQL>COMMIT;
OnJuly5,2005,theHRmanageraskedyoutogeneratetheincrementreportoftheemployee,’E0025’,fortheperiodbetween1May2004and1July2005.Whichflashbackfeaturewillyouusetogeneratetheincrementreport?()
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!