Which SQL wildcard character is used to match exactly one single character when using the LIKE operator? MCQ with Answer and Explanation

Which SQL wildcard character is used to match exactly one single character when using the LIKE operator?
A. Question mark (?)
B. Underscore (*)
C. Asterisk (*)
D. Percentage sign (%)
Answer: Option B
Solution (By JKExamLibrary)
In SQL pattern matching with the LIKE operator, the underscore (*) represents exactly one single character, while the percent sign (%) matches zero or more characters.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
What does the SQL command 'INSERT INTO' do?
A. Creates a table
B. Adds a new row to a table
C. Deletes rows
D. Updates existing rows

Correct Answer: Option B


Explanation:
INSERT INTO is used to insert new records (rows) into a table.

This question belongs to: Computer Database Management System (DBMS)
Question #2
A Primary Key in RDBMS must be:
A. Duplicate values allowed
B. Can have null values
C. Unique and not null
D. Always a foreign key

Correct Answer: Option C


Explanation:
A primary key uniquely identifies each record and cannot contain null values.

This question belongs to: Computer Database Management System (DBMS)
Question #3
In the relational model, what is the term used to describe the header or definition of a table specifying its name and attributes?
A. Relation Domain
B. Relation Instance
C. Relation Schema
D. Relation Card

Correct Answer: Option C


Explanation:
A Relation Schema defines the structure of a relation, specifying its name and the list of attributes along with their data types.

This question belongs to: Computer Database Management System (DBMS)