MySQL Interview Questions and Answers
Ques 21. What Is Join?
Join is data retrieval operation that combines rows from multiple tables under certain matching conditions to form a single row.
Ques 22. What Is Union?
Join is data retrieval operation that combines multiple query outputs of the same structure into a single output.
Ques 23. What Is ISAM?
ISAM (Indexed Sequential Access Method) was developed by IBM to store and retrieve data on secondary storage systems like tapes.
Ques 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.
Ques 25. What Is InnoDB?
InnoDB is a transaction safe storage engine developed by Innobase Oy (an Oracle company now).
Most helpful rated by users: