|
INTERVIEW QUESTIONS
DATABASE
MYSQL
DETAILS
Question: Explain the difference between MyISAM Static and MyISAM Dynamic
Answer: MyISAM static all the fields have fixed width. The Dynamic MyISAM table would include fields such as TEXT, BLOB, etc. to accommodate the data types with various lengths. MyISAM Static would be easier to restore in case of corruption, since even though you might lose some data, you know exactly where to look for the beginning of the next record.
|
|
|
Category |
MYSQL Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 9393 users |
Added on |
8/24/2014 |
Views |
71827 |
Rate it! |
|
|
Question:
Explain the difference between MyISAM Static and MyISAM Dynamic
Answer:
MyISAM static all the fields have fixed width. The Dynamic MyISAM table would include fields such as TEXT, BLOB, etc. to accommodate the data types with various lengths. MyISAM Static would be easier to restore in case of corruption, since even though you might lose some data, you know exactly where to look for the beginning of the next record. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
What are some good ideas regarding user security in MySQL?
|
View Answer
|
|
Use mysqldump to create a copy of the database?
|
View Answer
|
|
How do you change a password for an existing user via mysqladmin?
|
View Answer
|
|
Can you save your connection settings to a conf file?
|
View Answer
|
|
What does "tee" command do in MySQL?
|
View Answer
|
|
What’s the default port for MySQL Server?
|
View Answer
|
|
Explain the difference between mysql and mysqli interfaces in PHP?
|
View Answer
|
|
How do you start MySQL on Linux?
|
View Answer
|
|
How do you start and stop MySQL on Windows?
|
View Answer
|
|
How to connect mysql from jsp(Java Server Page)?
|
View Answer
|
|
How we can count duplicate entery in particular table against Primary Key ? What are constraints?
|
View Answer
|
|
What are the advantages of Mysql comparing with oracle?
|
View Answer
|
|
How to display nth highest record in a table for example?How to display 4th highest (salary) record from customer table?
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All MYSQL Interview Questions & Answers - Exam Mode /
Learning Mode
|