Question:
What will be returned by the given query ?
SELECT INSTR("DBITBTTSIT", “IT”);
What will be returned by the given query ?
SELECT INSTR("DBITBTTSIT", “IT”);
SELECT INSTR("DBITBTTSIT", “IT”);
Updated On: Sep 23, 2024
- 2
- 3
- 10
- -2
Hide Solution
Verified By Collegedunia
The Correct Option is B
Solution and Explanation
The correct option is (B) :3.
Was this answer helpful?
0
0
Top Questions on Query using SQL
- Mohan wants to display all the attributes and all the tupIes of the table 'Teacher', help him to choose the correct SQL statement :
(A) Select % from teacher ;
(B) Select from teacher ;
(C) Select all from teacher ;
(D) Select * from teacher ;
Choose the correct answer from the options given below :- CUET (UG) - 2023
- Computer Science
- Query using SQL
- What will be the output of the given SQL Query SELECT DAY("2023-03-01);
- CUET (UG) - 2023
- Computer Science
- Query using SQL
- Which of the following statement is NOT correct ?
A. By default, ORDER by clause sorts the result set in decreasing order
B. SUM() function is used to count the total no. of records in a table
C. By default, ORDER BY clause sorts the results set in increasing order
D. AVG() is an aggregrate function
E. The WHERE clause is used to specify filtering conditions for groups
Consider the correct answer from the options given below :- CUET (UG) - 2023
- Computer Science
- Query using SQL
- What is the output of the following SQL query ?
SELECT * FROM STUDENTS WHERE SName like ‘%S’ and age > 18;- CUET (UG) - 2023
- Computer Science
- Query using SQL
Questions Asked in CUET exam
- Two slits are made 0.1 mm apart and the screen is placed 2 m away. The fringe separation when a light of wavelength 500 nm is used is______.
Fill in the blank with the correct answer from the options given below. - Lower half of a convex lens is made opaque. Which of the following describes the image of the object placed in front of the lens?(A) No change in image
(B) Image will show only half of the object
(C) Intensity of image gets reduced
Choose the correct answer from the options given below. - Complete the sentences given in List-I with the appropriate prepositions given in List-II:
- If $f(x) = x^2 + bx + 1$ is increasing in the interval $[1, 2]$, then the least value of $b$ is:
- CUET (UG) - 2024
- Increasing and Decreasing Functions
- What will be the increasing order of basic strength of the following compounds: \(\text{C}_2\text{H}_5\text{NH}_2, (\text{C}_2\text{H}_5)_2\text{NH},(\text{C}_2\text{H}_5)_3\text{N},\text{C}_6\text{H}_5\text{NH}_2\)
View More Questions