网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
多选题
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.
参考答案
参考解析
解析:
暂无解析
更多 “多选题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?()ARedo logs were restored from tape for recovery.BThe file names are only used when they are copied to tape.CThe database was opened with the RESETLOGS option and log numbers restarted.DLog names run in circular fashion; arch_3.arc is re-created by the ARCn process.EA file name is randomly chosen by the archive process; as long as it is unique, it does not have to be sequential.” 相关考题
考题
YouwantanASMinstancetomanagethefilesofyourdatabase.Toachievethisobjective,youspecifythefollowingparametersintheparameterfileofthedatabase:INSTANCE_TYPE=RDBMSDB_NAME=PRODLARGE_POOL_SIZE=8MBDB_BLOCK_SIZE=4KLOG_ARCHIVE_DEST=+dgroupALOG_ARCHIVE_FORMAT=$ORACLE_SID_%s_%t.%tDB_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
考题
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.
考题
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.
考题
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.
考题
An administrator is configuring a new cluster and has a requirement for a notification to be generated if the /tmp File System becomes greater than 90% full. Which of the following PowerHA components will support theadministrator’s requirement?()A、Pre-defined EventsB、User-defined EventsC、Remote notification methodsD、The integration between RMC and WebSM
考题
Which of the following are TRUE about a store archive?()A、It is an XML file containing store data assetsB、It uses the same file format as a ZIP fileC、It contains file assets to create a store or siteD、It can easily be copied from one machine to anotherE、It can contain WebSphere Commerce instance configuration information
考题
The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server: LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST = ’/u01/oradata’ DB_RECOVERY_FILE_DEST_SIZE = 20G Which statement is true regarding the archived redo log files()A、It will be created on the local file system.B、It will be created only in the Flash Recovery Area.C、It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the defaultlocation $ORACLE_HOME/dbs.D、It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and locationspecified by the DB_RECOVERY_FILE_DEST parameter.
考题
You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to ’LOG%t_%s_%r.dbf’. Why is %r used in the file name format?() A、to uniquely identify the archived log files with the restore operationB、to uniquely identify the archived log files with the redo log group numberC、to uniquely identify the archived log files for each incarnation of the databaseD、to uniquely identify the archived log files with the number of recovery operations performed
考题
You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’. Which statement regarding the archived redo log files, created in an earlier incarnation of the database,is true?()A、 The archived redo log files will be overwritten.B、 The archived redo log files are deleted automatically.C、 The archived redo log files should be moved to some other location.D、 The archived redo log files are still maintained because the file names are unique.
考题
A customer stores environmental settings in the deployment descriptors of an application. Whenever they promote the application version from testing to the production environment, they need to open the archive and modify the deployment descriptor. This process is against their security policy. What approach should you recommend to leverage WebLogic features such that they do not have to modify the application archive for different environments?()A、Keep environmental data in the global settings of domain and the application can read it from the domain where it runs.B、Keep environmental data in Deployment Plan XML files. It allows you to change parameters in the deployment descriptor without opening the archive file.C、Keep environmental data in the database because it is the most effective way of parametrizing the environment. D、Keep archive in exploded format so the customer does not have to open the archive files.E、Eliminate all environmental settings from the application. There should not to be any environmental settings in the application.
考题
In your database, you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. You want to avoid the overwriting of old log files. Which archived log file name format ensures this? ()A、%t_%s.dbfB、arch_%t.arcC、arch_%d.arcD、arch_%t_%d.arcE、arch_%d_%s_.dbfF、arch_%t_%s_%r.arc
考题
Which backup option defines a user-defined name for a backup? ()A、FORMATB、NAMEC、TAGD、FORMAT U%
考题
Which statement is true regarding remote archive log file destinations?()A、Only two destinations per remote database can be specified.B、Destination is an Oracle Net alias specified by using the SERVICE keyword.C、The REOPEN attribute must be used when using remote archive log file destinations.D、The service name is resolved by searching sqlnet.ora file for the remote database name.
考题
You have some compressed bitmap files in a directory of your Windows 2000 Professional computer. The file compression has reduced their size from 2 MB to 1 MB. You attempt to copy them to a floppy disk, but an error reports that the destination drive is full. How can you copy the bitmap files to a 1.44 MB floppy disk? ()A、Use a third-party file compression utility to create a compressed archive containing the bitmap files. Copy the compressed archive to the floppy disk.B、Create an empty compressed folder on the floppy disk, and copy the files to the new folder.C、Format the floppy disk as NTFS, and restart the copy operation.D、Confirm that the cluster size on the NTFS volume is greater than 32k.
考题
You configured automatic archive logging for the database. On the next startup the database runs for a while, but then hangs. After checking the alert log, you determine that all the online redo logs need archiving. Which step was skipped when you set up automatic archive log?()A、LOG_ARCHIVE_DEST was not set in the parameter file.B、LOG_ARCHIVE_START was not set in the parameter file.C、alter database archivelog; was not executed in MOUNT mode.D、LOG_ARCHIVE_MAX processes were not set in the parameter file.
考题
单选题You configured automatic archive logging for the database. On the next startup the database runs for a while, but then hangs. After checking the alert log, you determine that all the online redo logs need archiving. Which step was skipped when you set up automatic archive log?()A
LOG_ARCHIVE_DEST was not set in the parameter file.B
LOG_ARCHIVE_START was not set in the parameter file.C
alter database archivelog; was not executed in MOUNT mode.D
LOG_ARCHIVE_MAX processes were not set in the parameter file.
考题
单选题You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’. Which statement regarding the archived redo log files, created in an earlier incarnation of the database,is true?()A
The archived redo log files will be overwritten.B
The archived redo log files are deleted automatically.C
The archived redo log files should be moved to some other location.D
The archived redo log files are still maintained because the file names are unique.
考题
单选题The database is running in ARCHIVELOG mode and the FORMAT option is not configured in RMAN for disk backups. You configured the flash recovery area location and size by using the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE initialization parameters. Which statement is correct in this scenario?()A
If the FORMAT option to the RMAN BACKUP command is specified, then RMAN creates backup pieces and image copies in the flash recovery area with names in the Oracle Managed Files (OMF) format.B
If any local destinations for LOG_ARCHIVE_DEST_n are set, then archived redo logs are stored in these destinations as well as in the flash recovery area.C
If the flash recovery area location is configured using the DB_RECOVERY_FILE_DEST initialization parameter, then the RMAN backup of Oracle managed datafiles (OMF) only will go to the flash recovery area by default.D
If no other destination is configured for recovery files, then RMAN places the control file autobackups in the flash recovery area by default.
考题
单选题You want an ASM instance to manage the files of your database. To achieve this objective, you specify the following parameters in the parameter file of the database: INSTANCE_TYPE = RDBMS DB_NAME = PROD LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA Which parameter would be ignored while starting up the instance for the database PROD?()A
LARGE_POOL_SIZEB
DB_CREATE_FILE_DESTC
LOG_ARCHIVE_DESTD
CONTROL_FILESE
LOG_ARCHIVE_FORMATF
DB_BLOCK_SIZE
考题
多选题Which of the following are TRUE about a store archive?()AIt is an XML file containing store data assetsBIt uses the same file format as a ZIP fileCIt contains file assets to create a store or siteDIt can easily be copied from one machine to anotherEIt can contain WebSphere Commerce instance configuration information
考题
多选题Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true?()AThe destination must be global only.BA maximum of five destinations can be assigned.CA maximum of ten different destinations can be assigned.DAll the destinations are determined by the server automatically.EThe destination may be local or remote for a Standby Database.FThe destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.
考题
单选题The database is configured for automatic archive logging. Along with the other required parameters, this entry is in the initialization file:log_archive_dest2="SERVICE=standby_db1 MANDATORY REOPEN=600" From where does the database resolve standby_db1?()A
control fileB
tnsnames.oraC
data dictionaryD
initialization parameter file
考题
单选题When you are allowing RMAN to backup your archived redo log files,how does RMAN know which archived redo logs to back up from your archive log destination?()A
RMAN keeps a list of archive logs in a text file.B
The DBA must manually tell RMAN which archive logs to backup.C
RMAN has access to target control file and/or catalog information.D
RMAN looks at the ARCHIVE_LOG_DEST parameter of your target database and backs up all archive logs found.
考题
单选题You database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST_SIZE = 50G DB_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.
考题
单选题You want an ASM instance to manage the files of your database. To achieve this objective, you specify the following parameters in the parameter file of the database: INSTANCE_TYPE = RDBMS DB_NAME = PROD LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA Which parameter would be ignored while starting up the instance for the database PROD?()A
DB_BLOCK_SIZEB
CONTROL_FILESC
LARGE_POOL_SIZED
LOG_ARCHIVE_DESTE
LOG_ARCHIVE_FORMATF
DB_CREATE_FILE_DEST
考题
单选题The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server: LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST = ’/u01/oradata’ DB_RECOVERY_FILE_DEST_SIZE = 20G Which statement is true regarding the archived redo log files()A
It will be created on the local file system.B
It will be created only in the Flash Recovery Area.C
It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the defaultlocation $ORACLE_HOME/dbs.D
It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and locationspecified by the DB_RECOVERY_FILE_DEST parameter.
考题
单选题You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to ’LOG%t_%s_%r.dbf’. Why is %r used in the file name format?()A
to uniquely identify the archived log files with the restore operationB
to uniquely identify the archived log files with the redo log group numberC
to uniquely identify the archived log files for each incarnation of the databaseD
to uniquely identify the archived log files with the number of recovery operations performed
热门标签
最新试卷