Which of the following MySQL query will display all the NAME from the table…

PYQ EMRS TGT/PGT (ESSE) 2023Modified — slightly modified from the official paper; see the solution

Which of the following MySQL query will display all the NAME from the table STUDENT, which are having exactly five characters and starting with the alphabet ‘A’ ?

  1. A.

    SELECT NAME FROM STUDENT WHERE NAME LIKE 'A____';

  2. B.

    SELECT NAME FROM STUDENT WHERE NAME = 'A____';

  3. C.

    SELECT NAME FROM STUDENT WHERE NAME = 'A%%%%';

  4. D.

    SELECT NAME FROM STUDENT WHERE NAME LIKE 'A%%%%';

Attempted by 500 students.

Sign up free to check your answer

Sign up free

Explore the full course: Emrs Cs Tier 2

Loading lesson…