Which three statements are characteristic of the MEMORY stor

题目
多选题
Which three statements are characteristic of the MEMORY storage engine?()
A

It can support transactions

B

Table contents are not saved if the server is restarted

C

It cannot contain text or BLOB columns

D

It can support foreign keys

E

Each table is represented on disk as an.frm file

F

Each table has a corresponding.MYI and .MYD file

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

第1题:

Which is not the characteristic of operating system?

A.resource management

B.transaction management

C.memory management

D.disk management


正确答案:B

第2题:

Which three statements are characteristic of the MEMORY storage engine?()

A.It can support transactions

B.Table contents are not saved if the server is restarted

C.It cannot contain text or BLOB columns

D.It can support foreign keys

E.Each table is represented on disk as an.frm file

F.Each table has a corresponding.MYI and .MYD file


参考答案:B, C, E

第3题:

●Which of the following statements describe(s)the properties of a purely segmented memory system? (73) .

Ⅰ.It suffers from internal fragmentation

Ⅱ.It permits implementation of virtual memory

Ⅲ.It divides memory into units of equal size

(73) A.Ⅰ only

B.Ⅲ only

C.Ⅱ only

D.Ⅰ andⅢ


正确答案:C
【解析】略。

第4题:

Which of the following statements is NOT considered a characteristic of farming in the late 18th and early 19th centuries?()

  • A、Use of artificial fertilizer.
  • B、Introduction of new agricultural machinery.
  • C、The'Open-field'system.
  • D、A system of crop rotation.

正确答案:C

第5题:

Which of the following statements describe(s)the properties of a purely segmented memory system?(73).

Ⅰ. It suffers from internal fragmentation

Ⅱ. It permits implementation of virtual memory

Ⅲ. It divides memory into units of equal size

A.Ⅰ only

B.Ⅲ only

C.Ⅱ only

D.Ⅰand Ⅲ


正确答案:C

第6题:

Which statements about the MEMORY_TARGET initialization parameter are true?() (Choose all that apply.)

A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zero

B. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set

C. MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.

D. MEMORY_TARGET is static and cannot be modified without shutting down the instance


参考答案:A

第7题:

Which three statements are true about Automatic Workload Repository (AWR)?()

A. All AWR tables belong to the SYSTEM schema.

B. The AWR data is stored in memory and in the database.

C. The snapshots collected by AWR are used by the self-tuning components in the database

D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.

E. AWR contains system wide tracing and logging information.


参考答案:B, C, E

第8题:

Which of the following statements describe(s) the properties of a purely segmented memory system?

Ⅰ.It divides memory into units of equal size

Ⅱ.It permits implementation of virtual memory

Ⅲ.It suffers from internal fragmentation

A.Ⅰ only

B.Ⅱ only

C.Ⅲ only

D.Ⅰand Ⅲ


正确答案:B

第9题:

Which of the following statements is NOT considered a characteristic of farming in the late 18th and early 19th centuries?()

AUse of artificial fertilizer.

BIntroduction of new agricultural machinery.

CThe'Open-field'system.

DA system of crop rotation.


C

第10题:

Which three statements about bidirectional PIM are true?()

  • A、Traffic for a bidirectional group flows along the one shared tree and simultaneously utilizes multiple paths in a redundant network topology
  • B、It does not require any traffic signaling in the protocol
  • C、Membership to a bidirectional group is signaled using explicit Join messages
  • D、It maintains source-specific forwarding state
  • E、It reduces memory, bandwidth, and CPU requirements

正确答案:B,C,E

更多相关问题