You are maintaining the PROD database of NetFx Corporation. You set the value of the SQL_TRACE parameter to TRUE. What will be the impact of this setting?()
- A、 The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the USER_DUMP_DEST directory.
- B、 The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the USER_DUMP_DEST directory.
- C、 The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the BACKGROUND_DUMP_DEST directory.
- D、 The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the BACKGROUND_DUMP_DEST directory.
正确答案:A
答案解析:有

微信扫一扫手机做题