aliensbrain
  • Home
  • Study
  • Quizzes
  • 🎤AI Practicefree
  • Notebooks
  • Community
  • Sign in
  • Online Test 2 - Database Management System
  • LIKE “abcd%” ESCAPE ‘’- The statement matches
Multiple choice

LIKE “abcd%” ESCAPE ‘’- The statement matches

  1. all strings beginning with “abcd”

  2. all strings ending with “abcd”

  3. all string beginning with “abcd%”

  4. error in SQL

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Since, backslash () is an escape character, the string must be inserted after "abcd ". 

Keep practicing — related questions

  • Which of the following is a valid wildcard character in a like clause of a SELECT statement?
  • There is a % sign in one field of a column. Say for example table test_chk has a column name1 which contain...
  • There is a % sign in one field of a column. Say for example table test_chk has a column name1 which contain...
  • The Like operator uses some special symbols called wildcards for pattern matching. Which of the following a...
  • Which character is used to continue a statement in SQL*Plus?
  • Retrieving data end with "abc" which wildcard use with like keyword?
  • SQL wildcards must not be used with the SQL LIKE operator.
  • Which of the following is a valid statement to select all the records from a table named city where the val...
Play the full quiz 🎤 Practise this topic out loud
Advertisement
© Aliensbrain | all rights reserved
  • About
  • Contact
  • Terms and Condition
  • Privacy Policy