网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance？（）
- A、B-tree
- B、bitmap
- C、reverse key
- D、function based
参考答案
更多 “The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance？（）A、B-treeB、bitmapC、reverse keyD、function based” 相关考题
考题
在为student_db数据库的St_Info表录入数据时，常常需要一遍又一遍地输入“男”到学生“性别”列，以下（）方法可以解决这个问题。A、创建一个DEFAULT约束（或默认值）B、创建一个CHECK约束C、创建一个UNIQUE约束（或唯一值）D、创建一个PRIMARYKEY约束（或主键）
考题
单选题The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance？（）A
BtreeB
bitmapC
reverse keyD
function based
考题
单选题要查询st_info表中姓"王"且单名的学生情况，可用（）命令。A
SELECT * FROM st_info WHERE st_name LIKE ´王%´B
SELECT * FROM st_info WHERE st_name LIKE ´王_´C
SELECT * FROM st_info WHERE st_name=´王%´D
SELECT * FROM st_info WHERE st_name=´王__´
考题
单选题在为student_db数据库的St_Info表录入数据时，常常需要一遍又一遍地输入“男”到学生“性别”列，以下（）方法可以解决这个问题。A
创建一个DEFAULT约束（或默认值）B
创建一个CHECK约束C
创建一个UNIQUE约束（或唯一值）D
创建一个PRIMARYKEY约束（或主键）
热门标签
最新试卷