MySQL mcq questions and answers | MySQL MCQs Page-2 section-11

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

11.

What will be the output of the following MySQL command?

SELECT * 
FROM person
WHERE emp_id IS NULL;

A. Only those columns whose emp_id is NULL

B. Only those columns whose emp_id is not NULL

C. No output

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

12.
Which feature is used for the automatic increment of the column?

A. AUTO_INCREMENT

B. AUTO

C. INCREMENT

D. All of the mentioned

Answer & Solution Discuss in Board Save for Later

13.
In Boolean search, results are sorted by relevance.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

14.
The statement that constructs a branching flow-control construct is . . . . . . . .

A. BEGIN...END

B. CASE

C. ITERATE

D. LEAVE

Answer & Solution Discuss in Board Save for Later

15.
For which of these is the startup option best suited?

A. entire data directory

B. individual database tables

C. server PID file

D. individual database directories

Answer & Solution Discuss in Board Save for Later

16.
Which of the following operators is/are used in "Condition Evaluation"?

A. AND

B. OR

C. NOT

D. All of the mentioned

Answer & Solution Discuss in Board Save for Later

17.
Which of these is not an exact numeric type?

A. SMALLINT

B. DECIMAL

C. NUMERIC

D. REAL

Answer & Solution Discuss in Board Save for Later

18.
The keyword used to create a database is . . . . . . . .

A. CREATE

B. SET

C. SETUP

D. LINK

Answer & Solution Discuss in Board Save for Later

19.
Which of these comparisons is slowest?

A. INT/INT

B. INT/BIGINT

C. BIGINT/BIGINT

D. All are of same speed

Answer & Solution Discuss in Board Save for Later

20.
Among the following, for which language is image processing least simple?

A. PHP

B. Perl

C. Python

D. C

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

11.
What will be the output of the following MySQL command?

`SELECT * FROM person WHERE emp_id IS NULL;`

Answer & Solution

12.
Which feature is used for the automatic increment of the column?

Answer & Solution

13.
In Boolean search, results are sorted by relevance.

Answer & Solution

14.
The statement that constructs a branching flow-control construct is . . . . . . . .

Answer & Solution

15.
For which of these is the startup option best suited?

Answer & Solution

16.
Which of the following operators is/are used in "Condition Evaluation"?

Answer & Solution

17.
Which of these is not an exact numeric type?

Answer & Solution

18.
The keyword used to create a database is . . . . . . . .

Answer & Solution

19.
Which of these comparisons is slowest?

Answer & Solution

20.
Among the following, for which language is image processing least simple?

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

11. What will be the output of the following MySQL command? SELECT * FROM person WHERE emp_id IS NULL;

Answer & Solution

12. Which feature is used for the automatic increment of the column?

Answer & Solution

13. In Boolean search, results are sorted by relevance.

Answer & Solution

14. The statement that constructs a branching flow-control construct is . . . . . . . .

Answer & Solution

15. For which of these is the startup option best suited?

Answer & Solution

16. Which of the following operators is/are used in "Condition Evaluation"?

Answer & Solution

17. Which of these is not an exact numeric type?

Answer & Solution

18. The keyword used to create a database is . . . . . . . .

Answer & Solution

19. Which of these comparisons is slowest?

Answer & Solution

20. Among the following, for which language is image processing least simple?

Answer & Solution

Read More Section(MySQL Miscellaneous)

11.
What will be the output of the following MySQL command?

`SELECT * FROM person WHERE emp_id IS NULL;`

12.
Which feature is used for the automatic increment of the column?

13.
In Boolean search, results are sorted by relevance.

14.
The statement that constructs a branching flow-control construct is . . . . . . . .

15.
For which of these is the startup option best suited?

16.
Which of the following operators is/are used in "Condition Evaluation"?

17.
Which of these is not an exact numeric type?

18.
The keyword used to create a database is . . . . . . . .

19.
Which of these comparisons is slowest?

20.
Among the following, for which language is image processing least simple?