Storage engines

Question 1 of 10

1

What is the default storage engine in 5.6 ?

Select one of the following:

MyISAM
Innodb
Memory
Archive

Explanation

Question 2 of 10

1

What is the default storage engine before 5.5.5 ?

Select one of the following:

Innodb
Memory
Myisam
Archive

Explanation

Question 3 of 10

1

What is the default storage engine from 5.5.5 ?

Select one of the following:

Innodb
MyISAM
Memory
Blackhole

Explanation

Question 4 of 10

1

Which of the following is not applicable for MyISAM tables

Select one of the following:

lock waits
deadlocks
table level locking
indexes

Explanation

Question 5 of 10

1

Which of the following is not applicable for MyISAM

Select one of the following:

referential integrity
table level locking
indexes
slow log

Explanation

Question 6 of 10

1

What is the purpose of innodb redo logs ?

Select one of the following:

crash recovery
identify bad queries
to recover database
point in time recovery

Explanation

Question 7 of 10

1

How many redo logs are created by default in Innodb ?

Select one of the following:

4
3
2
6

Explanation

Question 8 of 10

1

A user had issues LOCK TABLES on actor table. You can

Select one of the following:

delete table actor
select table actor
update table actor
insert table actor

Explanation

Question 9 of 10

1

What is the purpose of innodb_file_per_table ?

Select one of the following:

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

Explanation

Question 10 of 10

1

When you create a new MyISAM table following files are created in data directory

Select one of the following:

.frm,.myi,.myd
.frm,.myi,.ibd
.frm,.ibd
.myi,.myd

	Created by nivasreddy.is almost 10 years ago

Quiz on Storage engines, created by nivasreddy.is on 22/08/2014.

Storage engines

Question 1 of 10

What is the default storage engine in 5.6 ?

Select one of the following:

Explanation

Question 2 of 10

What is the default storage engine before 5.5.5 ?

Select one of the following:

Explanation

Question 3 of 10

What is the default storage engine from 5.5.5 ?

Select one of the following:

Explanation

Question 4 of 10

Which of the following is not applicable for MyISAM tables

Select one of the following:

Explanation

Question 5 of 10

Which of the following is not applicable for MyISAM

Select one of the following:

Explanation

Question 6 of 10

What is the purpose of innodb redo logs ?

Select one of the following:

Explanation

Question 7 of 10

How many redo logs are created by default in Innodb ?

Select one of the following:

Explanation

Question 8 of 10

A user had issues LOCK TABLES on actor table. You can

Select one of the following:

Explanation

Question 9 of 10

What is the purpose of innodb_file_per_table ?

Select one of the following:

Explanation

Question 10 of 10

When you create a new MyISAM table following files are created in data directory

Select one of the following:

Explanation