Selenium Database Management & SQL 4

Question 1

A Selenium test suite uses database snapshots before and after a test to detect unexpected data changes. This practice is best described as:

Accepted Answer

Database state comparison testing

Answer

Database state comparison testing captures a baseline snapshot and compares it after test execution to detect unintended side effects.

Question 2

Which SQL keyword is used to sort database query results in descending order when retrieving the most recently created test records?

Accepted Answer

ORDER BY ... DESC

Answer

ORDER BY column_name DESC sorts the result set so the highest or most recent values appear first.

Question 3

A Selenium automation engineer wants to roll back test data changes if an assertion fails mid-test. Which database feature supports this?

Accepted Answer

Transaction rollback

Answer

Transaction rollback undoes all changes made since the last commit, restoring the database to its prior state on test failure.

Question 4

In a Selenium project, ResultSet.next() returns false immediately after executing a SELECT query. What does this indicate?

Accepted Answer

The query returned no rows

Answer

ResultSet.next() returns false when there are no more rows to iterate, meaning the query matched zero records.

Question 5

Which SQL statement would you use in a Selenium @AfterMethod to reset an auto-incremented ID counter in MySQL?

Accepted Answer

ALTER TABLE table AUTO_INCREMENT = 1

Answer

ALTER TABLE ... AUTO_INCREMENT = 1 resets the auto-increment counter without dropping the table.

(Selenium) Selenium Testing Certification Practice Test