Which two are true regarding external tables? ()

题目
多选题
Which two are true regarding external tables? ()
A

External tables can be updated.

B

External tables are read-only tables.

C

Indexes can be created on external tables.

D

Indexes cannot be created on external tables.

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

第1题:

For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()(Choose two.)

A. views

B. fixed tables

C. heap tables

D. external tables

E. temporary tables

F. index-organized tables (IOT)


参考答案:C, F

第2题:

Which two statements are true regarding the USING clause in table joins?()

  • A、It can be used to join a maximum of three tables 
  • B、It can be used to restrict the number of columns used in a NATURAL join 
  • C、It can be used to access data from tables through equijoins as well as nonequijoins 
  • D、It can be used to join tables that have columns with the same name and compatible data types

正确答案:B,D

第3题:

On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()

A. fixed tables

B. heap tables

C. external tables

D. temporary tables

E. Index-Organized Tables (IOTs)


参考答案:B, E

第4题:

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

第5题:

Which statement is true regarding the INTERSECT operator?()

  • A、It ignores NULL values 
  • B、Reversing the order of the intersected tables alters the result 
  • C、The names of columns in all SELECT statements must be identical 
  • D、The number of columns and data types must be identical for all SELECT statements in the query 

正确答案:D

第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 of the following statements is true regarding the VERSIONS BETWEEN clause?()  

  • A、 The VERSIONS BETWEEN clause may be used in DML statements.
  • B、 The VERSIONS BETWEEN clause may be used in DDL statements.
  • C、 The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.
  • D、 The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.

正确答案:C

第8题:

What two statements are true regarding the recommendations received from the SQL Access Advisor?()(Choose two.)

A. It cannot generate recommendations that support multiple workload queries.

B. It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.

C. It can recommend partitioning only on tables that have at least 10,000 rows.

D. It can recommend only B-tree indexes and not bitmap or function-based indexes


参考答案:B, C

第9题:

Which two statements are true regarding routing tables?()

  • A、The routing table is populated by the forwarding table.
  • B、Devices running the Junos OS can accommodate multiple routing tables.
  • C、Information learned from routing protocols is stored in the routing table.
  • D、The primary routing table for IPv4 unicast routes is inet.4.

正确答案:B,C

第10题:

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

更多相关问题