Oracle认证考试
Archive file format LOG_ARCHIVE_FORMAT is defined as arch_%s.arc. A week ago， you just archived arch_4.arch to tape， then removed all archived files to save disk space. Yesterday you saw arch_10.arc and arch_11.arc on the disk. Today， you see arch_3.arc
题目
Archive file format LOG_ARCHIVE_FORMAT is defined as arch_%s.arc. A week ago， you just archived arch_4.arch to tape， then removed all archived files to save disk space. Yesterday you saw arch_10.arc and arch_11.arc on the disk. Today， you see arch_3.arc in the archive directory. Which two could you happened？（）
- A、Redo logs were restored from tape for recovery.
- B、The file names are only used when they are copied to tape.
- C、The database was opened with the RESETLOGS option and log numbers restarted.
- D、Log names run in circular fashion; arch_3.arc is re-created by the ARCn process.
- E、A file name is randomly chosen by the archive process; as long as it is unique, it does not have to be sequential.
参考答案和解析
相似问题和答案
第1题：
ThedatabaseisrunninginARCHIVELOGmodeandtheFORMAToptionisnotconfiguredinRMANfordiskbackups.YouconfiguredtheflashrecoveryarealocationandsizebyusingtheDB_RECOVERY_FILE_DESTandDB_RECOVERY_FILE_DEST_SIZEinitializationparameters.Whichstatementiscorrectinthisscenario？（）
A.IftheFORMAToptiontotheRMANBACKUPcommandisspecified，thenRMANcreatesbackuppiecesandimagecopiesintheflashrecoveryareawithnamesintheOracleManagedFiles（OMF）format.
B.IfanylocaldestinationsforLOG_ARCHIVE_DEST_nareset，thenarchivedredologsarestoredinthesedestinationsaswellasintheflashrecoveryarea.
C.IftheflashrecoveryarealocationisconfiguredusingtheDB_RECOVERY_FILE_DESTinitializationparameter，thentheRMANbackupofOraclemanageddatafiles（OMF）onlywillgototheflashrecoveryareabydefault.
D.Ifnootherdestinationisconfiguredforrecoveryfiles，thenRMANplacesthecontrolfileautobackupsintheflashrecoveryareabydefault.
第2题：
A. Deleted
B. Unchanged
C. Set
D. Copied
第3题：
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_SIZE
B.CONTROL_FILES
C.LARGE_POOL_SIZE
D.LOG_ARCHIVE_DEST
E.LOG_ARCHIVE_FORMAT
F.DB_CREATE_FILE_DEST
第4题：
Which of the following are contained in a store archive？（）
- A、a JAR file containing commands and JSPs
- B、an XML file defining the content of the store archive
- C、a ZIP file of Java properties files containing translated text
- D、a database backup file used to define store data
- E、a number of ZIP files used to define store data
正确答案:B,C,E
第5题：
After performing a copy backup of a file server， the archive bit on the backed up files will be which of the following？（）
- A、 Deleted
- B、 Unchanged
- C、 Set
- D、 Copied
正确答案:B
第6题：
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.
第7题：
A corrupted file system is now repaired and back in use. Some， but not all of the files within the file systems have been deleted. The only backup of this file system is a month-old tar archive. This archive will need to be restored as root. Which two statements correctly describe the effects of the restore operation？（）
- A、 Files found in the file system that are also on tape will NOT be overwritten.
- B、 The missing files， present on the backup tape， are restored to the file system with the data as it was when the backup was taken.
- C、 The access times are preserved by tar and will reflect the time when a user last accessed the data.
- D、 The modification time on the files restored by tar will be preserved and will reflect the time the file was last modified before the backup， NOT the time of the restore operation.
正确答案:B,D
第8题：
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.
第9题：
Which of the following is a benefit of the IBM Long Term File System (LTFS)? （）
- A、management of the library files
- B、management of the encryption keys and archives
- C、helps to reduce tape, file management and archive costs
- D、helps to control the write speed matching on LTO-4 drives
正确答案:C
第10题：
Which of the following are TRUE about a store archive？（）
- A、It is an XML file containing store data assets
- B、It uses the same file format as a ZIP file
- C、It contains file assets to create a store or site
- D、It can easily be copied from one machine to another
- E、It can contain WebSphere Commerce instance configuration information
正确答案:B,C,D