MySQL Database MCQs - CSE MCQs Questions and Answers

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

What will be the output of the following statement "false AND Null?

false

Null

Depend

None of the mentioned

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

"COUNT keyword belongs to which categories in Mysql?

Aggregate functions

Operators

Clauses

All of the mentioned

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

Which clause is used with an "aggregate functions?

GROUP BY

SELECT

WHERE

Both a and c

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

If emp_id contain the following set {-1, -2, 2, 3, -3, 1}, what will be the output on execution of the given query?

SELECT emp_id

FROM person

ORDER BY emp_id;

{-3, -2, -1, 1, 2, 3}

{-1, 1, -2, 2, -3, 3}

{1, 2, 3, -1, -2, -3}

None of the mentioned

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the given query?

SELECT emp_id

FROM person

ORDER BY emp_id DESC;

{9, 7, 6, 4, 3, 1, 2}

{1, 2, 3, 4, 6, 7 , 9}

{2, 1, 3, 4, 6, 7, 9}

None of the mentioned

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

Is there any error in the following query?

SELECT emp_id, title, start_date, fname, fed_id

FROM person

ORDER BY RIGHT (fed_id, 3);

Yes

No error

Depends

None of the mentioned

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

What will be the output of a query given below?

SELECT person_id, Fname, lname

FROM person;

Show only columns (person_id, Fname, lname) and rows related to these columns

Show only columns (person_id, Fname, lname)

Show all rows

Show all columns except (person_id, Fname, lname)

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

What will be the result of the query given below?

SELECT emp_id,

'ACTIVE' AS STATUS,

emp_id * 3.14 AS emp_pi,

UPPER (lname) AS last_name

FROM employee;

emp_id, ACTIVE, emp_id * 314, UPPER(lname)

emp_id, Status, emp_pi, last_name

Error

None of the mentioned