What is the default storage engine in 5.6 ?
MyISAM
Innodb
Memory
Archive
What is the default storage engine before 5.5.5 ?
Myisam
What is the default storage engine from 5.5.5 ?
Blackhole
Which of the following is not applicable for MyISAM tables
lock waits
deadlocks
table level locking
indexes
Which of the following is not applicable for MyISAM
referential integrity
slow log
What is the purpose of innodb redo logs ?
crash recovery
identify bad queries
to recover database
point in time recovery
How many redo logs are created by default in Innodb ?
4
3
2
6
A user had issues LOCK TABLES on actor table. You can
delete table actor
select table actor
update table actor
insert table actor
What is the purpose of innodb_file_per_table ?
All the tables are saved in shared ibd file
Each table has separate tablespace file
Each table has separate redo log
Each table has sepearate files - one for index and one for table
When you create a new MyISAM table following files are created in data directory
.frm,.myi,.myd
.frm,.myi,.ibd
.frm,.ibd
.myi,.myd
