MySQL · all questions

MySQL
practice.

Practice every MCQ with options. Use Show answers when you want the correct option and solution.

1,185

Questions

32/60

Page

Pick an option on a question to see the right answer and solution.

Q621

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

Select an option to see the answer and solution.

Q622

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

Select an option to see the answer and solution.

Q623

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;

Select an option to see the answer and solution.

Q624

Hexadecimal numbers can be used in scientific notation.

Select an option to see the answer and solution.

Q625

How is a stored procedure invoked?

Select an option to see the answer and solution.

Q626

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

MyISAM, MEMORY, NDB

Select an option to see the answer and solution.

Q627

Which command is used to remove existing tables or database?

Select an option to see the answer and solution.

Q628

Which clause is used to rename the existing table?

Select an option to see the answer and solution.

Q629

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

Select an option to see the answer and solution.

Q630

If the scheduler is stopped, no events run.

Select an option to see the answer and solution.

Q631

MySQL client runs on the machine containing the databases and servers connect to the client over a network.

Select an option to see the answer and solution.

Q632

Which mode does not remove trailing spaces when CHAR values are retrieved?

Select an option to see the answer and solution.

Q633

If an integer column is used for the values in range 1 to 99999, the best suitable datatype is . . . . . . . .

Select an option to see the answer and solution.

Q634

The mantissa in -1.58E5 is . . . . . . . .

Select an option to see the answer and solution.

Q635

The protocol CGI is . . . . . . . .

Select an option to see the answer and solution.

Q636

What represents a 'tuple' in a relational database?

Select an option to see the answer and solution.

Q637

Which of these is defined to execute when the table is modified only?

Select an option to see the answer and solution.

Q638

Which mode is used to turn off the special meaning of backslash and treat it as an ordinary character?

Select an option to see the answer and solution.

Q639

Before MySQL 5.1.6 which privilege was required to create and drop triggers?

Select an option to see the answer and solution.

Q640

Which of these exports table definitions and contents?

Select an option to see the answer and solution.

Prev 30 31 32 33 34 Next