目录
第 1 章 数据库入门 ........................................................................................................................3
1、 练习题及答案...................................................................................................................3
2、 实验题及答案...................................................................................................................3
第 2 章 数据库 ................................................................................................................................4
1、练习题及答案 ....................................................................................................................4
2、实验题及答案 ....................................................................................................................4
第 3 章 表操作 ................................................................................................................................6
1、练习题及答案 ....................................................................................................................6
2、实验题及答案 ....................................................................................................................6
第 4 章 SQL 语句基础 .....................................................................................................................8
1、练习题及答案 ....................................................................................................................8
2、实验题及答案 ....................................................................................................................8
第 5 章 SQL 语句提高 ...................................................................................................................10
1、练习题及答案 ..................................................................................................................10
2、实验题及答案 ..................................................................................................................10
第 6 章 运算及逻辑语句...............................................................................................................12
1、练习题及答案 ..................................................................................................................12
2、实验题及答案 ..................................................................................................................12
第 7 章 函数 ..................................................................................................................................14
1、练习题及答案 ..................................................................................................................14
2、实验题及答案 ..................................................................................................................14
第 8 章 事务 ..................................................................................................................................16
1、练习题及答案 ..................................................................................................................16
2、实验题及答案 ..................................................................................................................16
第 9 章 索引 ..................................................................................................................................18
1、练习题及答案 ..................................................................................................................18
2、实验题及答案 ..................................................................................................................18
第 10 章 视图 ................................................................................................................................20
1、练习题及答案 ..................................................................................................................20
2、实验题及答案 ..................................................................................................................20
第 11 章 存储过程、游标.............................................................................................................22
1、练习题及答案 ..................................................................................................................22
2、实验题及答案 ..................................................................................................................22
第 12 章 触发器 ............................................................................................................................24
1、练习题及答案 ..................................................................................................................24
2、实验题及答案 ..................................................................................................................24
第 13 章 数据备份 ........................................................................................................................26
1、练习题及答案 ..................................................................................................................26
2、实验题及答案 ..................................................................................................................26
第 14 章 日志 ................................................................................................................................27
1、练习题及答案 ..................................................................................................................27
2、实验题及答案 ..................................................................................................................27
第 15 章 性能优化 ........................................................................................................................29