ECCouncil EC-Council Certified Security Analyst (ECSA) V10 412-79v10 Question # 15 Topic 2 Discussion

ECCouncil EC-Council Certified Security Analyst (ECSA) V10 412-79v10 Question # 15 Topic 2 Discussion

412-79v10 Exam Topic 2 Question 15 Discussion:
Question #: 15
Topic #: 2

A WHERE clause in SQL specifies that a SQL Data Manipulation Language (DML) statement should only affect rows that meet specified criteria. The criteria are expressed in the form of predicates. WHERE clauses are not mandatory clauses of SQL DML statements, but can be used to limit the number of rows affected by a SQL DML statement or returned by a query.

412-79v10 Question 15

A pen tester is trying to gain access to a database by inserting exploited query statements with a WHERE clause. The pen tester wants to retrieve all the entries from the database using the WHERE clause from a particular table (e.g. StudentTable).

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


A.

EXTRACT* FROM StudentTable WHERE roll_number = 1 order by 1000


B.

DUMP * FROM StudentTable WHERE roll_number = 1 AND 1=1—


C.

SELECT * FROM StudentTable WHERE roll_number = '' or '1' = '1‘


D.

RETRIVE * FROM StudentTable WHERE roll_number = 1'#


Get Premium 412-79v10 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.