Youissuedthefollowingcommand:
SQL>DROPTABLEMYTABLE;
SQL>SHOWRECYCLEBINThefollowingoutputisreturned:
ORIGINALNAMERECYCLEBINNAMEOBJECTTYPEDROPTIME
------------------------------------------------------------------------------
MYTABLEBIN$04LhcpndanfgMAAAAAANPw==$0TABLE
2005-01-13:20:11:31Youwanttodropthetable,MYTABLE,fromtheRecycleBin.Whichtwocommandscanyouissuetoaccomplishthedesiredtask?()
第1题
ALTERTABLESCOTT.EMPSHRINKSPACE;
TheSCOTT.EMPtableisstoredintheDATA1tablespacethathasthefollowingproperties:
DATA1isaread/writetablespace.
DATA1isnotautoextensibletoanunlimitedsize.DATA1isonline.
SegmentspacemanagementfortheDATA1tablespaceismanual.
YouissuedtheALTERTABLESCOTT.EMPSHRINKSPACE;commandthatgeneratesthefollowingerror:
ORA-10635:Invalidsegmentortablespacetype
Whatcouldbethereasonforthefailureofthecommand?()
第2题
A. The backup will terminate because the FORMAT clause was not configured for the channel
B. It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
C. It backs up the data files and archived log files to disk, making two copies of each data file and archived log file
D. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
第3题
A. The backup will terminate because the FORMAT clause was not configured for the channel
B. It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
C. It backs up the data files and archived log files to disk, making two copies of each data file and archived log file
D. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
第4题
A.byusingtheDBMS_REPAIRpackage
B.byusingtheDB_BLOCK_CHECKINGparameter
C.byusingtheDBVERIFYutility
D.willnotbecompletelyresolveduntilthehardwarefaultiscorrected
第5题
A.Itstoresonlythetemporarytablebutnotitsindexes.
B.Itstoresboththetemporarytableaswellasitsindexes.
C.Itmustbeanondefaulttemporarytablespaceforthedatabase.
D.Itcanbeadefaultornondefaulttemporarytablespaceforthedatabase.
E.Itmustbethedefaulttemporarytablespaceoftheuserwhoissuesthecommand.
第6题
A.Thedatabasewillopen,andthetablespaceautomaticallycomesoutofthebackupmode.
B.Thedatabasewillbemounted,andrecoverymustbeperformedontheUSERStablespace.
C.Thedatabasewillbemounted,anddatafilesintheUSERStablespacemustbetakenoutofthebackupmode.
D.Thedatabasewillnotbemounted,andyoumustrestoreallthedatafilesfortheUSERStablespacefromthebackup,andperformrecovery.
第7题
A.Alldataalongwiththetablestructureisdeleted
B.Thependingtransactioninthesessioniscommitted
C.Allindexesonthetablewillremainbuttheyareinvalidated
D.Allviewsandsynonymswillremainbuttheyareinvalidated
E.Alldatainthetablearedeletedbutthetablestructurewillremain
第8题
A.Theblockchangetrackingfeatureisenabled,andtheinformationaboutthesystemchangenumberiswritteninthechangetrackingfile.
B.Theblockchangetrackingfeatureisenabled,andtheinformationaboutthelogsequencenumberiswritteninthechangetrackingfile.
C.Theblockchangetrackingfeatureisenabled,andtheinformationabouttheblocksthatarechangedsincethelastbackupiswritteninthechangetrackingfile.
D.Theblockchangetrackingfeatureisenabled,andtheinformationaboutthelocationsofthedatafilesandtheonlineredologfilesarewritteninthechangetrackingfile.
第9题
A.Theoperatingsystemlocaltimezonewillbesetforausersessionusingtheoperatingsystemenvironmentvariable.
B.Thedatabaselocaltimezonewillbesetforausersessionusingtheoperatingsystemenvironmentvariable.
C.Theoperatingsystemlocaltimezonewillbesetforthedatabaseusingtheoperatingsystemenvironment
D.Thedatabaselocaltimezonewillbesetforthedatabaseusingtheoperatingsystemenvironmentvariable.
第10题
A.TheclientRDBMSinstancecanaccessthefileasaread-onlyfile.
B.Anewdiskcannotbeaddedtoadiskgroup.
C.Adiskinadiskgroupcanbetakenoffline.
D.TheclientRDBMSinstancecannotaccessthefilesinthediskgroup.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!