Mysql miscellaneous


  1. What will be the output of the following query?
    SELECT *
    FROM student
    WHERE last_name LIKE %t%f%n%;











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    All of above


  1. What will be the output of the following query?
    SELECT *
    FROM student
    WHERE last_name LIKE %bas% OR first_name LIKE %bbs%;











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    All student whose last name should contain substring “bas” or first name should contain substring “bbs”



  1. What will be the output of the following query?
    SELECT *
    FROM student
    WHERE last_name LIKE ‘F%’ AND last_name LIKE ‘%T’;











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    All student whose last name should started with ‘F’ and end with ‘T’


  1. What will be the output of the following query?
    SELECT *
    FROM student
    WHERE last_name LIKE ‘F%’ OR last_name LIKE ‘%T’;











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    All student whose last name should started with ‘F’ and end with ‘T’



  1. What will be the output of the following query?
    SELECT *
    FROM student
    WHERE last_name LIKE ‘_a%e%’;











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    All of above