Examine the structure of the BOOKS_TRANSACTIONStable.

You want to update this table such that BOOK_IDis set to 'INVALID'for all rows where no MEMBER_ID has been entered.
Examine this partial SQL statement:

Which condition must be used in the WHEREclause to perform the required update?
MEMBER_ID = '';

View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks require subqueries?

View and Exhibit and examine the structure and data in the INVOICE table.

Which two statements are true regarding data type conversion in query expressions? (Choose two.)

Which three are true about multitable INSERT statements?

Which two statements are true about substitution variables? (Choose two.)