GoConqr hat ein neues Design! Sag uns, wie es dir gefällt.

Kostenlos registrieren

Quiz

Storage engines

nivasreddy.is 10 Fragen 4,0 (1 Bewertung)

Quiz starten

Fragen in diesem Quiz (10)

  1. 1What is the default storage engine in 5.6 ?
    1. AMyISAM
    2. BInnodb
    3. CMemory
    4. DArchive
  2. 2What is the default storage engine before 5.5.5 ?
    1. AInnodb
    2. BMemory
    3. CMyisam
    4. DArchive
  3. 3What is the default storage engine from 5.5.5 ?
    1. AInnodb
    2. BMyISAM
    3. CMemory
    4. DBlackhole
  4. 4Which of the following is not applicable for MyISAM tables
    1. Alock waits
    2. Bdeadlocks
    3. Ctable level locking
    4. Dindexes
  5. 5Which of the following is not applicable for MyISAM
    1. Areferential integrity
    2. Btable level locking
    3. Cindexes
    4. Dslow log
  6. 6What is the purpose of innodb redo logs ?
    1. Acrash recovery
    2. Bidentify bad queries
    3. Cto recover database
    4. Dpoint in time recovery
  7. 7How many redo logs are created by default in Innodb ?
    1. A4
    2. B3
    3. C2
    4. D6
  8. 8A user had issues LOCK TABLES on actor table. You can
    1. Adelete table actor
    2. Bselect table actor
    3. Cupdate table actor
    4. Dinsert table actor
  9. 9What is the purpose of innodb_file_per_table ?
    1. AAll the tables are saved in shared ibd file
    2. BEach table has separate tablespace file
    3. CEach table has separate redo log
    4. DEach table has sepearate files - one for index and one for table
  10. 10When you create a new MyISAM table following files are created in data directory
    1. A.frm,.myi,.myd
    2. B.frm,.myi,.ibd
    3. C.frm,.ibd
    4. D.myi,.myd

Informationen

Beschreibung
Quiz am Storage engines, erstellt von nivasreddy.is am 22/08/2014.
Sprache
English
Aufrufe
77
Bewertung
4,0 von 5 · 1 Bewertung
Bewerte dieses Quiz
Bewerte dieses Quiz

Feedback

Worum geht es?

Wie gefällt dir das neue Design?

Dein Eindruck