单选题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？ （）AThe command would return an error because LOG_BUFFER is a static parameter.BThe parameter value would be changed and it would come into effect immediately.CYou need to restart the database so that parameter changes can come into effect.DThe command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.
单选题
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
The command would return an error because LOG_BUFFER is a static parameter.
B
The parameter value would be changed and it would come into effect immediately.
C
You need to restart the database so that parameter changes can come into effect.
D
The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.
参考解析
解析：
暂无解析
相关考题：
You are connected to a pluggable database (PDB) as a common user with DBA privileges.The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:SQL ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE;Which is true about the result of this command?（）A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.B. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.D. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.
In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command： SQLSELECT /*+ RESULT_CACHE */ sale_category， sum（sale_amt） FROM sales GROUP BY sale_category； Where would the result of this query be stored（）？ A、 database buffer cacheB、 shared poolC、 PGAD、 large pool
You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）A、 Increase the value of the FAST_START_MTTR_TARGET initialization parameter.B、 Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.C、 Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.D、 Increase the value of the SGA_TARGET initialization parameter.
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？（）A、 control fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile
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.
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）.
You want to drop the TBS1 tablespace from your database. You also want to delete the corresponding data files automatically， and not have to do it manually. What should you do？（）A、Use the DROP DATAFILE command.B、Use the DROP TABLESPACE command.C、Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.D、Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.
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（）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 theSystem Global Area （SGA）
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？（）A、DatafilesB、 Current control fileC、 Server parameter file （spfile）D、 Password file
You have control-file autobackups enabled. When starting your database from SQL*Plus， you receive the following error message： SQL startup ORA-01078： failure in processing system parameters LRM-00109： could not open parameter file ， C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN， how would you respond to this error？（） A、 Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.B、 Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.C、 Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.D、 Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.E、 Issue the restore spfile from autobackup command from the RMAN prompt.
You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order： 1）Shut down the instance. 2）Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value. 3）Execute the ALTER DATABASE FLASHBACK OFF command. 4）Start up the instance and mount the database. 5）Execute the ALTER DATABASE FLASHBACKON command. 6）Open the database. Select the correct order in which these tasks need to be performed. （）A、2，1，4，3，5，6B、1，4，3，2，6，5C、1，4，2，6，3，5D、3，2，1，4，5，6
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、The command would return an error because LOG_BUFFER is a static parameter.B、The parameter value would be changed and it would come into effect immediately.C、You need to restart the database so that parameter changes can come into effect.D、The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.
You decided to increase the value for the SHARED_SERVERS parameter by using the following command： SQL ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=？； Which three values can be specified for the SCOPE clause？（）A、ALLB、PFILEC、BOTHD、NONEE、SPFILEF、MEMORYG、INSTANCEH、DATABASE
The database was started up using a text parameter file. What will be the default scope of changes made by using the SET clause of the ALTER SYSTEM statement？（）A、Only MEMORY is updated.B、Only SPFILE values are updated.C、Only init.ora parameters are updated.D、Both init.ora parameters and SPFILE values are updated.
单选题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（）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 the System Global Area （SGA）.
单选题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？（）AThe command would return an error because LOG_BUFFER is a static parameter.BThe parameter value would be changed and it would come into effect immediately.CYou need to restart the database so that parameter changes can come into effect.DThe command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.
单选题The database was started up using a text parameter file. What will be the default scope of changes made by using the SET clause of the ALTER SYSTEM statement？（）AOnly MEMORY is updated.BOnly SPFILE values are updated.COnly init.ora parameters are updated.DBoth init.ora parameters and SPFILE values are updated.
单选题You have included the following parameter settings in your SPFILE:// SGA_MAX_SIZE=8G SGA_TARGET=6G DB_CACHE_SIZE=2G SHARED_POOL_SIZE=1G LOG_BUFFER=64M DB_KEEP_CACHE_SIZE=960M Which statement is true if you modify the SGA_TARGET initialization parameter？（）AThe SGA_TARGET initialization parameter cannot be set to a value greater than 8GB The DB_CACHE_SIZE initialization parameter cannot be set to a value less than 2GC The DB_CACHE_SIZE initialization parameter cannot be set to a value greater than 2GD The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value greater than 960M E The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value less than 960M
单选题You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following: SQL ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE; Which is true about the result of this command?（）AThe STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.BThe STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.CThe STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.DNothing happens; because there is no SPFILE for each PDB, the statement is ignored.
单选题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）
单选题You have control-file autobackups enabled. When starting your database from SQL*Plus， you receive the following error message： SQL startup ORA-01078： failure in processing system parameters LRM-00109： could not open parameter file ， C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN， how would you respond to this error？（）A Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.B Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.C Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.D Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.E Issue the restore spfile from autobackup command from the RMAN prompt.
单选题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？（）ADatafilesB Current control fileC Server parameter file （spfile）D Password file
单选题In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command： SQLSELECT /*+ RESULT_CACHE */ sale_category， sum（sale_amt） FROM sales GROUP BY sale_category； Where would the result of this query be stored（）？A database buffer cacheB shared poolC PGAD large pool
多选题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
单选题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.
单选题You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order： 1）Shut down the instance. 2）Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value. 3）Execute the ALTER DATABASE FLASHBACK OFF command. 4）Start up the instance and mount the database. 5）Execute the ALTER DATABASE FLASHBACKON command. 6）Open the database. Select the correct order in which these tasks need to be performed. （）A2，1，4，3，5，6B1，4，3，2，6，5C1，4，2，6，3，5D3，2，1，4，5，6
单选题You want to drop the TBS1 tablespace from your database. You also want to delete the corresponding data files automatically， and not have to do it manually. What should you do？（）AUse the DROP DATAFILE command.BUse the DROP TABLESPACE command.CEnsure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.DEnsure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.
多选题You decided to increase the value for the SHARED_SERVERS parameter by using the following command： SQL ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=？； Which three values can be specified for the SCOPE clause？（）AALLBPFILECBOTHDNONEESPFILEFMEMORYGINSTANCEHDATABASE