单选题Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH; What would be the outcome of this command？（）A Th

题目内容(请给出正确答案)

单选题

Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH; What would be the outcome of this command？（）

The command would return an error because LOG_BUFFER is a static parameter.

The parameter value would be changed and it would come into effect immediately.

You need to restart the database so that parameter changes can come into effect.

The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.

参考答案和解析

正确答案： A

解析：暂无解析

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

单选题You work as a database administrator for Certkiller .com. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task？（）A Shut down the instance， copy the control file to the third location and open the database.B Abort the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.C Copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile， restart the instance and open the database.D Shut down the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.E Shut down the instance， startup in the mount state， copy the control file to the third location， modify the CONTROL_FILES parameter ininit.oraand open the database.

点击查看答案
第2题

单选题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， 4B 1， 2， 3，7， 5， 6， 4C 7， 1， 4， 5， 2， 3， 6D 1， 7， 5， 4， 2， 3， 6

点击查看答案
第3题

单选题Your database instance is started using the server parameter file （SPFILE）. You executed acommand to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH； What would be the outcome of this command（）A The command succeeds only if Automatic Memory Management is not enabled.B The command succeeds， but you need to restart the database for changes to take effect.C The command returns an error because the size of the redo log buffer cannot be changed dynamically.D The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area （SGA）.

点击查看答案
第4题

单选题You used the IMMEDIATE option to shut down your database instance. Consider the steps that mayoccur when a database instance is started and database is opened： 1：SGA is allocated. 2：Control file is read. 3：Redo log files are opened. 4：Instance recovery is started. 5：Background processes are started. 6：Data file headers 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，4B 1，5，7，2，3，6；step 4 is not requiredC 7，1，5，2，3，6；step 4 is not requiredD 1，2，3，5，6，4；step 7 is not required

点击查看答案
第5题

单选题After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?（）A Opening the database in RESTRICTED modeB Opening the database with the RESETLOGS optionC Setting a new DBID for the newly restored databaseD Restoring the server parameter file (SPFILE) to the new host

点击查看答案
第6题

多选题Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN> BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）Acontrol fileBall datafilesCpassword fileDonline redo log fileEarchive redo log fileFserver parameter fileGonly the SYSTEM datafile

点击查看答案
第7题

单选题You used the IMMEDIATE option to shut down your database instance. Consider the steps that may occurwhen a database instance is started and database is opened： 1. SGA is allocated. 2. Control file is read. 3. Redo log files are opened.4. Instance recovery is started. 5. Background processes are started. 6. Data file headers 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， 4B 1， 5， 7， 2， 3， 6； step 4 is not requiredC 7， 1， 5， 2， 3， 6； step 4 is not requiredThis document was downloaded from =>> http：//www.amaderforum.comD 1， 2， 3， 5， 6， 4； step 7 is not required

点击查看答案

Your database is started by using the server parameter file

题目内容(请给出正确答案)

参考答案和解析

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容