单项选择题
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 using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）
A.use the external table population
B.use the Oracle Data Pump export and import utility
C.use the conventional path data load of SQL*Loader utility
D.use the direct path data load of Oracle export and import utility -
单项选择题
YourdatabaseisinNOARCHIVELOGmodeandalogswitchhappensevery20minutes.OnThursdaymorning，mediafailureresultedincorruptionofadatafilebelongingtotheTOOLStablespace.BackupsaretakenoneverySunday.Whatwouldyoudointhissituation？（）
A.recover using Oracle Flashback Database technology
B.restore the data files from backup and perform a complete recovery
C.restore only the corrupted data file and perform tablespace recovery
D.restore the data files from backup and perform cancelbased recovery
E.restore the entire database from the most recent backup and start the instance and open the database -
单项选择题
WhichstatementistrueaboutthelossofsystemcriticaldatafilesinARCHIVELOGmode？（）
A.The data files can be recovered till the last committed transaction.
B.The data files can be recovered without shutting down the database.
C.The data file is taken offline automatically; the database remains open.
D.The data files can be recovered to the time of the most recent backup.
