The collations this statement lists are ______________.SHOW COLLATION LIKE 'utf8%'

names containing utf8% anywhere

What does Student & name specify?CREATE TABLE Student (name);

table name and number of columns

70 + Mcqs in Mysql Setup in Mysql Page 1 McqOptions

1.	Identify the table name in the following statement. INSERT INTO Employee VALUES('Ajit','M',NULL);
A.	Ajit
B.	M
C.	Employee
D.	Values
E.	None of these
Answer» D. Values

Discussion

2.	x in the following statement is ____________. DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;
A.	database name
B.	column name
C.	server name
D.	table name
E.	None of these
Answer» E. None of these

Discussion

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

Discussion

4.	What column names are displayed when this command is executed? SHOW COLUMNS FROM Table_Name LIKE '%name';
A.	prefixed with name
B.	prefixed with %name
C.	suffixed with name
D.	suffixed with %name
E.	None of these
Answer» D. suffixed with %name

Discussion

5.	abc in the following statement is ___________. DELETE FROM xyz WHERE abc = 5;
A.	table name
B.	database name
C.	column name
D.	row name
E.	None of these
Answer» D. row name

Discussion

6.	The collations this statement lists are ______________. SHOW COLLATION LIKE 'utf8%'
A.	names ending in utf8%
B.	names containing utf8% anywhere
C.	names ending with utf8
D.	names beginning with utf8
E.	None of these
Answer» E. None of these

Discussion

7.	What is tamp in the following command? mysql -h xyz.host.try.net -p -u tamp
A.	password
B.	table name
C.	user name
D.	host name
E.	None of these
Answer» D. host name

Discussion

8.	What is the host name in the following command? mysql -h interview.mania.com -p -u sampadam
A.	interview.mania.com
B.	mania
C.	interview
D.	interview.mania
E.	None of these
Answer» B. mania

Discussion

9.	The number of attributes in the following table is ______________. CREATE TABLE Student( name CHAR(30), id INT(11) );
A.	3
B.	2
C.	1
D.	0
E.	None of these
Answer» C. 1

Discussion

10.	What does Student & name specify? CREATE TABLE Student (name);
A.	column specs and table name
B.	table name and number of rows
C.	table name and column specs
D.	table name and number of columns
E.	None of these
Answer» D. table name and number of columns

Discussion

11.	xyz in the following statement is __________. CREATE VIEW xyz AS SELECT a, b FROM t;
A.	database
B.	table
C.	column
D.	view
E.	None of these
Answer» E. None of these

Discussion

12.	abc in the following statement is ____________. CREATE VIEW xyz (abc) AS SELECT a FROM t;
A.	column name
B.	row name
C.	database
D.	view
E.	None of these
Answer» B. row name

Discussion

13.	The following statement is valid. SELECT name, id FROM Employee UNION name, salary FROM Person;
A.	False
B.	True
C.	NA
D.	NA
E.	NA
Answer» C. NA

Discussion

14.	What is Employee in the following statement? SELECT name FROM Employee;
A.	column name
B.	table name
C.	database name
D.	row name
E.	None of these
Answer» C. database name

Discussion

15.	The LOCAL capability for client library is enabled by ______________.
A.	enable-local-infile
B.	enabled-local-file
C.	enable-local-file
D.	enable-global-file
E.	None of these
Answer» B. enabled-local-file

Discussion

16.	What are X 61626364 and X 61626364 ?
A.	dcba and 1633837924
B.	abcd and 1633837924
C.	dcba and 4297383361
D.	abcd and 4297383361
E.	None of these
Answer» C. dcba and 4297383361

Discussion

17.	What is x ffff in decimal?
A.	65537
B.	65536
C.	66535
D.	65534
E.	None of these
Answer» C. 66535

Discussion

18.	The mode used to turn off the special meaning of backslash and treat it as an ordinary character is _____________.
A.	NO_BACKSLASH_ESCAPE
B.	NO_ESCAPES_SLASH
C.	NO_ESCAPES_BACKSLASH
D.	NO_BACKSLASH_ESCAPES
E.	None of these
Answer» E. None of these

Discussion

19.	x in the following statement is ____________.
A.	database name
B.	column name
C.	server name
D.	table name
E.	None of these
Answer» E. None of these

Discussion

20.	abc in the following statement is ___________.
A.	table name
B.	database name
C.	column name
D.	row name
E.	None of these
Answer» D. row name

Discussion

21.	The character that the mysql client program recognizes as a statement delimiter is ______________.
A.	,
B.	;
C.	:
D.	.
E.	None of these
Answer» C. :

Discussion

22.	Execution on a time activated basis according to a schedule is done by _____________.
A.	Stored procedures
B.	Triggers
C.	Stored program
D.	Events
E.	None of these
Answer» E. None of these

Discussion

23.	The log enabled by relay-log-index is _____________
A.	binary log
B.	error log
C.	relay log index
D.	relay log
E.	None of these
Answer» D. relay log

Discussion

24.	The option that supplies the pathname to root directory of MySQL installation is _____________.
A.	port
B.	basedir
C.	datadir
D.	socket
E.	None of these
Answer» C. datadir

Discussion

25.	The command to see the warning messages is ______________.
A.	DISP WARNINGS
B.	SHOW WARNINGS
C.	DISPLAY WARNINGS
D.	DISP WARNING
E.	None of these
Answer» C. DISPLAY WARNINGS

Discussion

26.	Slow shutdown can be performed by setting innodb_fast_shutdown to _____________.
A.	2
B.	1
C.	-1
D.	0
E.	None of these
Answer» E. None of these

Discussion

27.	The privilege that must be given to the database to create a stored function or procedure is ____________.
A.	CREATE PROCEDURE
B.	CREATE METHOD
C.	CREATE ROUTINE
D.	CREATE FUNCTION
E.	None of these
Answer» D. CREATE FUNCTION

Discussion

28.	How would a stored function named PI() written in the database sampdb be called?
A.	db.PI()
B.	MySQL.PI()
C.	PI()
D.	sampdb.PI()
E.	None of these
Answer» E. None of these

Discussion

29.	The mode used to turn on strict mode and all of the additional restrictions is _____________.
A.	TRADITIONAL
B.	ERROR_WHEN_DIVIDE_BY_ZERO
C.	STRICT_ALL_TABLES
D.	ERROR_FOR_DIVISION_BY_ZERO
E.	None of these
Answer» B. ERROR_WHEN_DIVIDE_BY_ZERO

Discussion

30.	The number of values returned from a stored procedure can be _______________.
A.	3
B.	2
C.	1
D.	0
E.	None of these
Answer» E. None of these

Discussion

31.	REPAIR TABLE does not work for _____________.
A.	InnoDB
B.	CSV
C.	ARCHIVE
D.	MyISAM
E.	None of these
Answer» B. CSV

Discussion

32.	Which of the following columns is not returned by OPTIMIZE TABLE ?
A.	Op
B.	Msg_txt
C.	Msg_type
D.	Table
E.	None of these
Answer» C. Msg_type

Discussion

33.	The recovery of data changes made since a given point in time is called _____________.
A.	clear
B.	close
C.	incremental
D.	decremental
E.	None of these
Answer» D. decremental

Discussion

34.	The line which is written at the top of the script to write a Perl script using CGI.pm is ______________.
A.	put CGI
B.	include CGI
C.	use this CGI
D.	use CGI
E.	None of these
Answer» E. None of these

Discussion

35.	abc in the following statement is ____________.
A.	column name
B.	row name
C.	database
D.	view
E.	None of these
Answer» B. row name

Discussion

36.	It is required to have an access privilege for a database before selecting it with USE .
A.	False
B.	True
C.	NA
D.	NA
E.	NA
Answer» C. NA

Discussion

37.	The option which finds the startup options supported by the server through mysqld is ______________.
A.	shutdown
B.	startup
C.	vertex
D.	verbose
E.	None of these
Answer» E. None of these

Discussion

38.	The error log file has a suffix ______________.
A.	.error
B.	.log
C.	.err
D.	.er
E.	None of these
Answer» D. .er

Discussion

39.	In the CREATE TABLE statement the engine name specified is case insensitive.
A.	False
B.	True
C.	NA
D.	NA
E.	NA
Answer» C. NA

Discussion

40.	The name of the format file for a table named my_tbl is __________.
A.	my_tbl.fmr
B.	my_tbl.fmt
C.	my_tbl.ftm
D.	my_tbl.frm
E.	None of these
Answer» E. None of these

Discussion

41.	Server startup can also be done by the ______________.
A.	system file
B.	error file
C.	log file
D.	option file
E.	None of these
Answer» E. None of these

Discussion

42.	The option used to specify the socket file pathname is ______________.
A.	pathtosocket
B.	path_socket
C.	socket_pathfile
D.	socket
E.	None of these
Answer» E. None of these

Discussion

43.	The server listens on a network port for TCP/IP connections unless started with the option ______________.
A.	skip-networking
B.	networking
C.	quit-networking
D.	skip-networks
E.	None of these
Answer» B. networking

Discussion

44.	The keyword used to create a database is __________.
A.	SETUP
B.	LINK
C.	CREATE
D.	SET
E.	None of these
Answer» D. SET

Discussion

45.	The disk data that the FILES table in INFORMATION_SCHEMA stores is ____________.
A.	NBD
B.	NCD
C.	NBK
D.	NDB
E.	None of these
Answer» E. None of these

Discussion

46.	The largest value to which the variable max_allowed_packet can be set is ______________.
A.	2GB
B.	8GB
C.	1GB
D.	4GB
E.	None of these
Answer» D. 4GB

Discussion

47.	The most important configurable resource for MyISAM is ______________.
A.	memory cache
B.	speed cache
C.	key cache
D.	time cache
E.	None of these
Answer» D. time cache

Discussion

48.	The storage engine for which the runtime options are always enabled is ______________.
A.	MEMORY
B.	InnoDB
C.	FEDERATED
D.	Falcon
E.	None of these
Answer» B. InnoDB

Discussion

49.	The search mode that uses natural language search as a subroutine is ____________.
A.	Query expansion
B.	Cross mode
C.	Boolean mode
D.	Natural language
E.	None of these
Answer» B. Cross mode

Discussion

50.	The keyword used with UNION that retains duplicate rows is ___________.
A.	STRICT
B.	ALL
C.	DISTINCT
D.	NARROW
E.	None of these
Answer» C. DISTINCT

Discussion

Explore topic-wise MCQs in Mysql.

Identify the table name in the following statement.INSERT INTO Employee VALUES('Ajit','M',NULL);

x in the following statement is ____________.DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;

In the following code, InnoDB is __________.CREATE TABLE Employee( Emp_name CHAR(30), Emp_id INT(10), PRIMARY KEY (Emp_id) ) ENGINE = InnoDB;

What column names are displayed when this command is executed?SHOW COLUMNS FROM Table_Name LIKE '%name';

abc in the following statement is ___________.DELETE FROM xyz WHERE abc = 5;

The collations this statement lists are ______________.SHOW COLLATION LIKE 'utf8%'

What is tamp in the following command?mysql -h xyz.host.try.net -p -u tamp

What is the host name in the following command?mysql -h interview.mania.com -p -u sampadam

The number of attributes in the following table is ______________.CREATE TABLE Student( name CHAR(30), id INT(11) );

What does Student & name specify?CREATE TABLE Student (name);

xyz in the following statement is __________.CREATE VIEW xyz AS SELECT a, b FROM t;

abc in the following statement is ____________.CREATE VIEW xyz (abc) AS SELECT a FROM t;

The following statement is valid.SELECT name, id FROM Employee UNION name, salary FROM Person;

What is Employee in the following statement?SELECT name FROM Employee;

The LOCAL capability for client library is enabled by ______________.

What are X 61626364 and X 61626364 ?

What is x ffff in decimal?

The mode used to turn off the special meaning of backslash and treat it as an ordinary character is _____________.

x in the following statement is ____________.

abc in the following statement is ___________.

The character that the mysql client program recognizes as a statement delimiter is ______________.

Execution on a time activated basis according to a schedule is done by _____________.

The log enabled by relay-log-index is _____________

The option that supplies the pathname to root directory of MySQL installation is _____________.

The command to see the warning messages is ______________.

Slow shutdown can be performed by setting innodb_fast_shutdown to _____________.

The privilege that must be given to the database to create a stored function or procedure is ____________.

How would a stored function named PI() written in the database sampdb be called?

The mode used to turn on strict mode and all of the additional restrictions is _____________.

The number of values returned from a stored procedure can be _______________.

REPAIR TABLE does not work for _____________.

Which of the following columns is not returned by OPTIMIZE TABLE ?

The recovery of data changes made since a given point in time is called _____________.

The line which is written at the top of the script to write a Perl script using CGI.pm is ______________.

abc in the following statement is ____________.

It is required to have an access privilege for a database before selecting it with USE .

The option which finds the startup options supported by the server through mysqld is ______________.

The error log file has a suffix ______________.

In the CREATE TABLE statement the engine name specified is case insensitive.

The name of the format file for a table named my_tbl is __________.

Server startup can also be done by the ______________.

The option used to specify the socket file pathname is ______________.

The server listens on a network port for TCP/IP connections unless started with the option ______________.

The keyword used to create a database is __________.

The disk data that the FILES table in INFORMATION_SCHEMA stores is ____________.

The largest value to which the variable max_allowed_packet can be set is ______________.

The most important configurable resource for MyISAM is ______________.

The storage engine for which the runtime options are always enabled is ______________.

The search mode that uses natural language search as a subroutine is ____________.

The keyword used with UNION that retains duplicate rows is ___________.

Identify the table name in the following statement.
INSERT INTO Employee VALUES('Ajit','M',NULL);

x in the following statement is ____________.
DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;

In the following code, InnoDB is __________.
CREATE TABLE Employee(
Emp_name CHAR(30),
Emp_id INT(10),
PRIMARY KEY (Emp_id)
) ENGINE = InnoDB;

What column names are displayed when this command is executed?
SHOW COLUMNS FROM Table_Name LIKE '%name';

abc in the following statement is ___________.
DELETE FROM xyz WHERE abc = 5;

The collations this statement lists are ______________.
SHOW COLLATION LIKE 'utf8%'

What is tamp in the following command?
mysql -h xyz.host.try.net -p -u tamp

What is the host name in the following command?
mysql -h interview.mania.com -p -u sampadam

The number of attributes in the following table is ______________.
CREATE TABLE Student(
name CHAR(30),
id INT(11)
);

What does Student & name specify?
CREATE TABLE Student (name);

xyz in the following statement is __________.
CREATE VIEW xyz AS SELECT a, b FROM t;

abc in the following statement is ____________.
CREATE VIEW xyz (abc) AS SELECT a FROM t;

The following statement is valid.
SELECT name, id FROM Employee UNION name, salary FROM Person;

What is Employee in the following statement?
SELECT name FROM Employee;