MySQL · all questions

MySQL
practice.

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

1,185

Questions

26/60

Page

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

Q501

Will the following SQL command produce any error?

INSERT INTO person
(person_id, fname,lname)
VALUES (1,’S’,’U’),
VALUES (1,’T’,’U’);
/* where person_id is a primary key */

Select an option to see the answer and solution.

Q502

If an error occurs during the transaction the troubleshoot is . . . . . . . .

Select an option to see the answer and solution.

Q503

Which command is used for the table definition in Mysql?

Select an option to see the answer and solution.

Q504

The CGI.pm module for website development is a part of . . . . . . . .

Select an option to see the answer and solution.

Q505

MySQL does provides a date type that has an optional time part.

Select an option to see the answer and solution.

Q506

When relocating an individual table, the table to be relocated should be . . . . . . . .

Select an option to see the answer and solution.

Q507

What is generally done after the transactions are executed successfully?

Select an option to see the answer and solution.

Q508

Which statement is used to select columns and rows from the table?

Select an option to see the answer and solution.

Q509

Regardless of whether a database or table name is case sensitive on the system, it must be referred to using the same lettercase throughout a given query.

Select an option to see the answer and solution.

Q510

What is the most important configurable resource for MyISAM?

Select an option to see the answer and solution.

Q511

Which of the following use 'NULL' to indicate failure?

mysql_init(), mysql_real_connect()

Select an option to see the answer and solution.

Q512

Consider a database name "db_name" whose attributes are intern_id (primary key), subject, subject_value.
Intern_id = {1, 2, 3, 4, 5, 6}
Subject = {sql, oop, sql, oop, c, c++}
Subject_value = {0, 0, 1, 1, 2, 2, 3, 3}
If these are one to one relation then what will be the output of the following MySQL statement?

SELECT intern_id
FROM db_name
WHERE subject IN (SELECT subject FROM db_name WHERE subject_value IN (3, 2));

Select an option to see the answer and solution.

Q513

The datatype INT stores . . . . . . . .

Select an option to see the answer and solution.

Q514

When linking to a static MySQL C client library, the client library and the client application must use the same compiler option.

Select an option to see the answer and solution.

Q515

Which of the following returns an SQLSTATE code?

Select an option to see the answer and solution.

Q516

What is the command to see the warning messages?

Select an option to see the answer and solution.

Q517

Which keyword used with UNION retains duplicate rows?

Select an option to see the answer and solution.

Q518

The ALL subquery performs which operation?

Select an option to see the answer and solution.

Q519

UPDATE statement is a DML statement. What does DML stand for?

Select an option to see the answer and solution.

Q520

What is the default size of 'max_binlog_cache_size' system variable?

Select an option to see the answer and solution.

Prev 24 25 26 27 28 Next