O GoConqr está de visual novo! Conte para nós o que você achou.

Registre-se grátis

Quiz

Storage engines

nivasreddy.is 10 perguntas 4,0 (1 avaliação)

Fazer o quiz

Perguntas do 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

Informações

Descrição
Quiz sobre Storage engines, criado por nivasreddy.is em 22-08-2014.
Idioma
English
Visualizações
77
Avaliação
4,0 de 5 · 1 avaliação
Avalie este quiz
Avalie este quiz

Fale Conosco

Sobre o que é sua mensagem?

O que você acha do novo visual?

Você gostou?