单项选择题

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.

<上一题目录下一题>

热门试题

单项选择题YouaremaintaininganOLTPdatabaseinOracle10g.YousetthevalueoftheLOG_ARCHIVE_TRACEparametertozero.Whatistheimpactofthissetting？（）

A. The trace files will be disabled only for a specific session.
B. Tracing will be disabled for a client identifier.
C. Tracing will be disabled only for the ARCn process.
D. The SQL Trace facility will be disabled for the instance.

单项选择题YouaremaintaininganOLTPdatabaseinOracle10g.Youfindthatthedatabaseisgeneratingalargenumberoftracefiles.YoudecidetodisablethetracefilesgeneratedbytheARCnbackgroundprocess.WhichactionwillenableyoutodisablethetracefilesgeneratedbytheARCnbackgroundprocess？（）

A. Remove the LOG_ARCHIVE_DEST parameter from the init.ora file.
B. Set the value of the SQL_TRACE parameter to FALSE in the init.ora file.
C. Use the DBMS_MONITOR.SESSION_TRACE_DISABLE procedure.
D. Set the value of the LOG_ARCHIVE_TRACE initialization parameter to zero.

单项选择题You have created a locally managed tablespace by issuing the following command： CREATE TABLESPACE data1 DATAFILE ’data1_file1.dbf’ SIZE 10M AUTOEXTEND ON MAXSIZE UNLIMITED； For the DATA1 tablespace， you have set the warning level alert limit to 70 percent. In which situation will a warning level alert be generated？（）

A. when 700 KB is used
B. when 700 KB is left as free space
C. when 7MB is used
D. when 7MB is left as free space
E. no alert will be generated because an autoextensible datafile is included in the tablespace

单项选择题Matthew has recently joined NetFx Corporation as a junior-level Database Administrator （DBA）. He is asked by his supervisor to verify the database for data block corruptions. He uses the DBVERIFY utility and finds that two data blocks are corrupted in the database. What should Matthew use to identify the corrupted blocks as well as datafiles containing these blocks？（）

A. datafile
B. alert log
C. dynamic views
D. control file script

单项选择题Whileperformingmonitoringandtuningthedatabase，youwanttoviewthesummarizedinformationaboutthewarninglevelalertsandcriticallevelalerts.WhichsectionoftheOracleEnterprisemanagerdisplaysthesummarizedinformationaboutthewarningandcriticallevelalerts？（）

A.General
B. High Availability
C. Space Usage
D. Diagnostic Summary