单项选择题
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）
相关考题
-
单项选择题
YouareworkingonaninstancestartedusingtheSPFILE.YouwanttomovetheFlashRecoveryAreaofyourdatabasetoanewlocation.YouwanttheFlashbacklogfilestobestoredinthenewlocation.Givenbeloware thestepstoaccomplishthetaskinrandomorder： 1.Shutdowntheinstance. 2.ChangethevalueoftheDB_RECOVERY_FILE_DESTinitializationparametertoanewvalue. 3.ExecutetheALTERDATABASEFLASHBACKOFFcommand. 4.Startuptheinstanceandmountthedatabase. 5.ExecutetheALTERDATABASEFLASHBACKONcommand. 6.Openthedatabase. Selectthecorrectorderinwhichthesetasksneedtobeperformed.（）
A.2，1，4，3，5，6
B.1，4，3，2，6，5
C.1，4，2，6，3，5
D.3，2，1，4，5，6 -
单项选择题
Note the following structures in your database server： 1.Extents 2.OS Blocks 3.Tablespace 4.Segments 5.Oracle Data Block Which option has the correct arrangement of these structures from the smallest to the largest（）
A.2，5，1，4，3
B.1，2，3，4，5
C.5，2，1，3，4
D.2，1，5，4，3 -
单项选择题
You executed this command to create a temporary table： SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddateDATE， class CHAR（20）） ON COMMIT PRESERVE ROWS； Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction（）
A.The rows stay in the table only until session termination.
B.The rows stay in the table only until the next transaction starts on the table.
C.The rows are visible to all current sessions after the transaction is committed.
D.The rows stay available for subsequent sessions after the transaction is committed
