Vidyalelo
MySQL · Q1078

MySQL

Programming · MySQL · question 1078

Q1078

The data rows of a MyISAM table are stored in . . . . . . . .

A.
data file
Answer
B.
index file
C.
log file
D.
error file

Answer: Option A

Solution

Answer: Option A
Solution:
This question is about where MySQL stores the actual information you put into a table. Imagine a table like a spreadsheet, with rows and columns.

Think of data rows as the individual entries in your spreadsheet, each containing information about a single item.

Now, let's look at the options:

Option A: data file - This is the right answer! The data file is like the main spreadsheet itself where all the information is kept.

Option B: index file - This file helps MySQL quickly find specific data rows within the data file. It's like a table of contents for your spreadsheet.

Option C: log file - This file keeps track of changes made to the database. It's like a history log for your spreadsheet.

Option D: error file - This file stores any errors that occur during database operations. It's like a troubleshooting log for your spreadsheet.

So, the answer is Option A: data file. It's where MySQL keeps all the actual information you put into your database tables.