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

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.

In the following SQL command "person" stands for?

SELECT person_id, fname, lname, Birth_date FROM person;

A. Table name

B. Attribute

C. Multivalued attribute

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

42.
IP numbers can be represented as . . . . . . . .

A. both integers and a string

B. a string but not integers

C. integers but not a string

D. neither a string nor integers

Answer & Solution Discuss in Board Save for Later

43.

What will be the output of the following MySQL statement?

SELECT *
FROM employee
WHERE lname LIKE ‘F%’ OR lname LIKE ‘%T’;

A. All employees whose last name should started with 'F'

B. All employees whose last name end with 'T'

C. All employees whose last name should started with 'F' and end with 'T'

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

44.
What is the meaning of "Range Conditions"?

A. Expression is equal to Expression

B. Expression is not equal to Expression

C. Expression fall under certain range

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

45.
What is a synonym for CHARACTER SET?

A. CSET

B. CHSET

C. CHARSET

D. CHCSET

Answer & Solution Discuss in Board Save for Later

46.
Which program emulates the client load for a MySQL server?

A. mysqlslap

B. mysqldump

C. mysqladmin

D. mysqlimport

Answer & Solution Discuss in Board Save for Later

47.
Usage of aggregates in WHERE clause is not allowed.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

48.
The clause that can be used to sort string values according to a specific collation is . . . . . . . .

A. SORT

B. GROUP

C. FILTER

D. COLLATE

Answer & Solution Discuss in Board Save for Later

49.
Which column attribute provides unique numbers for identification?

A. AUTO_INCREMENT

B. UNSIGNED

C. IDENTIFY

D. DESCRIBE

Answer & Solution Discuss in Board Save for Later

50.
Which among the following is the correct syntax for modifying the definition of an existing table?

A. ALTER TABLE person MODIFY person_id SMALLINT UNSIGNED AUTO_INCREMENT;

B. ALTER TABLE person person_id SMALLINT UNSIGNED AUTO_INCREMENT;

C. ALTER TABLE person MODIFY person_id ;

D. ALTER TABLE person

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

41.
In the following SQL command "person" stands for?

`SELECT person_id, fname, lname, Birth_date FROM person;`

Answer & Solution

42.
IP numbers can be represented as . . . . . . . .

Answer & Solution

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

`SELECT * FROM employee WHERE lname LIKE ‘F%’ OR lname LIKE ‘%T’;`

Answer & Solution

44.
What is the meaning of "Range Conditions"?

Answer & Solution

45.
What is a synonym for CHARACTER SET?

Answer & Solution

46.
Which program emulates the client load for a MySQL server?

Answer & Solution

47.
Usage of aggregates in WHERE clause is not allowed.

Answer & Solution

48.
The clause that can be used to sort string values according to a specific collation is . . . . . . . .

Answer & Solution

49.
Which column attribute provides unique numbers for identification?

Answer & Solution

50.
Which among the following is the correct syntax for modifying the definition of an existing table?

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

41. In the following SQL command "person" stands for? SELECT person_id, fname, lname, Birth_date FROM person;

Answer & Solution

42. IP numbers can be represented as . . . . . . . .

Answer & Solution

43. What will be the output of the following MySQL statement? SELECT * FROM employee WHERE lname LIKE ‘F%’ OR lname LIKE ‘%T’;

Answer & Solution

44. What is the meaning of "Range Conditions"?

Answer & Solution

45. What is a synonym for CHARACTER SET?

Answer & Solution

46. Which program emulates the client load for a MySQL server?

Answer & Solution

47. Usage of aggregates in WHERE clause is not allowed.

Answer & Solution

48. The clause that can be used to sort string values according to a specific collation is . . . . . . . .

Answer & Solution

49. Which column attribute provides unique numbers for identification?

Answer & Solution

50. Which among the following is the correct syntax for modifying the definition of an existing table?

Answer & Solution

Read More Section(MySQL Miscellaneous)

41.
In the following SQL command "person" stands for?

`SELECT person_id, fname, lname, Birth_date FROM person;`

42.
IP numbers can be represented as . . . . . . . .

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

`SELECT * FROM employee WHERE lname LIKE ‘F%’ OR lname LIKE ‘%T’;`

44.
What is the meaning of "Range Conditions"?

45.
What is a synonym for CHARACTER SET?

46.
Which program emulates the client load for a MySQL server?

47.
Usage of aggregates in WHERE clause is not allowed.

48.
The clause that can be used to sort string values according to a specific collation is . . . . . . . .

49.
Which column attribute provides unique numbers for identification?

50.
Which among the following is the correct syntax for modifying the definition of an existing table?