违法和不良信息举报 联系客服
免费注册 登录

Which two statements are true regarding the usage of the SQL

题目
多选题
Which two statements are true regarding the usage of the SQL*Loader utility（）
A

You can load data into multiple tables during the same load session.

B

You can load data from multiple files to a table during the same load session.

C

You cannot perform selective data loading based on the values available in the records.

D

You can use an export file generated by the EXPDP utility as an input data file to load the data.

E

You can load data only if the input file is available on the disk and tape but not in a named pipes.

参考答案和解析
正确答案： B,A
解析： 暂无解析
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Which two statements regarding symmetric key encryption are true?() (Choose two.)

A. The same key is used for encryption and decryption.

B. It is commonly used to create digital certificate signatures.

C. It uses two keys: one for encryption and a different key for decryption.

D. An attacker can decrypt data if the attacker captures the key used for encryption.


参考答案：A, D

第2题：

Which two statements are true regarding high-availability chassis clustering？（）

  • A、A chassis cluster consists of two devices.
  • B、A chassis cluster consists of two or more devices.
  • C、Devices participating in a chassis cluster can be different models.
  • D、Devices participating in a chassis cluster must be the same models

正确答案:A,D

第3题：

Which two statements regarding a SQL profile are true?()

A. It is built by Automatic Tuning Optimizer.

B. It cannot be stored persistently in the data dictionary.

C. It can be used by the query optimizer automatically.

D. It can be created manually by using the CREATE PROFILE command.


参考答案：A, C

第4题：

Which two statements are true regarding a PL/SQL package body？（）

  • A、It cannot be created without a package specification.
  • B、It cannot invoke subprograms defined in other packages.
  • C、It can contain only the subprograms defined in the package specification.
  • D、It can be changed and recompiled without making the package specification invalid.

正确答案:A,D

第5题：

Which two statements regarding asymmetric key encryption are true？（）

  • A、The same key is used for encryption and decryption.
  • B、It is commonly used to create digital certificate signatures.
  • C、It uses two keys： one for encryption and a different key for decryption.
  • D、An attacker can decrypt data if the attacker captures the key used for encryption

正确答案:A,B

第6题：

Which two statements are true regarding L2TP? ()(Choose two.)

A. Tunnels are initiated by the LAC

B. Tunnels are initiated by the LNS

C. By default, subscriber authentication occurs on the LNS

D. By default, subscriber authentication occurs on the LAC


参考答案：A, C

第7题：

Which two statements are true regarding L2TP? （）(Choose two.)

  • A、Tunnels are initiated by the LAC
  • B、Tunnels are initiated by the LNS
  • C、By default, subscriber authentication occurs on the LNS
  • D、By default, subscriber authentication occurs on the LAC

正确答案:A,C

第8题：

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 execution

B.The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics

C.The execution plan and execution statistics are computed for each SQL statement in the STS

D.The effects of DDL and DML are considered to produce the execution plan and execution statistics


参考答案：A, C

第9题：

Which two statements are true regarding the SQL Repair Advisor？（） 

  • A、 The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.
  • B、 The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.
  • C、 The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.
  • D、 The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.

正确答案:B,D

第10题：

Which two statements regarding a SQL profile are true？（）

  • A、 It is built by Automatic Tuning Optimizer.
  • B、 It cannot be stored persistently in the data dictionary.
  • C、 It can be used by the query optimizer automatically.
  • D、 It can be created manually by using the CREATE PROFILE command.

正确答案:A,C

更多相关问题
相关内容