Explain the difference between MyISAM Static and MyISAM
Dynamic?
Answer / amith
In 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.
| Is This Answer Correct ? | 9 Yes | 1 No |
Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command
Explain GRANT command in MySQL.
What are the disadvantages of stored procedures?
What are procedures in mysql? Explain
What is memory table?
How do I view tables in mysql workbench?
what is cte? : Mysql dba
What is procedures in mysql?
What are the technical specifications of mysql?
Describe mysql transaction properties.
What is the function of myisamchk?
How do you use auto increment?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)