Multiple Choice Questions on Ready the Query carefully SELECT emp name FROM department WHERE d........... for General Studies (Level 1) Preparation

Back to Main Page

Multiple Choice Questions

Ready the Query carefully SELECT emp name FROM department WHERE d...........

Computer GK DBMS
    Download Solution PDF

    Ready the Query carefully:

    SELECT emp_name  

    FROM department  

    WHERE dept_name LIKE ' _____ Computer Science';  

    In the above-given Query, which of the following can be placed in the Query's blank portion to select the "dept_name" that also contains Computer Science as its ending string?

    &

    Incorrect Answer

    _

    Incorrect Answer

    %

    Correct Answer

    $

    Incorrect Answer
    छोटे Courses बड़े Results
    Master DBMS
    Prepare through Micro-courses
    Try Now
    Explanation:

    Answer: C

    In the above-given Query, the "%" (like) operator will be used, which is generally used while searching for a certain pattern in the strings. It represents the single and multiple characters. In this case, it used with "Where "louse to select the "dept_name" that contains the Computer Since as its ending string. To understand it more clearly, consider the following syntax:

    Syntax

    SELECT column1, column2, ...
FROM table_name
WHERE columnN LIKE pattern;

    By: Brijesh Kumar
    ProfileResources

    Let's Discuss

    Master
    DBMS
    With abhipedia
    Micro Courses
    Try Now
    What our students have to say
    Review on us
    Download Abhipedia Android App

    Access to prime resources

    Downlod from playstore
    download android app download android app for free