数据库面试题实战解答

阅读量：237 次

发布时间：2019-03-01

本文共 2171 字，大约阅读时间需要 7 分钟。

??????SQL??????

1. ???????

??????????????????????????????????????????????????????????????????????????????????????

2. ??????????

?????????SQL?????????????????????????????????????????????????????????SQL?

3. ????????

???

????????????????????????

??????????????????

??????????????

???????????????

??????????????????????

???

?????????????????????

???????????????????

??????????????????

4. ????????

??????????????????????

??????????????

????????????????

?????????????????

??????????????????

5. ???????

??????????????????????new????????free?delete???????????????????

6. ?????????????

??????????????CHECK???????????????????????????????????????????????

7. ???????

???????SQL???????????????????????????????ACID???????????????????

???????????????????????

?????????????????

??????????????

????????????

?????????????????????

8. ??????????

??????????????????????????

??????????JOIN???

????????????

?????????????????????

9. where?having???

where?????????????????????????

having????????????????????????????

10. on?in???

on????????????????????????

in???????????????????????????

11. union?union all???

union?????????????????????????

union all?????????????????????????

12. ???????

?????????????

???????????????
- ?????????????????????
- ???????????????????????

13. ????????????????

???????????????????????????????????????????????

14. SQL????

NOT NULL????????

UNIQUE???????

PRIMARY KEY?????????????

FOREIGN KEY???????????????

CHECK??????????

15. ???????

????????????????????????????????????????????

???????????????????????????????????????

16. ??????

Read Uncommitted??????????????????

Read Committed???????????????????

Repeatable Read?????????????????????????

Serializable?????????????????????

17. Truncate vs Delete

Truncate??????????????ROLLBACK??????????

Delete???????????ROLLBACK???????????

18. ????????

???????????????????

?????

???cursor c [????] is SELECT???

???open c?

???fetch c into???

???close c?

19. ??????????

????????????????

??????????????????????????

20. Oracle vs MySQL??

?????MySQL???????????????Oracle??????????

?????MySQL???????????Oracle??????????????

?????MySQL?InnoDB?????Oracle??????????????????

??

????????????????????????????????????????????????????????????????????????

转载地址：http://yxnv.baihongyu.com/

你可能感兴趣的文章

Quartz2.2.1简单使用

查看>>

POJ 1080 Human Gene Functions(DP:LCS)

POJ 1095 Trees Made to Order

查看>>

POJ 1113 Wall(计算几何--凸包的周长)

查看>>

poj 1125Stockbroker Grapevine（最短路）

查看>>

poj 1151 (未完成) 扫描线线段树离散化

查看>>

POJ 1151 / HDU 1542 Atlantis 线段树求矩形面积并

查看>>

poj 1163 数塔

查看>>

POJ 1177 Picture（线段树：扫描线求轮廓周长）

查看>>

POJ 1182 食物链（并查集拆点）

查看>>

POJ 1185 炮兵阵地（状态压缩DP）

查看>>

POJ 1195 Mobile phones

查看>>

POJ 1228 Grandpa's Estate （稳定凸包）

poj 1286 Necklace of Beads