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.
第1题:
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?()
第2题:
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()
第3题:
In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:Which authentication method would be used first?()
A. authentication by password file
B. authentication by using certificates over SSL
C. authentication by using the Oracle Internet Directory
D. authentication by using the local OS of the database server
第4题:
You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP; How does RMAN find the control file autobackup?()
第5题:
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()
第6题:
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?()
第7题:
You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP; How does RMAN find the control file autobackup?()
第8题:
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?()
第9题:
You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command?()
第10题:
What are the prerequisites for enabling Flashback Database? ()