EC-Council
412-79V8 · Question #26
412-79V8 Question #26: Real Exam Question with Answer & Explanation
Sign in or unlock 412-79V8 to reveal the answer and full explanation for question #26. The question stem and answer options stay visible for context.
Question
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. 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?
Exhibit
Options
- AEXTRACT* FROM StudentTable WHERE roll_number = 1 order by 1000
- BDUMP * FROM StudentTable WHERE roll_number = 1 AND 1=1--
- CSELECT * FROM StudentTable WHERE roll_number = '' or '1' = '1`
- DRETRIVE * FROM StudentTable WHERE roll_number = 1'#
Unlock 412-79V8 to see the answer
You've previewed enough free 412-79V8 questions. Unlock 412-79V8 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.