Join is data retrieval operation that combines rows from multiple tables under certain matching conditions to form a single row.
Is it helpful?
Add CommentView Comments
Ques 22. What Is Union?
Join is data retrieval operation that combines multiple query outputs of the same structure into a single output.
Is it helpful?
Add CommentView Comments
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.
Is it helpful?
Add CommentView Comments
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.
Is it helpful?
Add CommentView Comments
Ques 25. What Is InnoDB?
InnoDB is a transaction safe storage engine developed by Innobase Oy (an Oracle company now).