48.Which two statements are true regarding indexes? (Choose two.)
来源:互联网 发布:快拍王软件下载 编辑:程序博客网 时间:2024/04/30 08:41
48.Which two statements are true regarding indexes? (Choose two.)
A.They can be created on tables and clusters.
B.They can be created on tables and simple views.
C.You can create only one index by using the same columns.
D.You can create more than one index by using the same columns if you specify distinctly different combinations of the columns.
答案:AD
A:正确
Introduction to Indexes
An index is an optional structure, associated with a table or table cluster, that can sometimes speed data access.
Indexes are schema objects that are logically and physically independent of the data in the objects with which they are associated.
Thus, you can drop or create an index without physically affecting the indexed table.
--这个是oracle的帮助文档中的描述
B:错误
C:错误,可以在一个列上创建多个索引,前提是需要和其他列进行组合
D:正确
A.They can be created on tables and clusters.
B.They can be created on tables and simple views.
C.You can create only one index by using the same columns.
D.You can create more than one index by using the same columns if you specify distinctly different combinations of the columns.
答案:AD
A:正确
Introduction to Indexes
An index is an optional structure, associated with a table or table cluster, that can sometimes speed data access.
Indexes are schema objects that are logically and physically independent of the data in the objects with which they are associated.
Thus, you can drop or create an index without physically affecting the indexed table.
--这个是oracle的帮助文档中的描述
B:错误
C:错误,可以在一个列上创建多个索引,前提是需要和其他列进行组合
D:正确
0 0
- 48.Which two statements are true regarding indexes? (Choose two.)
- 35.Which two statements are true regarding constraints? (Choose two.)
- 38.Which two statements are true regarding views? (Choose two.)
- 41.Which two statements are true regarding views? (Choose two.)
- 133.Which two statements are true regarding subqueries? (Choose two.)
- 175.Which two statements are true regarding savepoints? (Choose two.)
- 130.Which two statements are true regarding listeners? (Choose two.)
- 4.Which two statements are true regarding single row functions? (Choose two.)
- 67.Which two statements are true regarding the ORDER BY clause? (Choose two.)
- 80.Which two statements are true regarding working with dates? (Choose two.)
- 108.Which two statements are true regarding the COUNT function? (Choose two.)
- 121.Which two statements are true regarding the USING clause in table joins? (Choose two .)
- 170.Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.)
- 26.Which two statements are true regarding undo tablespaces? (Choose two.)
- 27.Which two statements are true regarding transactions in an Oracle database? (Choose two.)
- 98.Which two statements are true regarding the usage of the SQL*Loader utility? (Choose two.)
- 99.Which two statements are true regarding Oracle Data Pump? (Choose two.)
- 139.Which two statements are true regarding a tablespace? (Choose two.)
- java list add 方法理解
- muduo库的学习7---TcpServer与TcpClient的基本设计---总论
- 初窥Linux 之 我最常用的20条命令
- redis3.x cluster设计
- 架构师系列(一)--IT行业架构师之我初见
- 48.Which two statements are true regarding indexes? (Choose two.)
- Android控件GridView之仿支付宝钱包首页带有分割线的GridView九宫格的完美实现
- 2、发现群组 Python代码
- 英语总结
- 如何设置UILabel的内边距?
- Java中的DatagramPacket与DatagramSocket的初步
- c++ const类成员函数
- TextView 文字加上闪光与外层圆跟内层圆显示文字
- 用systemd命令来管理linux系统