Selenium Database Management & SQL 2

Question 1

In Selenium test automation, which Java class is commonly used to execute SQL queries against a JDBC data source?

Accepted Answer

java.sql.Statement

Answer

java.sql.Statement is used to execute static SQL queries, while PreparedStatement is for parameterized queries.

Question 2

A Selenium test needs to verify that a newly created user record exists in the database. Which SQL clause is most appropriate to check for a specific email value?

Accepted Answer

WHERE

Answer

The WHERE clause filters rows based on a condition, making it ideal for locating a specific record by a column value.

Question 3

What is the primary advantage of using PreparedStatement over Statement when writing Selenium database verification helpers?

Accepted Answer

It prevents SQL injection by parameterizing inputs

Answer

PreparedStatement uses placeholders that are safely escaped, preventing SQL injection from test data inputs.

Question 4

After a Selenium UI test registers a new account, you run SELECT COUNT(*) FROM users WHERE email='test@test.com'. The result returns 0. What does this indicate?

Accepted Answer

The registration did not persist to the database

Answer

A count of 0 means no matching row was found, indicating the UI registration action did not save data to the database.

Question 5

Which SQL statement should a Selenium test use to clean up test data inserted during a test run?

Accepted Answer

DELETE FROM users WHERE email LIKE 'selenium_%'

Answer

A targeted DELETE with a WHERE clause removes only test-specific rows without affecting real data.

(Selenium) Selenium Testing Certification Practice Test

(Selenium) Selenium Testing Certification Practice Test

Selenium Database Management & SQL 2