MySQL Database Multiple choice Questions and Answers-Database Maintenance and Backup

A directory of Objective Type Questions covering all the Computer Science subjects. Here you can access and discuss Multiple choice questions and answers for various competitive exams and interviews.

Online Test

Take a quick online test

UGC NET MCQs

Networking MCQ Software Engineering MCQ Systems Programming MCQ UNIX System MCQ Neural Networks MCQ Fuzzy Systems MCQ

GATE CSE MCQs

Computer Architecture MCQ DBMS MCQ Networking MCQ

C - Arrays and Pointers

C - Stacks and Queues

C - Linked Lists

1.	The recovery of data changes made since a given point in time is called _____________
a.	decremental
b.	incremental
c.	close
d.	clear

Answer: (b).incremental

2.	What performs a key distribution analysis and stores the distribution for the named table or tables?
a.	ANALYZE TABLE
b.	CHECK TABLE
c.	CHECKSUM TABLE
d.	OPTIMIZE TABLE

Answer: (a).ANALYZE TABLE

3.	Which of the following columns is not returned by ‘OPTIMIZE TABLE’?
a.	Table
b.	Op
c.	Msg_type
d.	Msg_txt

Answer: (d).Msg_txt

4.	REPAIR TABLE does not work for _____________
a.	MyISAM
b.	ARCHIVE
c.	InnoDB
d.	CSV

Answer: (c).InnoDB

5.	The binary protocol is easy to use.
a.	True
b.	False
c.	May be True or False
d.	Can't say

Answer: (b).False

6.	What is a synonym for CHARACTER SET?
a.	CSET
b.	CHSET
c.	CHARSET
d.	CHCSET

Answer: (c).CHARSET

7.	The line which is written at the top of the script to write a Perl script using CGI.pm is ______________
a.	use this CGI
b.	put CGI
c.	use CGI
d.	include CGI

Answer: (c).use CGI

8.	To perform consistency checks on a MyISAM table the statement is _____________
a.	CHECK TABLE
b.	REPAIR TABLE
c.	ANALYZE TABLE
d.	OPTIMIZE TABLE

Answer: (a).CHECK TABLE

9.	The statement that performs key distribution analysis and stores the distribution for the named tables is _____________
a.	CHECK TABLE
b.	ANALYZE TABLE
c.	CHECKSUM TABLE
d.	OPTIMIZE TABLE

Answer: (b).ANALYZE TABLE

10.	The column not returned by ‘OPTIMIZE TABLE’ is _____________
a.	Table
b.	Msg_txt
c.	Op
d.	Msg_type

Answer: (b).Msg_txt

Page 1 of 7

1
2
3
4
5
6
7
»

GATE CSE Resources

Questions from Previous year GATE question papers

UGC NET Computer science Resources

UGC NET Previous year questions and practice sets

NET General Paper 1

UGC NET Previous year questions and practice sets

GATE CSE Online Test

Attempt a small test to analyze your preparation level. This GATE exam includes questions from previous year GATE papers.

UGC NET practice Test

Practice test for UGC NET Computer Science Paper. The questions asked in this NET practice paper are from various previous year papers.