mysql系列问答题_mysql基础题目解答

1.当前的数据库包含一个名为City的数据表，下面的哪个语句执行后能获得一个新语句，用该新语句可以去重新创建City数据表？A.DESCRIBECityB.DESCRIBETABLECityC.SHOWTABLECityD.SHOWCR...

1.当前的数据库包含一个名为City的数据表，下面的哪个语句执行后能获得一个新语句，用该新语句可以去重新创建City数据表？

A. DESCRIBE City

B. DESCRIBE TABLE City

C. SHOW TABLE City

D. SHOW CREATE TABLE City

2.下面哪条语句可被用来列出City表中所有列。

A. DISPLAY COLUMNS FROM City

B. SHOW COLUMNS FROM City

C. SHOW COLUMNS LIKE 'City'

D. SHOW City COLUMNS

3.下面哪条语句能被用来列出当前用户可以访问的所有数据库

A. LIST DATABASES

B. SHOW DATABASES

C. DISPLAY DATABASES

D. VIEW DATABASES

4.下面的哪句话能够最好地描述SQL where子句的作用？ 在SQL语句中，where子句说明了……..

A. the tables from which data is to be retrieved

B. a condition to filter for only specific rows.

C. a condition to filter for only specific groups defined by a GROUP BY clause.

D. a number to limit the number of rows that is operated upon by the statement.

5. SELECT语句的下述哪个部分规定了从中选出数据的表？

A. The SELECT list.

B. The FROM clause.

C. The WHERE clause.

D. The LIMIT clause.

6.一个MySQL数据表有………..

A. zero or more columns, and zero or more rows.

B. zero or more columns, and one or more rows.

C. one or more columns, and zero or more rows.

D. one or more columns, and one or more rows.

7.执行下面的语句后创建出了一个数据表

CREATE TABLE numbers (

double_number double,

decimal_number decimal(2,1)

)

然后插入一行记录，这时候，数据表中包含下面的数据

One row is successfully inserted into the numbers table. At this point, the table contains the following data:

+---------------+----------------+

| double_number | decimal_number |

+---------------+----------------+

| 1.5 | 2.5 |

+---------------+----------------+

The row is updated by executing the following statement:

该行又通过执行下面的语句得到更新

UPDATE numbers

SET double_number = double_number + 0.25,

decimal_number = decimal_number + 0.01

Which values are now stored in the double_number and decimal_number columns of the updated row?

刚才更新的那条数据记录中，double_number 和decimal_number列分别存储有什么值？

A. 1.8 and 2.5

B. 1.75 and 2.5

C. 1.8 and 2.51

D. 1.75 and 2.51

8.下面哪条语句能删除名为world的数据表？

A. DELETE DATABASE world

B. DROP DATABASE world

C. REMOVE DATABASE world

D. TRUNCATE DATABASE world

第三部分

1：

(1)码是什么和超码又是什么？它们之间的有什么区别？(10)

(2)Unique与主键的区别是什么(5)

2：查询出authors表的authName, ts和titles表的title, authors的记录，以authName进行分组并大于2的authName (10分)

3：解释每个标签的含义(15)

第三部分 3小题

展开