Which two statements are true regarding a tablespace()

题目
多选题
Which two statements are true regarding a tablespace()
A

It can span multiple databases.

B

It can consist of multiple data files.

C

It can contain blocks of different sizes.

D

It can contain segments of different sizes.

E

It can contain a part of a nonpartitioned segment.

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

第1题:

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

第2题:

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

第3题:

You issued the following command:An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command? ()

A. It stores only the temporary table but not its indexes.

B. It stores both the temporary table as well as its indexes.

C. It must be a nondefault temporary tablespace for the database.

D. It can be a default or nondefault temporary tablespace for the database.

E. It must be the default temporary tablespace of the user who issues the command.


参考答案:B, D

第4题:

Which two statements are TRUE regarding Coherence Indexes ? ()

  • A、 indexes are maintained by cache entry ownes
  • B、 an application should not suggest an index that another aplication had suggested
  • C、 indexes cannot be sorted
  • D、 each application using Coherence may suggest the same set of indexes when it starts

正确答案:A,D

第5题:

Which  statements are true regarding a tablespace()

  • A、It can span multiple databases.
  • B、It can consist of multiple data files.
  • C、It can contain blocks of different sizes.
  • D、It can contain segments of different sizes.
  • E、It can contain a part of a nonpartitioned segment

正确答案:B,D

第6题:

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

第7题:

Which two statements are true regarding undo tablespaces()

  • A、The database can have more than one undo tablespace.
  • B、The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.
  • C、Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions.
  • D、An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.

正确答案:A,C

第8题:

Which two statements are true about the use of the procedures listed in the vsysaux_occupants.move_procedure column?()

A. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.

B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.

C. All the components may be moved into SYSAUX tablespace.

D. All the components may be moved from the SYSAUX tablespace.


参考答案:A, B

第9题:

Which two statements about bigfile tablespaces are true? ()

  • A、The bigfile tablespace have only one data file.
  • B、The segment space management is automatic.
  • C、The extent management is dictionary managed.
  • D、The database can have only one bigfile tablespace.
  • E、The bigfile tablespace can be converted to a smallfile tablespace.

正确答案:A,B

第10题:

Which two statements are true regarding subqueries? ()

  • A、A subquery can retrieve zero or more rows 
  • B、Only two subqueries can be placed atone level 
  • C、A subquery can be used only in SQL query statements 
  • D、A subquery can appear on either side of a comparison operator 
  • E、There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement 

正确答案:A,D

更多相关问题