Interested to Buy Any Domain ? << Click Here >> for more details...
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)) ?
- 7 Answers
- 19520 Views
- HCL, I also Faced
- E-Mail Answers
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 a session in php?
What is meant by ‘passing the variable by value and reference' in php?
Explain the ternary conditional operator in php?
What is member variable?
How does api connect to database?
What is in php 7?
Where php language is used?
Why should I learn php?
How can you encrypt password using php?
What is sql injection in php?
Tell me what types of loops exist in php?
What are the encryption functions in php?
What is the main difference between php 4 and php 5?
Tell me what is htaccess?
How can you make a connection with mysql server using php?
