MySQL mcq questions and answers | MySQL MCQs Page-3 section-7

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

21.
If the PIPES_AS_CONCAT is disabled, 'abc' || 'xyz' results in . . . . . . . .

A. 1

B. 0

C. error

D. -1

Answer & Solution Discuss in Board Save for Later

22.
Which keyword is used to specify the foreign key after the table is created?

A. SETUP

B. SET

C. ALTER TABLE

D. SPECIFY

Answer & Solution Discuss in Board Save for Later

23.

Find the error in the following MySQL statement?

SELECT cust_id, fed_id
FROM customer
WHERE cust_id = ’I’
AND fed_id BETWEEN 5000-00-000 AND 9999-999-000;

A. Yes

B. No

C. Range too high to compare

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

24.
Hexadecimal numbers can be used in scientific notation.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

25.
How is a stored procedure invoked?

A. INVOKE

B. SEE

C. CALL

D. RETURN

Answer & Solution Discuss in Board Save for Later

26.

How many of the following do not support 'BIT' data type?

MyISAM, MEMORY, NDB

A. 0

B. 1

C. 2

D. 3

Answer & Solution Discuss in Board Save for Later

27.
Which command is used to remove existing tables or database?

A. DROP TABLE

B. DELETE

C. Either DROP TABLE or DELETE

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

28.
Which clause is used to rename the existing table?

A. RENAME

B. MODIFY

C. ALTER

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

29.
System variable in MySQL server that enables to configure the SQL mode is . . . . . . . .

A. sql_mode

B. sql_config

C. sql_server

D. sql_enable

Answer & Solution Discuss in Board Save for Later

30.
If the scheduler is stopped, no events run.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

21.
If the PIPES_AS_CONCAT is disabled, 'abc' || 'xyz' results in . . . . . . . .

Answer & Solution

22.
Which keyword is used to specify the foreign key after the table is created?

Answer & Solution

23.
Find the error in the following MySQL statement?

`SELECT cust_id, fed_id FROM customer WHERE cust_id = ’I’ AND fed_id BETWEEN 5000-00-000 AND 9999-999-000;`

Answer & Solution

24.
Hexadecimal numbers can be used in scientific notation.

Answer & Solution

25.
How is a stored procedure invoked?

Answer & Solution

26.
How many of the following do not support 'BIT' data type?

`MyISAM, MEMORY, NDB`

Answer & Solution

27.
Which command is used to remove existing tables or database?

Answer & Solution

28.
Which clause is used to rename the existing table?

Answer & Solution

29.
System variable in MySQL server that enables to configure the SQL mode is . . . . . . . .

Answer & Solution

30.
If the scheduler is stopped, no events run.

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

21. If the PIPES_AS_CONCAT is disabled, 'abc' || 'xyz' results in . . . . . . . .

Answer & Solution

22. Which keyword is used to specify the foreign key after the table is created?

Answer & Solution

23. Find the error in the following MySQL statement? SELECT cust_id, fed_id FROM customer WHERE cust_id = ’I’ AND fed_id BETWEEN 5000-00-000 AND 9999-999-000;

Answer & Solution

24. Hexadecimal numbers can be used in scientific notation.

Answer & Solution

25. How is a stored procedure invoked?

Answer & Solution

26. How many of the following do not support 'BIT' data type? MyISAM, MEMORY, NDB

Answer & Solution

27. Which command is used to remove existing tables or database?

Answer & Solution

28. Which clause is used to rename the existing table?

Answer & Solution

29. System variable in MySQL server that enables to configure the SQL mode is . . . . . . . .

Answer & Solution

30. If the scheduler is stopped, no events run.

Answer & Solution

Read More Section(MySQL Miscellaneous)

21.
If the PIPES_AS_CONCAT is disabled, 'abc' || 'xyz' results in . . . . . . . .

22.
Which keyword is used to specify the foreign key after the table is created?

23.
Find the error in the following MySQL statement?

`SELECT cust_id, fed_id FROM customer WHERE cust_id = ’I’ AND fed_id BETWEEN 5000-00-000 AND 9999-999-000;`

24.
Hexadecimal numbers can be used in scientific notation.

25.
How is a stored procedure invoked?

26.
How many of the following do not support 'BIT' data type?

`MyISAM, MEMORY, NDB`

27.
Which command is used to remove existing tables or database?

28.
Which clause is used to rename the existing table?

29.
System variable in MySQL server that enables to configure the SQL mode is . . . . . . . .

30.
If the scheduler is stopped, no events run.