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？ （）

单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Youdeterminethatarchivingwasnotsuccessfulinoneofthedestinators.Youwanttocheckthealertlogfileformoreinformationonthis.Whichinitializationparametergivesyouthelocationofthealertlogfile？（）

A.USER_DUMP_DEST
B.CORE_DUMP_DEST
C.ALERT_LOG_DEST
D.ALERT_DUMP_DEST
E.TRACE_DUMP_DEST
F.BACKGROUND_DUMP_DEST

单项选择题You executed the following command to back up your control file：  ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  Which initialization parameter is used to specify the location of the trace file？（）

A.USER_DUMP_DEST
B.CORE_DUMP_DEST
C.TRACE_DUMP_DEST
D.BACKUP_DUMP_DEST
E.BACKGROUND_DUMP_DEST

单项选择题The HR user creates a view with this command：  SQL> CREATE VIEW emp_v AS SELECT * FROM scott.emp；  Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user.  Which statement is true in this scenario？（）

A.HR can grant the privilege to JIM but without GRANT OPTION.
B.HR can grant the privilege to JIM because HR is the owner of the view.
C.SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.
D.HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.

多项选择题Datafilesofwhichthreetablespacescanberecoveredbyperforminganopenrecovery？（）

A.TEMP
B.UNDO
C.INDEX
D.SYSAUX
E.SYSTEM

单项选择题Youareworkingonthe24X7databasewithhightransactionvolume，toensurefasterinstancerecoveryonyourdatabaseyousettheFAST_START_MTTR_TARGETinitializationparametertoaverylowvalue.Whateffectitwillhaveonthedatabase？（）

A.The database performance would be enhanced.
B.The redo log files would be get filled more frequently.
C.The overall database performance would be degraded.
D.The mean time to recover （MTTR） would be increased.