YouareusingOracleDatabase10g.TheLOG_ARCHIVE_FORMATparameterissetto’LOG%t_%s_%r.dbf’.Whyis%rusedinthefilenameformat?()A.touniquelyidentifythearchivedlogfileswiththerestoreoperationB.touniquelyidentifythearchivedlogfileswiththeredologgroupnumberC.touniquely

题目
YouareusingOracleDatabase10g.TheLOG_ARCHIVE_FORMATparameterissetto’LOG%t_%s_%r.dbf’.Whyis%rusedinthefilenameformat?()

A.touniquelyidentifythearchivedlogfileswiththerestoreoperation

B.touniquelyidentifythearchivedlogfileswiththeredologgroupnumber

C.touniquelyidentifythearchivedlogfilesforeachincarnationofthedatabase

D.touniquelyidentifythearchivedlogfileswiththenumberofrecoveryoperationsperformed

相似考题

1.YouwantanASMinstancetomanagethefilesofyourdatabase.Toachievethisobjective，youspecifythefollowingparametersintheparameterfileofthedatabase：INSTANCE_TYPE=RDBMSDB_NAME=PRODLARGE_POOL_SIZE=8MBDB_BLOCK_SIZE=4KLOG_ARCHIVE_DEST=+dgroupALOG_ARCHIVE_FORMAT="$ORACLE_SID_%s_%t.%t"DB_CREATE_FILE_DEST=+dgroupACOMPATIBLE=10.1.0.2.0CONTROL_FILES=+dgroupAWhichparameterwouldbeignoredwhilestartinguptheinstanceforthedatabasePROD？（）A.DB_BLOCK_SIZEB.CONTROL_FILESC.LARGE_POOL_SIZED.LOG_ARCHIVE_DESTE.LOG_ARCHIVE_FORMATF.DB_CREATE_FILE_DEST

2.ThedatabaseisrunninginARCHIVELOGmode.Examinetheinitializationparametersandtheirvaluessettoenablearchivingonyourdatabaseserver：LOG_ARCHIVE_FORMAT=arch_%t_%s_%r.arcLOG_ARCHIVE_DEST_1=’LOCATION=/disk1/archive’DB_RECOVERY_FILE_DEST=’/u01/oradata’DB_RECOVERY_FILE_DEST_SIZE=20GWhichstatementistrueregardingthearchivedredologfiles（）A.Itwillbecreatedonthelocalfilesystem.B.ItwillbecreatedonlyintheFlashRecoveryArea.C.ItwillbecreatedinthelocationspecifiedbytheLOG_ARCHIVE_DEST_1parameterandthedefaultlocation$ORACLE_HOME/dbs.D.ItwillbecreatedinthelocationspecifiedbytheLOG_ARCHIVE_DEST_1parameterandlocationspecifiedbytheDB_RECOVERY_FILE_DESTparameter.

3.YouperformedanincompleterecoveryandopenedthedatabasewiththeRESETLOGSoption.TheLOG_ARCHIVE_FORMATparameterissetto’ora_%t_%s_%r.log’.Whichstatementregardingthearchivedredologfiles，createdinanearlierincarnationofthedatabase，istrue？（）A.Thearchivedredologfileswillbeoverwritten.B.Thearchivedredologfilesaredeletedautomatically.C.Thearchivedredologfilesshouldbemovedtosomeotherlocation.D.Thearchivedredologfilesarestillmaintainedbecausethefilenamesareunique.

4.Inyourdatabase，youmaybeforcedtoperformarecoveryusingtheRESETLOGSoptionduringwhichtheredologswouldberesettosequencenumber1.Youwanttoavoidtheoverwritingofoldlogfiles.Whicharchivedlogfilenameformatensuresthis？（）A.%t_%s.dbfB.arch_%t.arcC.arch_%d.arcD.arch_%t_%d.arcE.arch_%d_%s_.dbfF.arch_%t_%s_%r.arc

参考答案和解析
参考答案：C
更多“YouareusingOracleDatabase10g.TheLOG_ARCHIVE_FORMATparameterissetto’LOG%t_%s_%r.dbf’.Whyis%rusedinthefilenameformat?() ”相关问题

  • 第1题：

    You database is running an ARCHIVELOG mode.The following parameter are set in your database instance:LOG_ARCHIVE_FORMAT = arch+%t_%r.arcLOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’DB_RECOVERY_FILE_DEST_SIZE = 50GDB_RECOVERY_FILE = ‘/u01/oradata’Which statement is true about the archived redo log files?（）

    A. They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.

    B. They are created only in the Fast Recovery Area.

    C. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.

    D. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.


    参考答案：B

  • 第2题：

    An operator needs to run a script which will write standard output and standard error to different files. Which of the following commands will successfully perform this task?()

    A. myscript.ksh 1>/tmp/log/script.log 2>/tmp/log/script.err

    B. myscript.ksh $1>/tmp/log/script.log $2>/tmp/log/script.err

    C. myscript.ksh 1>/tmp/log/script.log 2>1 /tmp/log/script/err

    D. myscript.ksh 2>1 /tmp/log/script.log 2> /tmp/log/script.err


    参考答案：A

  • 第3题：

    Inthisscenario，assumethatyouarchivelogs101to104totwoarchivingdestinations，/log1and/log2.Thecontrolfilecontainsarchivedlogrecordsasfollows：

    SequenceFilename

    101/log1/log_1_101.arc

    101/log2/log_1_101.arc

    102/log1/log_1_102.arc

    102/log2/log_1_102.arc

    103/log1/log_1_103.arc

    103/log2/log_1_103.arc

    104/log1/log_1_104.arc

    104/log2/log_1_104.arc

    Youaccidentallydeletelogs102and104fromlog1.Yourunthiscommand：

    BACKUPARCHIVELOGFROMSEQUENCE101UNTILSEQUENCE105；

    Whathappens？（）


    参考答案：D

  • 第4题：

    ASystempadministratorneedstoruntheannualreval.shscript,directingstandarderrorto／var／log／reval.err,andappendingstandardoutto／var／log／reval.log.Howcanthisbeaccomplished()

    A.annualreval.sh2>&1/var/log/reval.log2>/var/log/reval.err

    B.annualreval.sh1>/var/log/reval.log2>/var/log/reval.err

    C.annualreval.sh2>>&1/var/log/reval.log/var/log/reval.err

    D.annualreval.sh1>>/var/log/reval.log2>/var/log/reval.err


    参考答案：D

  • 第5题：

    奥美拉唑的S_(一)-异构体 （ ）


    正确答案：B

相关内容