Which wildcard character is used with the SQL LIKE operator to represent zero, one, or multiple characters? MCQ with Answer and Explanation

Question

Share Report Error

Which wildcard character is used with the SQL LIKE operator to represent zero, one, or multiple characters?

A. Underscore (_)

B. Hash (#)

C. Percentage sign (%)

D. Ampersand (&)

Answer: Option C

Solution (By JKSSB Mock Tests)

The percentage sign (%) is used as a wildcard character to match any sequence of zero or more characters in an SQL LIKE string comparison query.

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

Share Report

Which type of join returns all rows from the left table and matching rows from the right table?

A. INNER JOIN

B. RIGHT JOIN

C. FULL JOIN

D. LEFT JOIN

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
LEFT JOIN (or LEFT OUTER JOIN) returns all rows from the left table, with matching rows from the right table; NULLs appear when no match.

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

Question #2

Share Report

Which of the following is a property of a transaction that ensures that the database remains in a valid state before and after the transaction?

A. Atomicity

B. Isolation

C. Durability

D. Consistency

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Consistency ensures that a transaction brings the database from one valid state to another, maintaining all defined rules and constraints.

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