View the exhibit and examine the structure of the PROMOTIONStable.
You have to generate a report that displays the promo name and start date for all promos that started after the last promo in the 'INTERNET' category.
Which query would give you the required output?
SELECT promo_name, promo_begin_date FROM promotions
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?
Examine these SQL statements that are executed in the given order:
What will be the status of the foreign key EMP_MGR_FK?
BOOK_SEQ is an existing sequence in your schema.
Which two CREATE TABLE commands are valid?
A)
B)
C)
D)
E)
Examine the structure of the PROGRAMS table:
Which two SQL statements would execute successfully?
