单选题You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the stepsthat will be performed later when you open the database: 1. SGA is allocated. 2. Control file is read. 3. Redo log files are read. 4. Instance recovery is started. 5. Background processes are started. 6. Data files are checked for consistency. 7. Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur()A7, 1, 5, 2, 3, 6, 4B1, 2, 3,7, 5, 6, 4C7, 1, 4, 5, 2, 3, 6D1, 7, 5, 4, 2, 3, 6
单选题
You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the stepsthat will be performed later when you open the database: 1. SGA is allocated. 2. Control file is read. 3. Redo log files are read. 4. Instance recovery is started. 5. Background processes are started. 6. Data files are checked for consistency. 7. Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur()
A
7, 1, 5, 2, 3, 6, 4
B
1, 2, 3,7, 5, 6, 4
C
7, 1, 4, 5, 2, 3, 6
D
1, 7, 5, 4, 2, 3, 6
参考解析
解析:
暂无解析
相关考题:
When you see your untidy handwriting, you wish that you ___ everything down a bit more clearly. A、wroteB、had writtenC、writeD、have written
You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance :SQL shutdown immediate;What is the result of executing this command?()A. The ASM instance is shut down, but the other instances are still running.B. It results in an error because other database instances are connected to it.C. All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.D. HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.
What happens if you shutdown abort ASM instance?() A. The RDBMSs connected will shutdown abort tooB. CLUSTER SERVICE will shutdownC. ASM wil do instance recovery after startup
You have just issued the command commit confirmed and your network continues to be operational with no further changes required. You issue a commit and-quit. A short time later, users start complaining about network problems. Which commands (in order) need to be entered to resolve this issue?()A.AB.BC.CD.D
While logged into a router you manually shut down the serial 0 interface using the "shutdown" interface configuration command. You then issue the "show interface serial 0" command in exec mode. What could you expect the status of the serial 0 interface to be?()A. Serial 0 is up, line protocol is upB. Serial 0 is up, line protocol is downC. Serial 0 is down, line protocol is downD. Serial 0 is down, line protocol is upE. Serial 0 is administratively down, line protocol is downF. Serial 0 is administratively down, line protocol is up
While logged into a router you manually shut down the serial 0 interface using the "shutdown" interface configuration command. You then issue the "show interface serial 0" command in exec mode. What could you expect the status of the serial 0 interface to be?()A、Serial 0 is up, line protocol is upB、Serial 0 is up, line protocol is downC、Serial 0 is down, line protocol is downD、Serial 0 is down, line protocol is upE、Serial 0 is administratively down, line protocol is downF、Serial 0 is administratively down, line protocol is up
Which of the following options is true about shutting down an Automatic Storage Management (ASM) instance?() A、 If the SHUTDOWN IMMEDIATE command is issued to the ASM instance, the ASM instance immediately shuts down.B、 If the SHUTDOWN ABORT command is issued to the ASM instance, the ASM instance will shut down all the database instances and then shut down immediately.C、 If the SHUTDOWN NORMAL command is issued to the ASM instance, before shutting down, the ASM instance waits for the dependent database instances to shut down.D、 If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance, the ASM instance passes the same SHUTDOWN command to the dependent database instances, but does not wait for any active transactions to complete before it shuts down.
You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors, such as erroneously dropping users, tables, and important data, to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database, you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors, you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running?()A、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.B、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.C、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.D、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
What is the proper command to shut down the database in a consistent manner?()A、shutdown abort B、shutdown kill C、Shutdown nowait D、shutdown immediateE、shutdown halt
The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof 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
Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario?()A、The instance aborts.B、The database cannot be recovered.C、The database can be recovered by restoring the control files from the backup.D、The database remains opened and you have to shut it down with the ABORT option.E、The database can be restored till the point of the last closed whole database backup.
What happens if you shutdown abort ASM instance?()A、The RDBMSs connected will shutdown abort tooB、CLUSTER SERVICE will shutdownC、ASM wil do instance recovery after startup
There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow. There was only one data file on this disk; it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available?()A、Only bring the tablespace back online.B、Only recover the tablespace and then bring the tablespace back online.C、Shut down the database, recover the data file and then start up the database.D、Issue the ALTER DATABASE RENAME FILE command, recover the tablespace, and then bring the tablespace online.E、Recover the tablespace, issue the ALTER DATABASE RENAME FILE command, and then bring the tablespace online.
You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command: ASMCMD lsdsk -I -d DATA Which statement is true regarding the outcome of this command?()A、The command succeeds but it retrieves only the disk names.B、The command produces an error because the ASM instance is down.C、The command succeeds but it shows only the status of the ASM instance.D、The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.
单选题There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow. There was only one data file on this disk; it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available?()AOnly bring the tablespace back online.BOnly recover the tablespace and then bring the tablespace back online.CShut down the database, recover the data file and then start up the database.DIssue the ALTER DATABASE RENAME FILE command, recover the tablespace, and then bring the tablespace online.ERecover the tablespace, issue the ALTER DATABASE RENAME FILE command, and then bring the tablespace online.
单选题You enter configuration mode with the configure command. You need to abort the changes that you have made and start again with a fresh copy of the active configuration. Which command should you use?()Arollback 0Bload activeCreset configDclear candidate config
单选题You have issued a SHUTDOWN ABORT command to bring down your database instance. Considerthe steps that will be performed later when you open the database: 1:SGA is allocated. 2:Control file is read. 3:Redo log files are read. 4:Instance recovery is started. 5:Background processes are started. 6:Data files are checked for consistency. 7:Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur()A7,1,5,2,3,6,4B1,2,3,7,5,6,4C7,1,4,5,2,3,6D1,7,5,4,2,3,6
单选题You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down: SQL shutdown immediate; What is the result of executing this command?()AAll the instances, including the ASM instance, are shut down in the ABORT modeBThe ASM instance is shut down, but the other instances are still running CThe ASM instance is still functional, but the other instances are shut down DAll the instances, including the ASM instance, are shut down in the IMMEDIATE mode. EHRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode FHRDB, FINDB, and ORGDB instances are shut down in the NORMAL mode and the ASM instance is shut down in the IMMEDIATE mode
单选题While logged into a router you manually shut down the serial 0 interface using the "shutdown" interface configuration command. You then issue the "show interface serial 0" command in exec mode. What could you expect the status of the serial 0 interface to be?()ASerial 0 is up, line protocol is upBSerial 0 is up, line protocol is downCSerial 0 is down, line protocol is downDSerial 0 is down, line protocol is upESerial 0 is administratively down, line protocol is downFSerial 0 is administratively down, line protocol is up
单选题What happens if you shutdown abort ASM instance?()AThe RDBMSs connected will shutdown abort tooBCLUSTER SERVICE will shutdownCASM wil do instance recovery after startup
单选题Which of the following options is true about shutting down an Automatic Storage Management (ASM) instance?()A If the SHUTDOWN IMMEDIATE command is issued to the ASM instance, the ASM instance immediately shuts down.B If the SHUTDOWN ABORT command is issued to the ASM instance, the ASM instance will shut down all the database instances and then shut down immediately.C If the SHUTDOWN NORMAL command is issued to the ASM instance, before shutting down, the ASM instance waits for the dependent database instances to shut down.D If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance, the ASM instance passes the same SHUTDOWN command to the dependent database instances, but does not wait for any active transactions to complete before it shuts down.
单选题You issued the following command on the temporary tablespace LMTEMP in your database: SQLALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M; Which requirement must be fulfilled for this command to succeed?()AThe tablespace must be locally managed.BThe tablespace must have only one temp file.CThe tablespace must be made nondefault and offline.DThe tablespace can remain as the default but must have no active sort operations.
单选题You issued the following command on the temporary tablespace LMTEMP in your database: SQLALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M; Which requirement must be fulfilled for this command to succeed?()A The tablespace must be locally managed.B The tablespace must have only one temp file.C The tablespace must be made nondefault and offline.D The tablespace can remain as the default but must have no active sort operations.
单选题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
多选题Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario?()AThe instance aborts.BThe database cannot be recovered.CThe database can be recovered by restoring the control files from the backup.DThe database remains opened and you have to shut it down with the ABORT option.EThe database can be restored till the point of the last closed whole database backup.
单选题If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode, what will be the result when you issue the command alter database archivelog?()A The alter database archivelog command will failB The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG modeC The alter database archivelog command will succeedD The alter database archivelog command will ask if you want to make the database consistent firstE There is no alter database archivelog command. The correct command is alter database alterlogging
单选题You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the stepsthat will be performed later when you open the database: 1. SGA is allocated. 2. Control file is read. 3. Redo log files are read. 4. Instance recovery is started. 5. Background processes are started. 6. Data files are checked for consistency. 7. Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur()A7, 1, 5, 2, 3, 6, 4B1, 2, 3,7, 5, 6, 4C7, 1, 4, 5, 2, 3, 6D1, 7, 5, 4, 2, 3, 6