Mysql OCP 44题

最新推荐文章于 2024-10-13 21:00:27 发布

hbhe0316

最新推荐文章于 2024-10-13 21:00:27 发布

阅读量199

点赞数

文章标签：索引 es sql java elasticsearch

本文链接：https://blog.csdn.net/hbhe0316/article/details/122701003

版权

Consider the index information for the dept_emp table in the employee’s schema:https://www.cndba.cn/hbhe0316/article/22783

https://www.cndba.cn/hbhe0316/article/22783

Which two conclusions can be made based on the output of the query?
A. There are three indexes on the table.
B. There is a redundant index on the dept_no column.
C. The secondary indexes are optimized for unique key look-ups.
D. The values on the emp_no column must be unique.
E. The selectivity of the dept_no column is the best of the indexed columns.
F. There is a redundant index on the emp_no column.
Answer: AFhttps://www.cndba.cn/hbhe0316/article/22783

https://www.cndba.cn/hbhe0316/article/22783

https://www.cndba.cn/hbhe0316/article/22783 https://www.cndba.cn/hbhe0316/article/22783

下面哪两个结论是正确的？
A．表上有3个索引
B． Dept_no字段上存在一个冗余索引
C．辅助索引针对唯一键查询存在优化
D． Emp_no字段必须是唯一的
E． Dept_no字段的选择性是最好的
F． Emp_no字段上存在一个冗余索引

https://www.cndba.cn/hbhe0316/article/22783

MYSQL