Selenium Database Management & SQL 3

Question 1

Which JDBC method retrieves the value of a specific column from a ResultSet by its column name?

Accepted Answer

resultSet.getString("name")

Answer

ResultSet.getString("columnName") returns the string value of the specified column in the current row.

Question 2

A Selenium framework uses a TestNG @DataProvider backed by a database. Which SQL clause would you add to return only active test cases?

Accepted Answer

WHERE is_active = 1

Answer

The WHERE clause with a boolean condition filters rows to only those where is_active equals 1 (true).

Question 3

What does the SQL JOIN keyword accomplish when used in a Selenium test data query?

Accepted Answer

Combines rows from two tables based on a related column

Answer

JOIN combines rows from multiple tables where a common column value matches, allowing retrieval of related test data.

Question 4

During Selenium end-to-end testing, you need to verify a user's order status in the database after checkout. Which SQL aggregate function counts the number of orders?

Accepted Answer

COUNT()

Answer

COUNT() returns the number of rows matching the query criteria, useful for verifying how many orders were created.

Question 5

A Selenium test modifies an existing record via the UI and then queries the database. Which SQL statement retrieves the updated value?

Accepted Answer

SELECT ... WHERE

Answer

SELECT with a WHERE clause fetches the current value of a row, allowing the test to assert the UI change was persisted.

(Selenium) Selenium Testing Certification Practice Test

(Selenium) Selenium Testing Certification Practice Test

Selenium Database Management & SQL 3