計(jì)算機(jī)二級(jí)MySQL考試中的思維導(dǎo)圖應(yīng)用試題及答案

計(jì)算機(jī)二級(jí)MySQL考試中的思維導(dǎo)圖應(yīng)用試題及答案姓名：____________________

一、單項(xiàng)選擇題（每題2分，共10題）

1.在MySQL中，用于創(chuàng)建數(shù)據(jù)庫(kù)的語(yǔ)句是：

A.CREATETABLE

B.CREATEDATABASE

C.INSERTINTO

D.UPDATE

2.以下哪個(gè)是MySQL中用于選擇所有記錄的SQL語(yǔ)句？

A.SELECT*

B.SELECTALL

C.FETCHALL

D.SELECTWHERE

3.在MySQL中，用于刪除數(shù)據(jù)庫(kù)的語(yǔ)句是：

A.DROPDATABASE

B.DELETEDATABASE

C.DROPTABLE

D.DELETETABLE

4.以下哪個(gè)是MySQL中用于插入記錄的SQL語(yǔ)句？

A.INSERTINTO

B.INSERTINTOTABLE

C.INSERTFROM

D.INSERTINTOCOLUMN

5.在MySQL中，用于修改記錄的SQL語(yǔ)句是：

A.UPDATE

B.MODIFY

C.CHANGE

D.ALTER

6.以下哪個(gè)是MySQL中用于刪除記錄的SQL語(yǔ)句？

A.DELETEFROM

B.DELETERECORD

C.DROPRECORD

D.ERASE

7.在MySQL中，用于創(chuàng)建表的SQL語(yǔ)句是：

A.CREATETABLE

B.CREATEDATABASETABLE

C.TABLECREATE

D.MAKETABLE

8.以下哪個(gè)是MySQL中用于創(chuàng)建視圖的SQL語(yǔ)句？

A.CREATEVIEW

B.VIEWCREATE

C.MAKEVIEW

D.VIEWMAKE

9.在MySQL中，用于選擇記錄的SQL語(yǔ)句是：

A.SELECT

B.FETCH

C.LIST

D.QUERY

10.以下哪個(gè)是MySQL中用于排序記錄的SQL語(yǔ)句？

A.ORDERBY

B.SORT

C.ASC

D.DESC

二、填空題（每空2分，共10空）

1.在MySQL中，創(chuàng)建數(shù)據(jù)庫(kù)的SQL語(yǔ)句格式為：______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

二、多項(xiàng)選擇題（每題3分，共10題）

1.以下哪些是MySQL中的數(shù)據(jù)類(lèi)型？

A.INT

B.VARCHAR

C.DATE

D.TEXT

E.FLOAT

2.在MySQL中，以下哪些是用于數(shù)據(jù)完整性約束的鍵？

A.PRIMARYKEY

B.FOREIGNKEY

C.UNIQUE

D.INDEX

E.NOTNULL

3.以下哪些是MySQL中的SQL語(yǔ)句？

A.SELECT

B.INSERT

C.UPDATE

D.DELETE

E.COMMIT

4.在MySQL中，以下哪些是用于管理數(shù)據(jù)庫(kù)的語(yǔ)句？

A.CREATEDATABASE

B.DROPDATABASE

C.ALTERTABLE

D.CREATEINDEX

E.GRANT

5.以下哪些是MySQL中的數(shù)據(jù)操作語(yǔ)言（DML）？

A.SELECT

B.INSERT

C.UPDATE

D.DELETE

E.COMMIT

6.在MySQL中，以下哪些是用于數(shù)據(jù)定義語(yǔ)言（DDL）的語(yǔ)句？

A.CREATETABLE

B.DROPTABLE

C.ALTERTABLE

D.CREATEINDEX

E.COMMIT

7.以下哪些是MySQL中的數(shù)據(jù)控制語(yǔ)言（DCL）？

A.GRANT

B.REVOKE

C.COMMIT

D.ROLLBACK

E.SELECT

8.在MySQL中，以下哪些是用于數(shù)據(jù)查詢(xún)的函數(shù)？

A.COUNT()

B.SUM()

C.AVG()

D.MAX()

E.MIN()

9.以下哪些是MySQL中的日期和時(shí)間函數(shù)？

A.NOW()

B.CURDATE()

C.CURTIME()

D.TIMESTAMP()

E.STR_TO_DATE()

10.在MySQ