____________________________________ is used to search for a specific pattern in a column.

Question

Given table 'StudAtt' with structure as (Rno, Attdate, Attendance). Identify the suitable command to add a primary key to the table after creation.
Note: We want to make both Rno and Attdate columns as primary key.

Answer 1

Step 1: Understanding pattern matching.
In SQL, the LIKE operator, in conjunction with wildcards, is employed for searching specific patterns within text data.
Step 2: Wildcards with LIKE.
- The '%' wildcard matches zero, one, or multiple characters.
- The '\_\_' wildcard matches precisely one character.

Step 3: Example.
\begin{verbatim}SELECT name FROM students WHERE name LIKE 'A%';\end{verbatim} This query retrieves all names that commence with the letter 'A'.
Step 4: Eliminate incorrect options.
- Option 1: The BETWEEN operator is used for range checks, not pattern matching.
- Option 2: The IN operator is used for checking against a list of specific values, not patterns.
- Option 4: The NULL operator is used to test for NULL values.

Final Answer: \[\boxed{\text{LIKE operator}}\]

List-I	List-II
(A) SUBSTR()	(II) To extract a substring from a string.
(B) TRIM()	(IV) To remove spaces from both sides of the string.
(C) INSTR()	(I) To find the position of a substring in a string.
(D) LEFT()	(III) To extract characters from the left side of the string.

ENO	SALARY
A101	4000
B109	NULL
C508	6000
A305	2000

____________________________________ is used to search for a specific pattern in a column.

Show Hint

The Correct Option is C

Solution and Explanation

Top Questions on SQL

Questions Asked in CUET (UG) exam