A.YoumustenabletherowmovementontheSCOTT.EMPtable.
B.YoumustdefinethetablespaceoftheSCOTT.EMPtableforautomaticsegmentspacemanagement.
C.YoumustusetheCASCADEclauseintheALTERTABLESHRINKSPACEstatement.
D.YoumustusetheCOMPACTclauseintheALTERTABLESHRINKSPACEstatement.
第1题
A.All system users have access to the MySQL server via—login path local
B.login-path can be used only for MySQL servers running on a local machine
C.login-path allows you to provide login credentials without passing clear text passwords on the command line
D.When using – login-path to connect to a remote MySQL server, the remote server version must be 5.6 or later
第2题
rackuserswhoareperformingthetransactionsandthevaluesusedinthetransactions.Youalsoplantotransferthesevaluestoanothertableforanalysis.Howwouldyouachievethis()
A.byusingtriggers
B.byusingDataPump
C.byusingexternaltables
D.byusinganonymousPL/SQLblocks
第3题
A. They consist of one or more Scheduler programs.
B. They are used to implement dependency scheduling.
C. They are used to implement time-based scheduling.
D.They are used to implement event-based scheduling.
E.None of the above.
第4题
(PROTOCOL=TCP)(HOST=10.156.24.216)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl.oracle.com)))TheTNSPINGcommandexecutessuccessfullywhentestedwithORCLbutyouarenotabletoconnecttothedatabaseinstancewiththefollowingcommand:SQL>CONNECTscott/tiger@orclWhatcouldbethereasonforthis?()
A.Thelistenerisnotrunningattheserver.
B.TheTNS_ADMINenvironmentalvariableissettoawrongvalue.
C.Theorcl.oracle.comdatabaseserviceisnotregisteredwiththelistener.
D.TheDEFAULT_DOMAINparameterissettoawrongvalueintheSQLNET.ORAfile.
第5题
A.Thedatabasemustbeinread-writemode.
B.Thedatabasemusthavenoexternalfiles.
C.Thedatabasemustopeninread-onlymode.
D.Thedatabasemustbemountedbutnotopened.
第6题
ethedroptableoperationisinprogress,userBexecutesthefollowingcommandonthesametable:SQL>DELETEFROMtransWHEREtr_type=’SL’;WhichstatementistrueregardingtheDELETEcommand()
A.Itfailswitha"ResourceBusy"error.
B.ItdeletestherowssuccessfullybecausethetableislockedinSHAREmode.
C.ItfailstodeletetherecordsbecausethetableislockedinEXCLUSIVEmode.
D.ItdeletestherowssuccessfullybecausethetableislockedinSHAREROWEXCLUSIVEmode.
第7题
A. WINDOW_PRIORITY
B. PRIORITY
C. PRIORITY_LEVEL
D. WINDOW_PRIORITY_LEVEL
E. OVERLAP_RULE
第8题
A.Anupdateinaleafrowtakesplace.
B.Theindexbecomesinvalidaftertheupdate.
C.Theleafblockcontainingtherowtobeupdatedismarkedasinvalid.
D.Arowintheleafblockoftheindexforthekeyvalueisdeletedandinserted.
第9题
Youissuedthefollowingcommand:
ALTERTABLESCOTT.EMPSHRINKSPACE;
TheSCOTT.EMPtableisstoredintheDATA1tablespacethathasthefollowingproperties:
DATA1isaread/writetablespace.
DATA1isnotautoextensibletoanunlimitedsize.DATA1isonline.
SegmentspacemanagementfortheDATA1tablespaceismanual.
YouissuedtheALTERTABLESCOTT.EMPSHRINKSPACE;commandthatgeneratesthefollowingerror:
ORA-10635:Invalidsegmentortablespacetype
Whatcouldbethereasonforthefailureofthecommand?()
第10题
A.Reclaimsspaceaboveandbelowthehigh-watermarkwithoutusingadditionalspace
B.Movesrowstoanewphysicallocation,resettingthehigh-watermark,butusesadditionalspaceduringtheoperation
C.Deallocatesspaceabovethehigh-watermarkthatiscurrentlynotinuse
D.Noneoftheabove
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!