Vidyalelo
MySQL · Q216

MySQL

Programming · MySQL · question 216

Q216

How many of the following shared tablespaces is bound by the OS file size limit? MyISAM, InnoDB, TRANSACTION

A.
0
B.
1
Answer
C.
2
D.
3

Answer: Option B

Solution

Answer: Option B
Solution:
This question is about how MySQL handles storage for different table types.

Let's break down the options:

* MyISAM: MyISAM tables are stored in separate files. Each MyISAM table has its own set of files. So they are not bound by the operating system (OS) file size limit.
* InnoDB: InnoDB tables store data in a shared tablespace. This tablespace is essentially a single file that holds data for multiple InnoDB tables. So they are bound by the OS file size limit.
* TRANSACTION: The transaction log for InnoDB is also stored in a shared tablespace, which is also a single file. So they are bound by the OS file size limit.

Therefore, the answer is Option C: 2. Two tablespaces, InnoDB and TRANSACTION, are bound by the OS file size limit.