Login / Signup

Question

A table has a B-tree index on the 'Name' column. Which of the following queries is LEAST likely to benefit from this index?

A SELECT * FROM Employee WHERE Name BETWEEN 'A' AND 'M'

B SELECT * FROM Employee ORDER BY Name

C SELECT * FROM Employee WHERE Name LIKE '%son'

D SELECT * FROM Employee WHERE Name = 'Johnson'

E SELECT * FROM Employee WHERE Name LIKE 'John%'

Practice Next

More SQL Questions

Which type of index physically reorders the data rows in the table itself based on the index key, meaning the data is stored in the order of the index?
Which of the following is a common use case for a PL/SQL trigger?
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
A `BEFORE INSERT` trigger fires:
What is the difference between DELETE, TRUNCATE, and DROP commands in SQL?
What is the main function of a PL/SQL `TRIGGER`?
Customers(cust_id,name): (1,'A'),(2,'B'),(3,'C'). Orders(order_id,cust_id,amount): (1,1,200),(2,2,150),(3,1,300),(4,3,100). What does the following query r...
ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC) assigns:
When does an implicit cursor get automatically declared and managed by PL/SQL?
What is an SQL `VIEW`?

Hey! Ask a query

ask-question

🎓

Think You're Ready for RBI Grade B?

RBI Grade B 2026 Phase 1 Memory Based Paper

200 Questions with Detailed Solutions
Section-wise Coverage (GA, English, Quant & Reasoning)

Download Now 100% Free PDF