¡GoConqr estrena diseño! Cuéntanos qué te parece.

Regístrate gratis

Test

Storage engines

nivasreddy.is 10 preguntas 4,0 (1 valoración)

Hacer el test

Preguntas del test (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

Información

Descripción
Test sobre Storage engines, creado por nivasreddy.is el 22/08/2014.
Idioma
English
Visitas
77
Valoración
4,0 de 5 · 1 valoración
Valora este test
Valora este test

Escríbenos

¿Sobre qué es tu mensaje?

¿Qué te parece el nuevo diseño?

¿Te gusta?