Examine the structure of the BOOKS_TRANSACTIONS table:

Examine the SQL statement:

Which statement is true about the outcome?

The stores table has a column start__date of data type date, containing the date the row was Inserted.
You only want to display details of rows where start date is within the last 25 months." Which where clause can be used?

You want to write a query that prompts for two column names and the WHEREcondition each time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session.
Which query can be used?

Which three statements are true regarding the WHERE and HAVING clauses in a SQL statement? (Choose three.)

Table EMPLOYEEScontains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)