A.Theunitofversioningistheschema.
B.ItispossibletoversionenableatablepertainingtoSYS.
C.Thereareasmanysegmentsasversionsforthesamebasetable.
D.Itispossibletocreateworkspacesifthereisnoversion-enabledtableinthedatabase.
第1题
A.OracleFlashbackusesundoinformationtoconstructconsistentdata.
B.YoucanuseacursoropenedwhileusinganOracleFlashbackimagetoperformDMLonceyoudeactivateOracleFlashbackinyoursession.
C.YoucanonlyuseOracleFlashbackviewofthedataiftherequiredrecordsarestillintheonlineredologfiles.
D.OracleFlashbackliststheDMLthatwasexecutedduringtheperiodyouidentifywheninitiatingyoursession.
第2题
A.Removeline14.
B.Replaceline14with"inti=iter.next();".
C.Replaceline13with"for(inti:intList){".
D.Replaceline13with"for(Iteratoriter:intList){".
E.Replacethemethoddeclarationwith"sum(List
第3题
SCRIPTION column changed to hold varying length characters up to 1000 bytes. The column can currently hold 500 bytes per value. The table contains 20000 rows. Which statement is valid?()
A.ALTER TABLE commercials MODIFY (description CHAR2(1000));
B.ALTER TABLE commercials CHANGE (description CHAR2(1000));
C.ALTER TABLE commercials CHANGE (description VARCHAR2(1000));
D.ALTER TABLE commercials MODIFY (description VARCHAR2(1000));
E.You cannot increase the size of a column if the table has rows.
第5题
A.V$UNDOSTAT
B.V$TRANSACTION
C.V$ROLLSTAT
D.DBA_UNDO_EXTENTS
E.DBA_ROLLBACK_SEGS
第6题
table’sprimarykeyisstoredintheINDXtablespace.Outof12partitions,onlypartitionP1oftheSALEStableisstoredintheSAMPLEtablespace.Whichobjectwillbeexportedbythiscommand?()expsystem/managertablespaces=SAMPLE
A.OnlytheEMPLOYEEStable.
B.OnlytheEMPLOYEEStableanditscorrespondingprimarykeyindex.
C.TheEMPLOYEEStableandpartitionP1.
D.TheEMPLOYEEStable,IPK_EMPindex,andtheSALEStable.
第7题
stalled.BobiscurrentlyabletorunaJavachessprogramstartingfromhishomedirectory/home/bobusingthecommand:java-classpath/test:/home/bob/downloads/*.jargames.ChessBob’sCLASSPATHisset(atlogintime)to:/usr/lib:/home/bob/classes:/opt/java/lib:/opt/java/lib/*.jarWhatisapossiblelocationfortheChess.classfile?()
A./test/Chess.class
B./home/bob/Chess.class
C./test/games/Chess.class
D./usr/lib/games/Chess.class
E./home/bob/games/Chess.class
第8题
A.OracleManagedFilesareusedforthisinstance.
B.TheUSER_DATAtablespaceismanagedusingFET$/UET$tables.
C.TheCOMPATIBLEinitializationparametermustbe9.0.0orhigher.
D.SpacewithinsegmentsintheUSER_DATAtablespaceismanagedwithfreelists.
第9题
A.UsetheDROPDATAFILEcommand.
B.UsetheDROPTABLESPACEcommand.
C.EnsurethatalldatabasefilesareOracleManagedFilesbeforeusingtheDROPTABLESPACE command.
D.EnsurethattheDB_FILE_CREATE_DESTinitializationparameterissetbeforeusingtheDROP TABLESPACEcommand.
第10题
A.substitution variables
B.replacement variables
C.prompt variables
D.instead-of variables
E.This feature cannot be implemented through iSQL*Plus.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!