首页 071 正文

Which three statements are true about indexes and their administration in an oracle database?

2020.2.1 071 34

(关于索引及其在oracle数据库中的管理,哪三个陈述是正确的?)

A An INVISIBLE index is not maintained when Data Manipulation Language (DML) is performed on its underlying table.(在其基础表上执行数据操作语言(DML)时,不会维护不可见索引)

B An index can be created as part of a CREATE TABLE statement (可以将索引创建为CREATE TABLE语句的一部分)

C A DROP INDEX statement always prevents updates to the table during the drop operation. (DROP INDEX语句始终禁止在放置操作期间更新表。)

D A UNIOUE and non-unique index can be created on the same table column. (可以在同一表列上创建UNIOUE和非唯一索引。)

E A descending index is a type of function-based index (降序索引是一种基于函数的索引)

F It a query filters on an indexed column then it will always be used during execution of the query its underlying table.(它是对索引列进行查询过滤的查询,然后将在执行查询的基础表时始终使用它。)

答案:BEF

相关推荐:

评论

昵称*

邮箱*

网址