MySQL mcq questions and answers | MySQL MCQs Page-5 section-11

Section 1 Section 2 Section 3 Section 4 Section 5 Section 6 Section 7 Section 8 Section 9 Section 10 Section 11 Section 12

41.
Which Keyword is used to remove duplicate rows in the result set?

A. DISTINCTS

B. MODIFY

C. DISTINCT

D. All of the mentioned

Answer & Solution Discuss in Board Save for Later

42.

What will be the output of the following MySQL statement?

SELECT *
FROM employee
WHERE lname LIKE ‘_a%e%’;

A. All employees whose last name start with any letter but second letter should be 'a'

B. All employees whose last name start with any letter but contain at least one 'e' in his name

C. All employees whose last name should have letter 'a' in second position and at least one 'e' in his name

D. All of the mentioned

Answer & Solution Discuss in Board Save for Later

43.
To check if the data directory contains insecure files or directories, the command executed is . . . . . . . .

A. ls -l

B. ls -a

C. ls -la

D. ls -lu

Answer & Solution Discuss in Board Save for Later

44.
Which program is used as a utility for MyISAM table maintenance?

A. innochecksum

B. myisam_ftdump

C. myisamchk

D. myisamlog

Answer & Solution Discuss in Board Save for Later

45.
The MySQL server is not configurable.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

46.

What will be the result of the following MySQL command?

SELECT emp_id,
‘ACTIVE’ AS STATUS,
emp_id * 3.14 AS emp_pi,
UPPER (lname) AS last_name
FROM employee;

A. emp_id, ACTIVE, emp_id * 314, UPPER(lname)

B. emp_id, Status, emp_pi, last_name

C. Error

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

47.

abc in the following MySQL statement is . . . . . . . .

DELETE FROM xyz WHERE abc = 5;

A. column name

B. table name

C. row name

D. database name

Answer & Solution Discuss in Board Save for Later

48.
"MODIFY" is used with which "Query clause"?

A. ALTER

B. FROM

C. WHERE

D. ORDER BY

Answer & Solution Discuss in Board Save for Later

49.
What is the generic handle whose meaning depends on context?

A. $dbh

B. $sth

C. $fh

D. $h

Answer & Solution Discuss in Board Save for Later

50.

In the following MySQL query, "person_1" belongs to which category of table in MySQL?

CREATE VIEW person_1 AS
SELECT fname, lname, person_id FROM person;

A. Permanent Tables

B. Virtual tables

C. Temporary tables

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

41.
Which Keyword is used to remove duplicate rows in the result set?

Answer & Solution

42.
What will be the output of the following MySQL statement?

`SELECT * FROM employee WHERE lname LIKE ‘_a%e%’;`

Answer & Solution

43.
To check if the data directory contains insecure files or directories, the command executed is . . . . . . . .

Answer & Solution

44.
Which program is used as a utility for MyISAM table maintenance?

Answer & Solution

45.
The MySQL server is not configurable.

Answer & Solution

46.
What will be the result of the following MySQL command?

`SELECT emp_id, ‘ACTIVE’ AS STATUS, emp_id * 3.14 AS emp_pi, UPPER (lname) AS last_name FROM employee;`

Answer & Solution

47.
abc in the following MySQL statement is . . . . . . . .

`DELETE FROM xyz WHERE abc = 5;`

Answer & Solution

48.
"MODIFY" is used with which "Query clause"?

Answer & Solution

49.
What is the generic handle whose meaning depends on context?

Answer & Solution

50.
In the following MySQL query, "person_1" belongs to which category of table in MySQL?

`CREATE VIEW person_1 AS SELECT fname, lname, person_id FROM person;`

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

41. Which Keyword is used to remove duplicate rows in the result set?

Answer & Solution

42. What will be the output of the following MySQL statement? SELECT * FROM employee WHERE lname LIKE ‘_a%e%’;

Answer & Solution

43. To check if the data directory contains insecure files or directories, the command executed is . . . . . . . .

Answer & Solution

44. Which program is used as a utility for MyISAM table maintenance?

Answer & Solution

45. The MySQL server is not configurable.

Answer & Solution

46. What will be the result of the following MySQL command? SELECT emp_id, ‘ACTIVE’ AS STATUS, emp_id * 3.14 AS emp_pi, UPPER (lname) AS last_name FROM employee;

Answer & Solution

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

Answer & Solution

48. "MODIFY" is used with which "Query clause"?

Answer & Solution

49. What is the generic handle whose meaning depends on context?

Answer & Solution

50. In the following MySQL query, "person_1" belongs to which category of table in MySQL? CREATE VIEW person_1 AS SELECT fname, lname, person_id FROM person;

Answer & Solution

Read More Section(MySQL Miscellaneous)

41.
Which Keyword is used to remove duplicate rows in the result set?

42.
What will be the output of the following MySQL statement?

`SELECT * FROM employee WHERE lname LIKE ‘_a%e%’;`

43.
To check if the data directory contains insecure files or directories, the command executed is . . . . . . . .

44.
Which program is used as a utility for MyISAM table maintenance?

45.
The MySQL server is not configurable.

46.
What will be the result of the following MySQL command?

`SELECT emp_id, ‘ACTIVE’ AS STATUS, emp_id * 3.14 AS emp_pi, UPPER (lname) AS last_name FROM employee;`

47.
abc in the following MySQL statement is . . . . . . . .

`DELETE FROM xyz WHERE abc = 5;`

48.
"MODIFY" is used with which "Query clause"?

49.
What is the generic handle whose meaning depends on context?

50.
In the following MySQL query, "person_1" belongs to which category of table in MySQL?

`CREATE VIEW person_1 AS SELECT fname, lname, person_id FROM person;`