1178327
Description
Quiz by nivasreddy.is, updated more than 1 year ago
|
Created by nivasreddy.is
almost 10 years ago
|
|
Question 1
Question
What is the default storage engine in 5.6 ?
Answer
-
MyISAM
-
Innodb
-
Memory
-
Archive
Question 2
Question
What is the default storage engine before 5.5.5 ?
Answer
-
Innodb
-
Memory
-
Myisam
-
Archive
Question 3
Question
What is the default storage engine from 5.5.5 ?
Answer
-
Innodb
-
MyISAM
-
Memory
-
Blackhole
Question 4
Question
Which of the following is not applicable for MyISAM tables
Answer
-
lock waits
-
deadlocks
-
table level locking
-
indexes
Question 5
Question
Which of the following is not applicable for MyISAM
Answer
-
referential integrity
-
table level locking
-
indexes
-
slow log
Question 6
Question
What is the purpose of innodb redo logs ?
Answer
-
crash recovery
-
identify bad queries
-
to recover database
-
point in time recovery
Question 7
Question
How many redo logs are created by default in Innodb ?
Answer
-
4
-
3
-
2
-
6
Question 8
Question
A user had issues LOCK TABLES on actor table. You can
Answer
-
delete table actor
-
select table actor
-
update table actor
-
insert table actor
Question 9
Question
What is the purpose of innodb_file_per_table ?
Answer
-
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
Question 10
Question
When you create a new MyISAM table following files are created in data directory
Answer
-
.frm,.myi,.myd
-
.frm,.myi,.ibd
-
.frm,.ibd
-
.myi,.myd
Want to create your own Quizzes for free with GoConqr? Learn more.