Examine the description of the PROMOTIONStable:

You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)
SELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM

Which three statements are true about defining relations between tables in a relational database?

View the Exhibit and examine the structure in the DEPARTMENTS tables. (Choose two.)

Examine this SQL statement:
SELECT department_id "DEPT_ID", department_name, 'b' FROM
departments
WHERE departments_id=90
UNION
SELECT department_id, department_name DEPT_NAME, 'a' FROM
departments
WHERE department_id=10
Which two ORDER BY clauses can be used to sort output?

Examine the structure of the BOOKS_TRANSACTIONStable:
Name Null? Type
- --------------- ----------------- ---------------------------
TRANSACTION_ID NOT NULL VARCHAR2 (6)
BORROWED_DATE VARCHAR2 (50)
DUE_DATE DATE
BOOK_ID DATE
MEMBER_ID VARCHAR2 (6)
You want to display the member IDs, due date, and late fee as $2 for all transactions.
Which SQL statement must you execute?

Which three statements are true about GLOBAL TEMPORARY TABLES?