In SQL, what does the wildcard '%' match when used with LIKE? MCQ with Answer and Explanation

Question

Share Report Error

In SQL, what does the wildcard '%' match when used with LIKE?

A. Only digits

B. A specific character

C. Any string of zero or more characters

D. Any single character

Answer: Option C

Solution (By JKSSB Mock Tests)

'%' matches any sequence of zero or more characters, while '_' matches a single character.

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

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1

Which of the following is a valid SQL string function?

A. CONCAT

B. REPLACE

C. SUBSTRING

D. All of the above

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
SUBSTRING, CONCAT, and REPLACE are common string functions in SQL.

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

Question #2

What is the full form of RDBMS?

A. Relational Database Management System

B. Relational Data Binary Management System

C. Real-time Database Management Software

D. Random Data Backup Management System

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
RDBMS stands for Relational Database Management System.

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

Question #3

An attribute whose value is computed dynamically from another attribute (such as calculating Age from Date_of_Birth) is called a what?

A. Multi-valued Attribute

B. Derived Attribute

C. Base Attribute

D. Stored Attribute

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A Derived Attribute is an attribute whose values are not stored physically in the database but are calculated at runtime from other stored attributes.

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

Explore All Database Management System (DBMS) MCQs