In SQL, what is the purpose of the LIKE operator? MCQ with Answer and Explanation

Question

Share Report Error

In SQL, what is the purpose of the LIKE operator?

A. To join tables

B. To perform pattern matching on strings

C. To aggregate data

D. To perform arithmetic operations

Answer: Option B

Solution (By JKSSB Mock Tests)

LIKE is used with wildcards (% and _) to search for a specified pattern in a column.

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

In an Entity-Relationship (ER) diagram, attributes are represented using which shape?

A. Diamond

B. Rectangle

C. Ellipse/Oval

D. Square

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ellipses or ovals are used to represent attributes (properties) of entities in ER diagrams.

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

Question #2

In a Relational Database Management System (RDBMS), data is logically organized and stored in which form?

A. Graphs

B. Trees

C. Tables

D. Flat text files

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
In an RDBMS, data is organized into relations, which are logically represented as two-dimensional tables consisting of rows and columns.

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

Question #3

Which SQL statement is used to delete an existing view from the database catalog?

A. CLEAR VIEW

B. REMOVE VIEW

C. DELETE VIEW

D. DROP VIEW

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Because a View is a database structural object, it is removed from the database schema using the DDL command 'DROP VIEW'.

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

Explore All Database Management System (DBMS) MCQs