What are the different tables present in mysql, which type
of table is generated when we are creating a table in the
following syntax: create table employee(eno int(2),ename
varchar(10)) ?
Answer Posted / sailesh jaiswal (lamp institut
MySQL supports 2 types of tables.
1. Transaction Safe Table (TST)
2. Non-Transaction Safe Table (NTST)
1. Transaction Safe Table: This type is safer compared to
NTST. Here transactions are temporary. We have ROLLBACK &
COMMIT commands available. Supports Foreign Key, Locking.
Used for More WRITES & Less READS.
Storage engines INNODB, BDB creates TSTs
2. NTST: Here transactions are permanent. No COMMIT, No
ROLLBACK. Partial Support for Foreign Key, Locking. Used for
More READS & Less WRITE.
Storage engines MyISAM, HEAP creates NTSTs.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is php regular expression?
Explain what is the difference between session and cookie?
What is a class in php programing?
How can a cross-site scripting attack be prevented by php?
Why is php used for web development?
Why php is also called as scripting language?
How can we automatically escape incoming data?
What is faster in php?
Tell me what is mean by an associative array?
How does session work in php?
How many types of arrays are there in php?
Does php has a future?
What does the array operator '===' means?
Is c similar to php?
What is csrf token in php?