网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
$LogFile的记录头标志是“FILE”
参考答案和解析
存取信息;参照记录;错误记录
更多 “$LogFile的记录头标志是“FILE”” 相关考题
考题
Whenperformingadatabaseduplication,whichduplicatedatabaseparameterwouldyousettoensurethattheonlineredologsarecreatedinthecorrectlocation?()
A.log_file_name_convertB.convert_log_file_nameC.file_name_convert_logD.redo_log_file_name_convertE.logfile_convert_directory
考题
Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains oneredo member. When you attempt to start the database, you receive the following errors:ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: ‘D:\REDO01.LOG‘You discover that the online redo log file of the current redo group is corrupted.Which statement should you use to resolve this issue?()A. ALTER DATABASE DROP LOGFILE GROUP 1;B. ALTER DATABASE CLEAR LOGFILE GROUP 1;C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;D. ALTER DATABASE DROP LOGFILE MEMBER ‘D:\REDO01.LOG
考题
You are the Database Administrator (DBA) of your company. You execute the following statement on an Oracle 10g instance: SQL ALTER SYSTEM SWITCH LOGFILE; Which two tasks are performed when the statement is executed? ()A、 The DBWn process writes to the datafile.B、 Changes in the background process are recorded.C、 The log file is updated with the current SCN number.D、 The System Change Number (SCN) is recorded in the control file.E、 The changes to the listener configuration in the listener.ora file are recorded.
考题
APG40的Alog所在目录(),该文件中的内容是()A、K:/Acs/logs/Alog/logfile,commandlog+windowslogB、K:/Aes/logs/Alog/logfile,commandlog+windowslogC、Q:/Acs/logs/Alog/logfile,commandlogD、Q:/Aes/logs/Alog/logfile,commandlog
考题
Pilot Primer6.2测试软件能否处理TEMS测试软件的logfile文件()。A、不能处理B、能处理TEMS的原始Logfile文件C、能处理TEMS导出的FMT格式文件D、能处理TEMS导出的98Logfile格式文件
考题
If a log file becomes corrupted, it may cause the database to stall. How would you correct such a situation?() A、 Recover the online redo log from backup.B、 Delete and re-create the log file.C、 Use the alter database clear logfile command to clear the log file.D、 Shut down the database and restart it.E、 Shut down the database and then mount it. Clear the log file with the alter database clear logfile command and then restart the database with alter database open resetlogs.
考题
使用TEMS测试软件的后台软件GIMS软件时,首先要将TEMS软件前台采集的logfile转化为()格式。A、Text FileB、Logfile TEMS GSM98C、Scan file TEMS GSM98D、Logfile with uplink data
考题
如何强制执行日志切换()A、ALTER SYSTEM CHECKPOINT;B、ALTER SYSTEM CHECKPOINT FORCE;C、ALTER SYSTEM SWITCH LOGFILE;D、ALTER SYSTEM SWITCH LOGFILE FORCE;E、ALTER DATABASE LOG SWITCH;
考题
Your database is in ARCHIVELOG mode. You have two online redo log groups,each of which contains one redo member. When you attempt to start the database, you receive the following errors:()A、 ALTER DATABASE DROP LOGFILE GROUP 1B、 ALTER DATABASE CLEAR LOGFILE GROUP 1C、 ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1D、 ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’
考题
When performing a database duplication, which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location?() A、 log_file_name_convertB、 convert_log_file_nameC、 file_name_convert_logD、 redo_log_file_name_convertE、 logfile_convert_directory
考题
单选题Your database is in ARCHIVELOG mode. You have two online redo log groups,each of which contains one redo member. When you attempt to start the database, you receive the following errors:()A
ALTER DATABASE DROP LOGFILE GROUP 1B
ALTER DATABASE CLEAR LOGFILE GROUP 1C
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1D
ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’
考题
单选题Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'D:/REDO01.LOG' You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?()A
ALTER DATABASE DROP LOGFILE GROUP 1;B
ALTER DATABASE CLEAR LOGFILE GROUP 1;C
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;D
ALTER DATABASE DROP LOGFILE MEMBER 'D:/REDO01.LOG
考题
多选题You are the Database Administrator (DBA) of your company. You execute the following statement on an Oracle 10g instance: SQL ALTER SYSTEM SWITCH LOGFILE; Which two tasks are performed when the statement is executed? ()AThe DBWn process writes to the datafile.BChanges in the background process are recorded.CThe log file is updated with the current SCN number.DThe System Change Number (SCN) is recorded in the control file.EThe changes to the listener configuration in the listener.ora file are recorded.
考题
单选题Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further?()A
RECOVER LOGFILE BLOCK GROUP 2;B
ALTER DATABASE DROP LOGFILE GROUP 2;C
ALTER DATABASE CLEAR LOGFILE GROUP 2;D
ALTER DATABASE RECOVER LOGFILE GROUP 2;E
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;
考题
单选题You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database, you want to determine the log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task?()A
the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY viewB
the column of the V$INSTANCE_RECOVERY viewC
the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY viewD
the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view
考题
单选题If a log file becomes corrupted, it may cause the database to stall. How would you correct such a situation?()A
Recover the online redo log from backup.B
Delete and re-create the log file.C
Use the alter database clear logfile command to clear the log file.D
Shut down the database and restart it.E
Shut down the database and then mount it. Clear the log file with the alter database clear logfile command and then restart the database with alter database open resetlogs.
考题
单选题When performing a database duplication, which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location?()A
log_file_name_convertB
convert_log_file_nameC
file_name_convert_logD
redo_log_file_name_convertE
logfile_convert_directory
考题
单选题You work as a database administrator for Certkiller .com. Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further?()A
RECOVER LOFIEL BLOCK GROUP 2;B
ALTER DATABASE DROP LOGFILE GROUP 2;C
ALTER DATABASE CLEAR LOGFILE GROUP 2;D
ALTER DATABASE RECOVER LOGFILE GROUP 2;E
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;
考题
单选题如何强制执行日志切换()A
ALTER SYSTEM CHECKPOINT;B
ALTER SYSTEM CHECKPOINT FORCE;C
ALTER SYSTEM SWITCH LOGFILE;D
ALTER SYSTEM SWITCH LOGFILE FORCE;E
ALTER DATABASE LOG SWITCH;
热门标签
最新试卷