MySQL 面试题与答案
问题 21. What Is Join?
Join is data retrieval operation that combines rows from multiple tables under certain matching conditions to form a single row.
问题 22. What Is Union?
Join is data retrieval operation that combines multiple query outputs of the same structure into a single output.
问题 23. What Is ISAM?
ISAM (Indexed Sequential Access Method) was developed by IBM to store and retrieve data on secondary storage systems like tapes.
问题 24. What Is MyISAM?
MyISAM is a storage engine used as the default storage engine for MySQL database. MyISAM is based on the ISAM (Indexed Sequential Access Method) concept and offers fast data storage and retrieval. But it is not transaction safe.
问题 25. What Is InnoDB?
InnoDB is a transaction safe storage engine developed by Innobase Oy (an Oracle company now).
用户评价最有帮助的内容: