1178327
Beschreibung
Quiz von nivasreddy.is, aktualisiert more than 1 year ago
|
Erstellt von nivasreddy.is
vor mehr als 10 Jahre
|
|
Frage 1
Frage
What is the default storage engine in 5.6 ?
Antworten
-
MyISAM
-
Innodb
-
Memory
-
Archive
Frage 2
Frage
What is the default storage engine before 5.5.5 ?
Antworten
-
Innodb
-
Memory
-
Myisam
-
Archive
Frage 3
Frage
What is the default storage engine from 5.5.5 ?
Antworten
-
Innodb
-
MyISAM
-
Memory
-
Blackhole
Frage 4
Frage
Which of the following is not applicable for MyISAM tables
Antworten
-
lock waits
-
deadlocks
-
table level locking
-
indexes
Frage 5
Frage
Which of the following is not applicable for MyISAM
Antworten
-
referential integrity
-
table level locking
-
indexes
-
slow log
Frage 6
Frage
What is the purpose of innodb redo logs ?
Antworten
-
crash recovery
-
identify bad queries
-
to recover database
-
point in time recovery
Frage 7
Frage
How many redo logs are created by default in Innodb ?
Antworten
-
4
-
3
-
2
-
6
Frage 8
Frage
A user had issues LOCK TABLES on actor table. You can
Antworten
-
delete table actor
-
select table actor
-
update table actor
-
insert table actor
Frage 9
Frage
What is the purpose of innodb_file_per_table ?
Antworten
-
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
Frage 10
Frage
When you create a new MyISAM table following files are created in data directory
Antworten
-
.frm,.myi,.myd
-
.frm,.myi,.ibd
-
.frm,.ibd
-
.myi,.myd
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.