Menu
Home / CSE MCQs / MySQL Database MCQs :: Discussion

Discussion :: MySQL Database MCQs

  1. 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;
    2. A.
    emp_id, ACTIVE, emp_id * 314, UPPER(lname)
    B.
    emp_id, Status, emp_pi, last_name
    C.
    Error
    D.
    None of the mentioned

    View Answer

    Workspace

    View Answer

    Answer : Option B

    Explanation :

    Status, emp_pi, last_name are "column aliases and Keyword "AS is optional.

Write your comments here:

Be The First To Comment