MySQL mcq questions and answers | MySQL MCQs Page-1 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

1.
To check how MySQL would execute a SELECT query, which statement is used?

A. TELL

B. SHOW

C. DISPLAY

D. EXPLAIN

Answer & Solution Discuss in Board Save for Later

What will be the output of the following SQL statement?

SELECT *
 FROM person;

A. Show all rows and columns of table "person"

B. Show all rows of table "person"

C. Show all columns of table "person"

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

3.
What is the meaning of "GROUP BY" clause in Mysql?

A. Group data by column values

B. Group data by row values

C. Group data by column and row values

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

Is there any error in executing the following MySQL command?

SELECT USER (),
VERSION (), DATABASE ();

A. Yes, "FROM" is not used

B. No

C. Depends

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

5.
Which of the following are the valid "database datatypes" in Mysql?

A. Numerical

B. Temporal

C. Text

D. All of the mentioned

Answer & Solution Discuss in Board Save for Later

With only MyISAM tables, how many of the following are for use?

mysql, mysqladmin, mysqldump, mysqlisamchk

A. 1

B. 2

C. 3

D. 4

Answer & Solution Discuss in Board Save for Later

7.
The datatype SMALLINT stores . . . . . . . .

A. 16 bit

B. 32 bit

C. 48 bit

D. 8 bit

Answer & Solution Discuss in Board Save for Later

8.
How can the value of recently generated sequence number be obtained?

A. LAST_INSERT_ID()

B. LATEST_INSERT_ID()

C. INITIAL_INSERT_ID()

D. INSERT_ID()

Answer & Solution Discuss in Board Save for Later

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

A. select_list

B. table_list

C. row_constraint

D. grouping_columns

Answer & Solution Discuss in Board Save for Later

10.
Which of these is not used to connect to the MySQL server?

A. mysql

B. mysqladmin

C. mysqlcheck

D. mysql_upgrade

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

1.
To check how MySQL would execute a SELECT query, which statement is used?

Answer & Solution

2.
What will be the output of the following SQL statement?

`SELECT * FROM person;`

Answer & Solution

3.
What is the meaning of "GROUP BY" clause in Mysql?

Answer & Solution

4.
Is there any error in executing the following MySQL command?

`SELECT USER (), VERSION (), DATABASE ();`

Answer & Solution

5.
Which of the following are the valid "database datatypes" in Mysql?

Answer & Solution

6.
With only MyISAM tables, how many of the following are for use?

`mysql, mysqladmin, mysqldump, mysqlisamchk`

Answer & Solution

7.
The datatype SMALLINT stores . . . . . . . .

Answer & Solution

8.
How can the value of recently generated sequence number be obtained?

Answer & Solution

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

Answer & Solution

10.
Which of these is not used to connect to the MySQL server?

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

1. To check how MySQL would execute a SELECT query, which statement is used?

Answer & Solution

2. What will be the output of the following SQL statement? SELECT * FROM person;

Answer & Solution

3. What is the meaning of "GROUP BY" clause in Mysql?

Answer & Solution

4. Is there any error in executing the following MySQL command? SELECT USER (), VERSION (), DATABASE ();

Answer & Solution

5. Which of the following are the valid "database datatypes" in Mysql?

Answer & Solution

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

Answer & Solution

7. The datatype SMALLINT stores . . . . . . . .

Answer & Solution

8. How can the value of recently generated sequence number be obtained?

Answer & Solution

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

Answer & Solution

10. Which of these is not used to connect to the MySQL server?

Answer & Solution

Read More Section(MySQL Miscellaneous)

1.
To check how MySQL would execute a SELECT query, which statement is used?

2.
What will be the output of the following SQL statement?

`SELECT * FROM person;`

3.
What is the meaning of "GROUP BY" clause in Mysql?

4.
Is there any error in executing the following MySQL command?

`SELECT USER (), VERSION (), DATABASE ();`

5.
Which of the following are the valid "database datatypes" in Mysql?

6.
With only MyISAM tables, how many of the following are for use?

`mysql, mysqladmin, mysqldump, mysqlisamchk`

7.
The datatype SMALLINT stores . . . . . . . .

8.
How can the value of recently generated sequence number be obtained?

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

10.
Which of these is not used to connect to the MySQL server?