65 + Mcqs in MySQL Database Operations in Mysql Page 1 McqOptions

1.	Which of these is not optional? SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns;
A.	table_list
B.	grouping_columns
C.	select_list
D.	row_constraint
E.	None of these
Answer» D. row_constraint

Discussion

2.	How many of these are for use with only MyISAM tables? mysql, mysqladmin, mysqldump, mysqlisamchk
A.	4
B.	3
C.	2
D.	1
E.	None of these
Answer» B. 3

Discussion

3.	How many of these can replace level in myisam-recover = level ? BACKUP, FORCE, QUICK
A.	3
B.	2
C.	1
D.	0
E.	None of these
Answer» B. 2

Discussion

4.	REPAIR TABLE works with how many of the following? MyISAM, ARCHIVE, CSV
A.	3
B.	2
C.	1
D.	0
E.	None of these
Answer» B. 2

Discussion

5.	The higher priority is ______________. writes, reads
A.	same priority
B.	machine dependent
C.	writes
D.	reads
E.	None of these
Answer» D. reads

Discussion

6.	With only MyISAM tables, how many of the following are for use? mysql, mysqladmin, mysqldump, mysqlisamchk
A.	4
B.	3
C.	2
D.	1
E.	None of these
Answer» B. 3

Discussion

7.	How many of the following languages can interface to bind to the C API of MySQL? Perl, PHP, Python
A.	3
B.	2
C.	1
D.	0
E.	None of these
Answer» B. 2

Discussion

8.	CHECK TABLE works with how many of the following? MyISAM, ARCHIVE, CSV
A.	3
B.	2
C.	1
D.	0
E.	None of these
Answer» B. 2

Discussion

9.	What is the table name in the following? INSERT INTO Employee VALUES('Rahul','M',NULL);
A.	M
B.	Rahul
C.	VALUES
D.	Employee
E.	None of these
Answer» E. None of these

Discussion

10.	What is InnoDB in the following code? CREATE TABLE Employee ( Emp_name CHAR(30), Emp_id INT, PRIMARY KEY (Emp_id) ) ENGINE = InnoDB;
A.	reference engine
B.	table name
C.	storage engine
D.	database name
E.	None of these
Answer» D. database name

Discussion

11.	The most restrictive among the following is ______________. mysql_query(), mysql_real_query()
A.	same
B.	machine dependent
C.	mysql_real_query()
D.	mysql_query()
E.	None of these
Answer» E. None of these

Discussion

12.	Which of these is preferred when stored procedures are not being used? CLIENT_MULTI_STATEMENTS, mysql_set_server_option()
A.	neither of the two
B.	mysql_set_server_option()
C.	CLIENT_MULTI_STATEMENTS
D.	any of the two
E.	None of these
Answer» E. None of these

Discussion

13.	Which of the following does not return a value? mysql_close(), mysql_init, mysql_real_connect
A.	3
B.	2
C.	1
D.	0
E.	None of these
Answer» D. 0

Discussion

14.	Which of the following use NULL to indicate failure? mysql_init(), mysql_real_connect()
A.	3
B.	2
C.	1
D.	0
E.	None of these
Answer» C. 1

Discussion

15.	The log that identifies statements that may be in need of being rewritten for better performance is ______________.
A.	binary log
B.	slow query log
C.	general query
D.	error log
E.	None of these
Answer» C. general query

Discussion

16.	The option that executes all SQL statements in a SQL script irrespective of the number of errors is ______________.
A.	violent
B.	run
C.	force
D.	ensure
E.	None of these
Answer» D. ensure

Discussion

17.	Symlink is an applicable relocation method for ______________.
A.	log files
B.	server PID file
C.	entire data directory
D.	individual database tables
E.	None of these
Answer» E. None of these

Discussion

18.	Which command is used to make a script file run_me.sh executable?
A.	chmod +y run_me.sh
B.	chmod +x run_me.sh
C.	chmod +a run_me.sh
D.	chmod +e run_me.sh
E.	None of these
Answer» C. chmod +a run_me.sh

Discussion

19.	In which file are the statements entered in mysql saved?
A.	.mysql_history
B.	.history
C.	.queries
D.	.mysql_queries
E.	None of these
Answer» B. .history

Discussion

20.	What is the table name in the following?
A.	M
B.	Rahul
C.	VALUES
D.	Employee
E.	None of these
Answer» E. None of these

Discussion

21.	What is InnoDB in the following code?
A.	reference engine
B.	table name
C.	storage engine
D.	database name
E.	None of these
Answer» D. database name

Discussion

22.	The place where the server stores its databases and status files is called the data directory.
A.	False
B.	True
C.	NA
D.	NA
E.	NA
Answer» C. NA

Discussion

23.	The default value in seconds in the system variable long_query_time is ______________.
A.	60
B.	5
C.	10
D.	20
E.	None of these
Answer» E. None of these

Discussion

24.	The log that contains a record of server startups and shutdowns and the messages about exceptional conditions is ______________.
A.	slow query log
B.	binary log
C.	error log
D.	general query
E.	None of these
Answer» D. general query

Discussion

25.	The storage engine in MySQL that provides foreign key support is ___________.
A.	InnoDB
B.	MyISAM
C.	MEMORY
D.	TRANSACTION
E.	None of these
Answer» B. MyISAM

Discussion

26.	How many of these can replace level in myisam-recover = level ?
A.	3
B.	2
C.	1
D.	0
E.	None of these
Answer» B. 2

Discussion

27.	The variable that returns code from operations that return true or false is _____________.
A.	$rows
B.	$ary
C.	$rc
D.	$rv
E.	None of these
Answer» D. $rv

Discussion

28.	The option that suppresses output unless there are errors in the table is _____________.
A.	noout
B.	suppress
C.	wild
D.	silent
E.	None of these
Answer» E. None of these

Discussion

29.	The mode of search in which the search string is parsed into words and the search looks for rows is ________________.
A.	Natural language
B.	Query expansion
C.	Cross mode
D.	Boolean mode
E.	None of these
Answer» B. Query expansion

Discussion

30.	The higher priority is ______________.
A.	same priority
B.	machine dependent
C.	writes
D.	reads
E.	None of these
Answer» D. reads

Discussion

31.	What is the default size of max_binlog_cache_size system variable?
A.	8 GB
B.	1 GB
C.	2 GB
D.	4 GB
E.	None of these
Answer» E. None of these

Discussion

32.	In which context is the privilege CREATE TABLESPACE applied?
A.	Stored routines
B.	Views
C.	Tables
D.	Server administration
E.	None of these
Answer» E. None of these

Discussion

33.	MySQL Enterprise Backup records details of each backup in _____________.
A.	history_backlog
B.	backlog_history
C.	history_backup
D.	backup_history
E.	None of these
Answer» E. None of these

Discussion

34.	In mysqldump which option is used to make all tables in the destination databases to use a different storage engine?
A.	new-storage-engine
B.	clear-storage-engine
C.	get-storage-engine
D.	next-storage-engine
E.	None of these
Answer» E. None of these

Discussion

35.	The program that performs logical backups is _____________.
A.	mysqllogic
B.	myslqpit
C.	mysqlimport
D.	mysqldump
E.	None of these
Answer» E. None of these

Discussion

36.	To use mysqldbcopy which privileges are required on the source server?
A.	SELECT
B.	UPDATE
C.	INSERT
D.	CREATE
E.	None of these
Answer» B. UPDATE

Discussion

37.	1. Which program copies the databases from one server to another?
A.	mysqlflushdb
B.	mysqldbflush
C.	mysqlcopydb
D.	mysqldbcopy
E.	None of these
Answer» E. None of these

Discussion

38.	The function fetchrow_hashref() returns reference to hash of row values keyed by ______________.
A.	column name
B.	table name
C.	database name
D.	row name
E.	None of these
Answer» B. table name

Discussion

39.	The function that returns reference to hash of row values is ____________.
A.	fetchrow_hashref()
B.	fetchrow_array()
C.	fetchrow_arrayref()
D.	fetch()
E.	None of these
Answer» B. fetchrow_array()

Discussion

40.	The myisamchk variable that represents the size of buffer used to hold index blocks is _____________.
A.	sort_buffer_size
B.	write_buffer_size
C.	key_buffer_size
D.	read_buffer_size
E.	None of these
Answer» D. read_buffer_size

Discussion

41.	The mysqlbackup command to perform a restore operation is _____________.
A.	apply-log-and-copy-back
B.	apply-back-and-copy-log
C.	copy-back-and-apply-log
D.	copy-log-and-apply-back
E.	None of these
Answer» D. copy-log-and-apply-back

Discussion

42.	The metadata log is _______________.
A.	ddl log
B.	relay log
C.	error log
D.	binary log
E.	None of these
Answer» B. relay log

Discussion

43.	The slave stores the CHANGE MASTER parameters in the file _____________.
A.	master.info
B.	master.inf
C.	slave.inf
D.	slave.info
E.	None of these
Answer» B. master.inf

Discussion

44.	The program that copies the databases from one server to another is ____________.
A.	mysqlcopydb
B.	mysqldbcopy
C.	mysqldbflush
D.	mysqlflushdb
E.	None of these
Answer» C. mysqldbflush

Discussion

45.	Which option is used in mysqldump to make all tables in the destination databases to use a different storage engine?
A.	new-storage-engine
B.	clear-storage-engine
C.	get-storage-engine
D.	next-storage-engine
E.	None of these
Answer» B. clear-storage-engine

Discussion

46.	The ALL subquery performs operations on _____________.
A.	table
B.	database
C.	column
D.	row
E.	None of these
Answer» D. row

Discussion

47.	The column not returned by OPTIMIZE TABLE is _____________.
A.	Msg_type
B.	Op
C.	Table
D.	Msg_txt
E.	None of these
Answer» E. None of these

Discussion

48.	The statement that performs key distribution analysis and stores the distribution for the named tables is _____________.
A.	ANALYZE TABLE
B.	CHECKSUM TABLE
C.	OPTIMIZE TABLE
D.	CHECK TABLE
E.	None of these
Answer» B. CHECKSUM TABLE

Discussion

49.	To perform consistency checks on a MyISAM table the statement is _____________.
A.	ANALYZE TABLE
B.	OPTIMIZE TABLE
C.	CHECK TABLE
D.	REPAIR TABLE
E.	None of these
Answer» D. REPAIR TABLE

Discussion

50.	The logging option to enable binary log index file is ______________.
A.	index-bin-log
B.	index-log-bin
C.	bin-log-index
D.	log-bin-index
E.	None of these
Answer» E. None of these

Discussion

Explore topic-wise MCQs in Mysql.

Which of these is not optional?SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns;

How many of these are for use with only MyISAM tables?mysql, mysqladmin, mysqldump, mysqlisamchk

How many of these can replace level in myisam-recover = level ?BACKUP, FORCE, QUICK

REPAIR TABLE works with how many of the following?MyISAM, ARCHIVE, CSV

The higher priority is ______________.writes, reads

With only MyISAM tables, how many of the following are for use?mysql, mysqladmin, mysqldump, mysqlisamchk

How many of the following languages can interface to bind to the C API of MySQL?Perl, PHP, Python

CHECK TABLE works with how many of the following?MyISAM, ARCHIVE, CSV

What is the table name in the following?INSERT INTO Employee VALUES('Rahul','M',NULL);

What is InnoDB in the following code?CREATE TABLE Employee ( Emp_name CHAR(30), Emp_id INT, PRIMARY KEY (Emp_id) ) ENGINE = InnoDB;

The most restrictive among the following is ______________.mysql_query(), mysql_real_query()

Which of these is preferred when stored procedures are not being used?CLIENT_MULTI_STATEMENTS, mysql_set_server_option()

Which of the following does not return a value?mysql_close(), mysql_init, mysql_real_connect

Which of the following use NULL to indicate failure?mysql_init(), mysql_real_connect()

The log that identifies statements that may be in need of being rewritten for better performance is ______________.

The option that executes all SQL statements in a SQL script irrespective of the number of errors is ______________.

Symlink is an applicable relocation method for ______________.

Which command is used to make a script file run_me.sh executable?

In which file are the statements entered in mysql saved?

What is the table name in the following?

What is InnoDB in the following code?

The place where the server stores its databases and status files is called the data directory.

The default value in seconds in the system variable long_query_time is ______________.

The log that contains a record of server startups and shutdowns and the messages about exceptional conditions is ______________.

The storage engine in MySQL that provides foreign key support is ___________.

How many of these can replace level in myisam-recover = level ?

The variable that returns code from operations that return true or false is _____________.

The option that suppresses output unless there are errors in the table is _____________.

The mode of search in which the search string is parsed into words and the search looks for rows is ________________.

The higher priority is ______________.

What is the default size of max_binlog_cache_size system variable?

In which context is the privilege CREATE TABLESPACE applied?

MySQL Enterprise Backup records details of each backup in _____________.

In mysqldump which option is used to make all tables in the destination databases to use a different storage engine?

The program that performs logical backups is _____________.

To use mysqldbcopy which privileges are required on the source server?

1. Which program copies the databases from one server to another?

The function fetchrow_hashref() returns reference to hash of row values keyed by ______________.

The function that returns reference to hash of row values is ____________.

The myisamchk variable that represents the size of buffer used to hold index blocks is _____________.

The mysqlbackup command to perform a restore operation is _____________.

The metadata log is _______________.

The slave stores the CHANGE MASTER parameters in the file _____________.

The program that copies the databases from one server to another is ____________.

Which option is used in mysqldump to make all tables in the destination databases to use a different storage engine?

The ALL subquery performs operations on _____________.

The column not returned by OPTIMIZE TABLE is _____________.

The statement that performs key distribution analysis and stores the distribution for the named tables is _____________.

To perform consistency checks on a MyISAM table the statement is _____________.

The logging option to enable binary log index file is ______________.

Which of these is not optional?
SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns;

How many of these are for use with only MyISAM tables?
mysql, mysqladmin, mysqldump, mysqlisamchk

How many of these can replace level in myisam-recover = level ?
BACKUP, FORCE, QUICK

REPAIR TABLE works with how many of the following?
MyISAM, ARCHIVE, CSV

The higher priority is ______________.
writes, reads

With only MyISAM tables, how many of the following are for use?
mysql, mysqladmin, mysqldump, mysqlisamchk

How many of the following languages can interface to bind to the C API of MySQL?
Perl, PHP, Python

CHECK TABLE works with how many of the following?
MyISAM, ARCHIVE, CSV

What is the table name in the following?
INSERT INTO Employee VALUES('Rahul','M',NULL);

What is InnoDB in the following code?
CREATE TABLE Employee (
Emp_name CHAR(30),
Emp_id INT,
PRIMARY KEY (Emp_id)
) ENGINE = InnoDB;

The most restrictive among the following is ______________.
mysql_query(), mysql_real_query()

Which of these is preferred when stored procedures are not being used?
CLIENT_MULTI_STATEMENTS, mysql_set_server_option()

Which of the following does not return a value?
mysql_close(), mysql_init, mysql_real_connect

Which of the following use NULL to indicate failure?
mysql_init(), mysql_real_connect()