Selenium Database Management & SQL 5

Question 1

Which SQL function returns the current timestamp, commonly used in Selenium tests to verify that a record's created_at field was set during a test run?

Accepted Answer

NOW()

Answer

NOW() returns the current date and time in MySQL/PostgreSQL, allowing comparison with a record's timestamp column.

Question 2

A Selenium test uses a parameterized INSERT to seed test data. After the test, the row must be removed. Which combination correctly seeds and cleans up?

Accepted Answer

INSERT in @Before, DELETE in @After with matching WHERE

Answer

Inserting in a setup method and deleting with a matching WHERE clause in teardown ensures targeted, reversible test data management.

Question 3

When a Selenium test reads test credentials from a database, which SQL practice prevents exposure of passwords in query logs?

Accepted Answer

Using parameterized queries and reading only hashed values

Answer

Parameterized queries avoid embedding sensitive values in the SQL string, and reading only hashed values avoids plain-text exposure.

Question 4

Which SQL clause limits the number of rows returned by a test data query in MySQL, useful for sampling a large dataset?

Accepted Answer

LIMIT N

Answer

LIMIT N restricts the result set to N rows in MySQL, making it efficient for retrieving a sample of test data.

Question 5

A Selenium test asserts that after deleting a user via the UI, the users table has one fewer row. Which SQL approach best supports this assertion?

Accepted Answer

Compare SELECT COUNT(*) before and after the UI action

Answer

Capturing COUNT(*) before and after the UI delete action and asserting the difference equals 1 confirms the row was removed.

(Selenium) Selenium Testing Certification Practice Test

(Selenium) Selenium Testing Certification Practice Test

Selenium Database Management & SQL 5