网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?（）
A
None of the data definition language (DDL) statements are logged in the trace file.
B
Only DDL commands that resulted in errors are logged in the alert log file.
C
A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.
D
Only DDL commands that resulted in the creation of new database files are logged.
参考答案
参考解析
解析：
暂无解析
更多 “单选题Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?（）A None of the data definition language (DDL) statements are logged in the trace file.B Only DDL commands that resulted in errors are logged in the alert log file.C A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.D Only DDL commands that resulted in the creation of new database files are logged.” 相关考题
考题
Examine the following command;ALTER SYSTEM SET enable_ddl_logging = TRUE;Which statement is true?()
A. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.B. All DDL commands are logged in the alert log file.C. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.D. Only DDL commands that resulted in the creation of new segments are logged.E. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
考题
Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?()
A. None of the data definition language (DDL) statements are logged in the trace file.B. Only DDL commands that resulted in errors are logged in the alert log file.C. A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.D. Only DDL commands that resulted in the creation of new database files are logged.
考题
Which of the following commands will show the users that are logged on a system ?()
A. idB. whoC. whoisD. lsuser
考题
When does a transaction complete?（）A、when a DELETE statement is executed B、when a ROLLBACK command is executed C、when a PL/SQL anonymous block is executed D、when a data definition language (DDL) statement is executed E、when a TRUNCATE statement is executed after the pending transact ion
考题
You are the newly appointed system administrator at Certkiller.com. The previous administratorcreated a Microsoft ASP.NET application using Microsoft .NET Framework v3.5. You need to capture the timing and performance information of the application. Managementwants you to make sure that data is only accessible when a client is logged onto the Web servernot the individual Web pages. What should you do？（）A、You should consider adding compilation debug="true" / to the Web.config file.B、You should consider adding compilation debug="false" urlLinePragmas="true" / to theWeb.config file.C、You should consider adding trace enabled="true" writeToDiagnosticsTrace="true"pageOutput="true" localOnly="true" / to the Web.config file.D、You should consider adding trace enabled="true" pageOutput="false" localOnly="true" / tothe Web.config file.
考题
Which of the following commands should be used to watch system errors as they are logged？（）A、 errpt -cB、 tail -f /var/adm/ras/errlogC、 syslogd -dD、 /usr/lib/errdemon -s 8192
考题
Which of the following commands will show the users that are logged on a system ?（）A、idB、whoC、whoisD、lsuser
考题
Which of the following commands can be used to watch system errors as they are logged？（）A、 smit errptB、 smit errdemonC、 smit alogD、 smit syslogd
考题
Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?（）A、None of the data definition language (DDL) statements are logged in the trace file.B、Only DDL commands that resulted in errors are logged in the alert log file.C、A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.D、Only DDL commands that resulted in the creation of new database files are logged.
考题
Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?（）A、Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.B、All DDL commands are logged in the alert log file.C、All DDL commands are logged in a different log file that contains DDL statements and their execution dates.D、Only DDL commands that resulted in the creation of new segments are logged.E、All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
考题
Examine the commands executed to monitor database operations: $ conn sys oracle/oracle@prod as sysdba SQL VAR eid NUMBER SQL EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING = ‘Y’); Which two statements are true?（）A、Database operations will be monitored only when they consume a significant amount of resource.B、Database operations for all sessions will be monitored.C、Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.D、Only DML and DDL statements will be monitored for the session.E、All subsequent statements in the session will be treated as one database operation and will be monitored.
考题
Examine the following query output: You issue the following command to import tables into the hr schema: $ impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）A、All database operations performed by the impdp command are logged.B、Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.C、Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.D、None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.
考题
Which two statements are true about standard database auditing（）A、DDL statements can be audited.B、Statements that refer to stand-alone procedure can be audited.C、Operations by the users logged on as SYSDBA cannot be audited.D、Only one audit record is ever created for a session per audited statement even though it is executedmore than once.
考题
Examine the following statement that is used to modify the constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）A、The constraint remains valid.B、The index on the constraint is dropped.C、It allows the loading of data into the table using SQL*Loader.D、New data conforms to the constraint， but existing data is not checkedE、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?（）A、Every SQL statement in the STS is considered only once for executionB、The SQL statements in the STS are executed concurrently to produce the execution plan and execution statisticsC、The execution plan and execution statistics are computed for each SQL statement in the STSD、The effects of DDL and DML are considered to produce the execution plan and execution statistics
考题
What are three benefits of performing data definition language （DDL） statements against a partitioned table with the UPDATE GLOBAL INDEXES clause？（）A、Global indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with the UNUSABLE status. B、You do not have to search for invalid global indexes after the DDL command completes and rebuild them individually. C、Global indexes are maintained during the operation of the DDL command and therefore can be used by any concurrent query. D、Global indexes remain intact and available for use by data manipulation language （DML） statements even for sessions that have not enabled the skipping of unusable indexes.
考题
In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level. You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated.How do you achieve this objective？（）A、 by setting the SQL_TRACE parameter to FALSE in the parameter fileB、 by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user sessionC、 by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user sessionD、 by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session
考题
单选题Which of the following commands can be used to watch system errors as they are logged？（）A
smit errptB
smit errdemonC
smit alogD
smit syslogd
考题
单选题In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level. You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated. How do you achieve this objective？（）A
by setting the SQL_TRACE parameter to FALSE in the parameter fileB
by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user sessionC
by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user sessionD
by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session
考题
多选题When does a transaction complete?（）Awhen a DELETE statement is executedBwhen a ROLLBACK command is executedCwhen a PL/SQL anonymous block is executedDwhen a data definition language (DDL) statement is executedEwhen a TRUNCATE statement is executed after the pending transact ion
考题
单选题Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?（）A
Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.B
All DDL commands are logged in the alert log file.C
All DDL commands are logged in a different log file that contains DDL statements and their execution dates.D
Only DDL commands that resulted in the creation of new segments are logged.E
All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
考题
多选题Examine the commands executed to monitor database operations: $ conn sys oracle/oracle@prod as sysdba SQL VAR eid NUMBER SQL EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING = ‘Y’); Which two statements are true?（）ADatabase operations will be monitored only when they consume a significant amount of resource.BDatabase operations for all sessions will be monitored.CDatabase operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.DOnly DML and DDL statements will be monitored for the session.EAll subsequent statements in the session will be treated as one database operation and will be monitored.
考题
单选题Which of the following commands will show the users that are logged on a system ?（）A
idB
whoC
whoisD
lsuser
考题
单选题Examine the following query output: You issue the following command to import tables into the hr schema: $ impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）A
All database operations performed by the impdp command are logged.B
Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.C
Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.D
None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.
考题
多选题Examine the following statement that is used to modify the constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）AThe constraint remains valid.BThe index on the constraint is dropped.CIt allows the loading of data into the table using SQL*Loader.DNew data conforms to the constraint， but existing data is not checkedEIt allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
单选题Examine the following query output: You issue the following command to import tables into the hr schema: $ impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）A
All database operations performed by the impdp command are logged.B
Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.C
Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.D
None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.
考题
单选题Which of the following commands should be used to watch system errors as they are logged？（）A
errpt -cB
tail -f /var/adm/ras/errlogC
syslogd -dD
/usr/lib/errdemon -s 8192
热门标签
最新试卷
