logo

CuriousTab

CuriousTab

Discussion


Home Interview Technology See What Others Are Saying!
  • Question
  • Which operator performs pattern matching ?


  • Options
  • A. LIKE operator
  • B. EXISTS operator
  • C. BETWEEN operator
  • D. None of these

  • Correct Answer
  • LIKE operator 

    Explanation

    LIKE is a keyword that is used in the WHERE clause. Basically, LIKE allows us to do a search based operation on a pattern rather than specifying exactly what is desired (as in IN) or spell out a range (as in BETWEEN).

     

    The syntax is as follows:
    SELECT "column_name"
    FROM "table_name"
    WHERE "column_name" LIKE {PATTERN}

     

    {PATTERN} often consists of wildcards.

     

    In SQL, there are two wildcards:


    % (percent sign) represents zero, one, or more characters.

    _ (underscore) represents exactly one character.

     

    More :: Certification Questions on SQL

  • Tags: Software Architect, IT Trainer, Database Administrator, Analyst

    More questions

    • 1. What is onshore outsourcing?
    • Discuss
    • 2. What is the Use of SPAN in HTML and give one example?
    • Discuss
    • 3. .What are the different types of environments available in the web?
    • Discuss
    • 4. What is web portal?
    • Discuss
    • 5. What is web application?
    • Discuss
    • 6. Describe a time when your workload was heavy and how you handled it?
    • Discuss
    • 7. Describe a time when you made a mistake ?
    • Discuss
    • 8. How do you parse/validate the XML document?
    • Discuss
    • 9. What major challenges and problems did you face? How did you handle them?
    • Discuss
    • 10. What do you like to do when you're not at work?
    • Discuss


    Comments

    There are no comments.

Enter a new Comment