Which two statements about the SQL Management Base (SMB) are

题目
多选题
Which two statements about the SQL Management Base (SMB) are true?()
A

It contains only SQL profiles generated by SQL Tuning Advisor.

B

It stores plans generated by the optimizer using a stored outline.

C

It is part of the data dictionary and stored in the SYSAUX tablespace.

D

It is part of the data dictionary and stored in the SYSTEM tablespace.

E

It contains the statement log, the plan history, plan baselines, and SQL profiles.

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Which two statements about the SQL Management Base (SMB) are true?()

A. It contains only SQL profiles generated by SQL Tuning Advisor.

B. It stores plans generated by the optimizer using a stored outline.

C. It is part of the data dictionary and stored in the SYSAUX tablespace.

D. It is part of the data dictionary and stored in the SYSTEM tablespace.

E. It contains the statement log, the plan history, plan baselines, and SQL profiles.


参考答案:C, E

第2题:

Evaluate these two SQL statements:What is true about them?()

A. The two statements produce identical results.

B. The second statement returns a syntax error.

C. There is no need to specify DESC because the results are sorted in descending order by default.

D. The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.


参考答案:A

第3题:

Which of the following statements about ORACLE is (are) correct?

Ⅰ.ORACLE follows SQL standard

Ⅱ.ORACLE database defines two logical types: table and view

A.Ⅰonly

B.Ⅱ only

C.Ⅰ and Ⅱ

D.none of the above


正确答案:C

第4题:

Which two statements are true about the Automatic Diagnostic Repository (ADR)?() 

  • A、 The ADR base keeps all diagnostic information in binary format
  • B、 SQL*Plus provides the ADRI script, which can be used to work with ADR
  • C、 The ADR can be used for problem diagnosis only when the database is open
  • D、 The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
  • E、 The ADR can be used for problem diagnosis even when the database instance is down
  • F、 The ADR base is shared across multiple instances

正确答案:E,F

第5题:

Which two statements are true about L2TP tunnels?() (Choose two.)

  • A、Traffic is clear text
  • B、Traffic is encrypted 
  • C、They are initiated by the LNS
  • D、They are initiated by the LAC

正确答案:A,D

第6题:

Which two statements are true about the Automatic Diagnostic Repository (ADR)?() (Choose two.)

A. The ADR base keeps all diagnostic information in binary format

B. SQL*Plus provides the ADRI script, which can be used to work with ADR

C. The ADR can be used for problem diagnosis only when the database is open

D. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null

E. The ADR can be used for problem diagnosis even when the database instance is down

F. The ADR base is shared across multiple instances


参考答案:E, F

第7题:

According to findings of the bMightyResearch report, which two statements about UC Solutions accurately describe the attributes of SMB decision makers?()

  • A、Only 20% of decision makers understand UC solutions.
  • B、They are generally well-educated on what UC solutions offer.
  • C、Many are yet to be convinced of the need for UC.
  • D、They have a tendency to support current telephony vendors.

正确答案:B,D

第8题:

Which two statements are true about the Automatic Diagnostic Repository (ADR)?()

A. The ADR base keeps all diagnostic information in binary format

B. SQL*Plus provides the ADRI script, which can be used to work with ADR

C. The ADR can be used for problem diagnosis only when the database is open

D. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null

E. The ADR can be used for problem diagnosis even when the database instance is down

F. The ADR base is shared across multiple instances


参考答案:E, F

第9题:

Which two statements about Cisco Security Management Suite are correct?()

  • A、It should be implemented in a management VLAN.
  • B、Its connection to managed devices should be over a data VLAN.
  • C、It is made up of Cisco Security MARS and Clean Access software.
  • D、It should be deployed as close to the edge of the network as possible.
  • E、It delivers policy administration and enforcement for the Cisco Self-Defending Network.

正确答案:A,E

第10题:

Which two statements about the SQL Management Base (SMB) are true? ()(Choose two.)

  • A、It contains only SQL profiles generated by SQL Tuning Advisor.
  • B、It stores plans generated by the optimizer using a stored outline.
  • C、It is part of the data dictionary and stored in the SYSAUX tablespace.
  • D、It is part of the data dictionary and stored in the SYSTEM tablespace.
  • E、It contains the statement log, the plan history, plan baselines, and SQL profiles.

正确答案:C,E

更多相关问题