MySQL · all questions

MySQL
practice.

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

1,185

Questions

55/60

Page

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

Q1081

What will be the result of the following MySQL command?

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

Select an option to see the answer and solution.

Q1082

The exec_stmt_ssl is written in . . . . . . . .

Select an option to see the answer and solution.

Q1083

What is the kind of delete when deletion of an employee from the table also deletes that employee from another table?

Select an option to see the answer and solution.

Q1084

What is the best datatype for a column that is expected to store values up to 2 million?

Select an option to see the answer and solution.

Q1085

All API calls return a value.

Select an option to see the answer and solution.

Q1086

"Numeric Data" is used to store . . . . . . . .

Select an option to see the answer and solution.

Q1087

Stored programs degrade database security.

Select an option to see the answer and solution.

Q1088

Is there any error in the following MySQL command?

SELECT emp_id, title, start_date, fname, fed_id
FROM person
ORDER BY LEFT (fed_id, 3);

Select an option to see the answer and solution.

Q1089

mysql_next_result() does not return a status.

Select an option to see the answer and solution.

Q1090

What will be the output of the following MySQL statement?

SELECT emp_id, fname, lname
FROM employee
WHERE LEFT (lname, 1) =’T’;

Select an option to see the answer and solution.

Q1091

What is generally done if an error occurs during the transaction?

Select an option to see the answer and solution.

Q1092

Which are the two languages used in Mysql?

Select an option to see the answer and solution.

Q1093

On Unix, 'mysql' client writes a record of executed statements to a history file.

Select an option to see the answer and solution.

Q1094

How many of the following do not return rows?

SELECT, SHOW, DESCRIBE

Select an option to see the answer and solution.

Q1095

Which statement is used to create a trigger?

Select an option to see the answer and solution.

Q1096

'character_set_database' represents the character set used by the default database.

Select an option to see the answer and solution.

Q1097

What will be the output of the following MySQL command?

SELECT *
FROM employee
WHERE title=’HEAD TELLER’;

Select an option to see the answer and solution.

Q1098

To combine multiple retrievals, which keyword is used to write several SELECT statements between them?

Select an option to see the answer and solution.

Q1099

The join in which all the rows from the right table appear in the output irrespective of the content of the other table is . . . . . . . .

Select an option to see the answer and solution.

Q1100

The storage size in bytes required for the MEDIUMINT datatype is . . . . . . . .

Select an option to see the answer and solution.

Prev 53 54 55 56 57 Next