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

In SQL, what does the wildcard '%' match when used with LIKE?
A. Any string of zero or more characters
B. A specific character
C. Only digits
D. Any single character
Answer: Option A
Solution (By JKSSB Mock Tests)
'%' matches any sequence of zero or more characters, while '_' matches a single character.

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 command to delete a database?
A. DELETE DATABASE
B. TRUNCATE DATABASE
C. REMOVE DATABASE
D. DROP DATABASE

Correct Answer: Option D


Explanation:
DROP DATABASE is the SQL command to delete an entire database.

This question belongs to: Computer Database Management System (DBMS)
Question #2
Which type of database storage anomaly occurs when adding new data to a table is blocked because other unrelated data is missing?
A. Insertion Anomaly
B. Modification Anomaly
C. Update Anomaly
D. Deletion Anomaly

Correct Answer: Option A


Explanation:
An Insertion Anomaly occurs when certain facts cannot be recorded in a database table without falsely manufacturing or requiring the presence of other unrelated facts.

This question belongs to: Computer Database Management System (DBMS)
Question #3
The concept that prevents concurrent transactions from interfering with each other and creating data inconsistencies is known as what?
A. Isolation
B. Consistency
C. Atomicity
D. Durability

Correct Answer: Option A


Explanation:
Isolation ensures that the execution of concurrent transactions does not interfere with one another, making them appear as if they are executing sequentially.

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