What query does Arnold need to write to retrieve the information?

Arnold is trying to gain access to a database by inserting exploited query statements with a WHERE clause. He wants to retrieve all the entries from a particular table (e. g. StudName) using the WHERE clause.

What query does Arnold need to write to retrieve the information?
A . EXTRACT * FROM StudName WHERE roll_number = 1 order by 1000
B . DUMP * FROM StudName WHERE roll_number = 1 AND 1=1―
C . SELECT * FROM StudName WHERE roll_number = " or ‘1’ = ‘1’
D . RETRIVE * FROM StudName WHERE roll_number = 1’#

View Answer

Answer: C