单选题You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?（）A ALTER DATABASE B ALTER SYSTEM C ALTER USER D ALTER REDO LOG

题目

单选题

You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?（）

ALTER DATABASE

ALTER SYSTEM

ALTER USER

ALTER REDO LOG

参考答案和解析

正确答案： B

解析：暂无解析

更多“单选题You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?（）A ALTER DATABASE B ALTER SYSTEM C ALTER USER D ALTER REDO LOG”相关问题

第1题

Upon starting your database， you receive the following error： SQL> startup ORACLE instance started. Total System Global Area 171581440 bytes Fixed Size 1298640 bytes Variable Size 146804528 bytes Database Buffers 20971520 bytes Redo Buffers 2506752 bytes Database mounted. ORA-00313： open failed for members of log group 1 of thread 1 ORA-00312： online log 1 thread 1： ’/oracle01/oradata/orcl/redo01.log’ ORA-00312： online log 1 thread 1： ’/oracle01/oradata/orcl/redo01a.log’ You can choose from the following steps： a. Restore the database datafiles. b. Issue the alter database clear unarchived logfile group 1 command. c. Issue the alter database open command. d. Issue the alter database open resetlogs command. e. Recover the database using point-in-time recovery. f. Issue the Startup Mount command to mount the database. g. Back up the database. Which is the correct order of these steps in this case？（）A、a， f， e， d， gB、f， e， dC、f， b， c， gD、a， f， cE、The database cannot be recovered.

点击查看答案
第2题

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file： ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3； Which action should you perform immediately after using this command？（） A、 You should perform a log switchB、 You should make a backup of the databaseC、 You should switch the database to the NONARCHIVELOG modeD、 You should shut down the database instance and perform a complete database recovery

点击查看答案
第3题

如何强制执行日志切换（）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;

点击查看答案
第4题

You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?（）A、ALTER DATABASE B、ALTER SYSTEM C、ALTER USER D、ALTER REDO LOG

点击查看答案
第5题

To allocate another role to a user, which command is most appropriate?（）A、ALTER USER B、ALTER DATABASE C、ALTER SYSTEM D、GRANT

点击查看答案
第6题

When performing an online backup，what is the proper order of the following steps？（） a. Issue the alter database end backup command. b. Back up the archived redo logs. c. Issue the alter database begin backup command. d. Back up the database files. e. Determine the beginning log sequence number. f. Determine the ending log sequence number. g. Force a log switch with the alter system switch logfile command.A、a， b， c， d， e， f， gB、c， d， a， b， e， g， fC、f， d， b， g， a， c， eD、e， c， d， a， g， f， bE、a， f， b， g， e， c， d

点击查看答案
第7题

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’

点击查看答案

单选题You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?（）A ALTER DATABASE B ALTER SYSTEM C ALTER USER D ALTER REDO LOG

题目

参考答案和解析

更多“单选题You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?（）A ALTER DATABASE B ALTER SYSTEM C ALTER USER D ALTER REDO LOG”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容