Youissuedthefollowingstatement:SQL>ALTERDATABASEBACKUPCONTROLFILETOTRACE;Whatwillbetheresultofissuingthestatement?()A.Thecontrolfilewillbemultiplexed.B.Thecontrolfilewillberecreated.C.ThescriptcontainingtheCREATECONTROLFILEstatementwillbecreated.D.Thebina

题目
Youissuedthefollowingstatement:SQL>ALTERDATABASEBACKUPCONTROLFILETOTRACE;Whatwillbetheresultofissuingthestatement?()

A.Thecontrolfilewillbemultiplexed.

B.Thecontrolfilewillberecreated.

C.ThescriptcontainingtheCREATECONTROLFILEstatementwillbecreated.

D.Thebinarybackupofthecontrolfilewillbecreated.

相似考题

1.Which two are attributes of ／SQL*Plus? ()A. /SQL*Plus commands cannot be abbreviated.B. /SQL*Plus commands are accesses from a browser.C. /SQL*Plus commands are used to manipulate data in tables.D. /SQL*Plus commands manipulate table definitions in the database.E. /SQL*Plus is the Oracle proprietary interface for executing SQL statements.

2.Youissuedthefollowingstatement:SQL>ALTERSESSIONSETNLS_LANG=FRENCH_CANADA.WE8ISO8859P1;WhichparameterisNOToverriddenbyusingtheabovestatement?()A.thevalueoftheNLS_LANGUAGEvariableB.thevalueoftheNLS_TERRITORYvariableC.thevalueoftheNLS_CURRENCYvariableD.thecharacterencodingschemeusedbytheclientapplication

3.YourOracle10gdatabasecontainsatablewithaTIMESTAMPTOLOCALTIMEZONEcolumn.Thereareabouttwohundredcolumnvaluesforthecolumn.Youissuedthefollowingstatement：SQL>ALTERDATABASESETTIME_ZONE=’Europe/London’；Whatwillbetheresultofissuingtheabovestatement？（）A.Thestatementwillbeexecutedsuccessfully，andanewtimezonewillbesetforthedatabase.B.Thestatementwillbeexecutedsuccessfully，butanewtimezonewillnotbesetforthedatabase.C.ThestatementwillnotbeexecutedsuccessfullybecausetheSETTIME_ZONEclausecanbeusedonlywiththeALTERSESSIONstatement.D.ThestatementwillnotbeexecutedsuccessfullybecausetheALTERDATABASESETTIME_ZONEstatementisusedonlywhenthedatabasecontainsnotablewiththeTIMESTAMPTOLOCALTIMEZONEcolumn.

4.Youissuedthefollowingstatement:SQL>ALTERDATABASEENABLERESUMABLETIMEOUTn;Whatwillbetheresultofissuingtheabovestatement?()A.ThecommandwillnotexecutesuccessfullybecauseTIMEOUTisaninvalidclausewiththeALTERDATABASEENABLERESUMABLEcommand.B.Thecommandwillnotexecutesuccessfullybecauseresumablespaceallocationisenabledatthesessionlevel.C.Thecommandwillexecutesuccessfullyandresumablespacewillbeallocatedatthesessionlevel.D.Thecommandwillexecutesuccessfullyandresumablespacewillbeallocatedattheinstancelevel.

更多“Youissuedthefollowingstatement:SQL>ALTERDATABASEBACKUPCONTROLFILETOTRACE;Whatwillbetheresultofissuingthestatement?() ”相关问题

  • 第1题：

    Youexecutedthefollowingcommandtobackupyourcontrolfile:ALTERDATABASEBACKUPCONTROLFILETOTRACE;Whichinitializationparameterisusedtospecifythelocationofthetracefile?()

    A.USER_DUMP_DEST

    B.CORE_DUMP_DEST

    C.TRACE_DUMP_DEST

    D.BACKUP_DUMP_DEST

    E.BACKGROUND_DUMP_DEST


    参考答案：A

  • 第2题：

    Youexecutedthefollowingcommandtobackupthecontrolfile:ALTERDATABASEBACKUPCONTROLFILETOTRACE;Whatdoyoufindinthetracefile?()

    A.Imageofthecontrolfile

    B.Locationofthecontrolfile

    C.Contentsofthecontrolfileintextformat

    D.SQLcommandtore-createthedatabase

    E.SQLcommandtore-createthecontrolfile

    F.Contentsofthecontrolfileinbinaryformat


    参考答案：E

  • 第3题：

    T-SQL是SQL语言的方言，Oracle的PL/SQL不是SQL方言


    错误

  • 第4题：

    Youhaveperformedanincompleterecoverybecausesomeimportantuser’sschemaisdroppedandpurgedfromtheRecycleBin.Thecurrentlogsaresequenced1005and1006.Afterperformingtherecovery，youissuedthefollowingstatement：SQL>ALTERDATABASEOPENRESETLOGS；Whatwillbetheresultantlogsequencenumbers？（）

    A.0and1

    B.1and2

    C.1005and1006

    D.1006and1007


    参考答案：B

  • 第5题：

    Youissuethisstatement:ALTERDATABASEBACKUPCONTROLFILETOTRACE;Whatdoesthestatementgenerate?()

    A.Atextcopyofthecontrolfile.

    B.Abinarycopyofthecontrolfile.

    C.AfilecontainingaSQLstatementwhichwillre-createthedatabase.

    D.AfilecontainingaSQLstatementwhichwillre-createthecontrolfile.


    参考答案：D

相关内容