logo

CuriousTab

CuriousTab

Discussion


Home Interview Technology Comments

  • 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

    Technology problems


    Search Results


    • 1. What is the difference between stack and array?
    • Discuss
    • 2. What is DHTML? What are the features of DHTML?
    • Discuss
    • 3. Which of the following can't be done with client-side JavaScript?

    • Options
    • A. Sending a form's contents by email
    • B. Storing the form's contents to a database file on the server
    • C. Validating a form
    • D. None of the above
    • Discuss
    • 4. What is function prototyping? What are its advantages?
    • Discuss
    • 5. What is RDBMS? Explain its features.
    • Discuss
    • 6. A world wide web contains web pages

    • Options
    • A. residing in many computers linked together using HTML.
    • B. with links to other web pages.
    • C. residing in many computers.
    • D. created using HTML.
    • Discuss
    • 7. What are the types of Collision Resolution Techniques and the methods used in each of the type?
    • Discuss
    • 8. Write SQL Query to display current date?
    • Discuss
    • 9. Write an SQL Query find number of employees according to gender whose DOB is between 01/01/1960 to 31/12/1975.
    • Discuss
    • 10. Javascript is interpreted by

    • Options
    • A. Server
    • B. Object
    • C. Client
    • D. None of the above
    • Discuss


    Comments

    There are no comments.

Enter a new Comment