GoConqr has a new look! Let us know what you think.

Sign up free

Quiz

Storage engines

nivasreddy.is 10 questions 4.0 (1 rating)

Take the quiz

Questions in this 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

Information

Description
Quiz on Storage engines, created by nivasreddy.is on 22/08/2014.
Language
English
Views
77
Rating
4.0 out of 5 · 1 rating
Rate this quiz
Rate this quiz

Feedback

What is it about?

What do you think of the new look?

How do you like it?