（单选题）
our database instance is started using the server parameter file （SPFILE）. You executed a command tochange the value of the LOG_BUFFER initialization parameter：ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH； What would be the outcome of this command（）
AThe command succeeds only if Automatic Memory Management is not enabled.
BThe command succeeds， but you need to restart the database for changes to take effect.
CThe command returns an error because the size of the redo log buffer cannot be changed dynamically.
DThe parameter value is changed and it comes into effect as soon as space becomes available in theSystem Global Area （SGA）
正确答案
答案解析
略
相似试题
（多选题）
our database is in the MOUNT state and you execute the following command to open it： ALTER DATABASE OPEN What two actions are performed as a result of this command？（）
（单选题）
Which statement is true about a whole consistent database backup on a database running in ARCHIVELOGmode（）
（单选题）
You issued the following command on the temporary tablespace LMTEMP in your database： SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M； Which requirement must be fulfilled for this command to succeed？（）
（单选题）
You execute this command in MOUNT mode： ALTER DATABASE ARCHIVELOG； Where is the information that the database is now in ARCHIVELOG mode stored？（）
（多选题）
You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）
（单选题）
You created a database by using the Database Configuration Assistant. What must you do to access a user account in the sample schemas？（）
（多选题）
Examine the following command that is used to duplicate a database on the same host： RMAN> RUN { ALLOCATE AUXILIARY CHANNEL， aux 1 DEVICE TYPE DISK； DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY； / } Which two statements describe the effect after the database is duplicated successfully？（）
（单选题）
our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）
（单选题）
You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically. Which tool or utility would you use to achieve this？ （）
