1178327
Descrição
Quiz por nivasreddy.is, atualizado more than 1 year ago
|
Criado por nivasreddy.is
quase 10 anos atrás
|
|
Questão 1
Questão
What is the default storage engine in 5.6 ?
Responda
-
MyISAM
-
Innodb
-
Memory
-
Archive
Questão 2
Questão
What is the default storage engine before 5.5.5 ?
Responda
-
Innodb
-
Memory
-
Myisam
-
Archive
Questão 3
Questão
What is the default storage engine from 5.5.5 ?
Responda
-
Innodb
-
MyISAM
-
Memory
-
Blackhole
Questão 4
Questão
Which of the following is not applicable for MyISAM tables
Responda
-
lock waits
-
deadlocks
-
table level locking
-
indexes
Questão 5
Questão
Which of the following is not applicable for MyISAM
Responda
-
referential integrity
-
table level locking
-
indexes
-
slow log
Questão 6
Questão
What is the purpose of innodb redo logs ?
Responda
-
crash recovery
-
identify bad queries
-
to recover database
-
point in time recovery
Questão 7
Questão
How many redo logs are created by default in Innodb ?
Responda
-
4
-
3
-
2
-
6
Questão 8
Questão
A user had issues LOCK TABLES on actor table. You can
Responda
-
delete table actor
-
select table actor
-
update table actor
-
insert table actor
Questão 9
Questão
What is the purpose of innodb_file_per_table ?
Responda
-
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
Questão 10
Questão
When you create a new MyISAM table following files are created in data directory
Responda
-
.frm,.myi,.myd
-
.frm,.myi,.ibd
-
.frm,.ibd
-
.myi,.myd
Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.