Which three statements are true about single row functions? A. They can be used only in the where clause of a select statement. B. They can accept only one argument. C. They return a single result row ...

Which two statements are true about selecting related rows from two tables based on entity relationship diagram (ERD)? A. Relating data from a table with data from the same table is implemented with a ...

Which three queries use valid expressions? A. SELECT product_id,(unit_price * 0.15 / (4.75 + 552.25)) FROM products; B. SELECT product_id,(expiry_date - delivery_date) * 2 FROM products; C. SELECT pro ...

W hich four statements are true regarding primary and foreign key constraints and the effect they can have on table data? A. Only the primary key can be defined at the column and table level. B. The f ...

Which two queries execute successfully? A. SELECT NULLIF(100, 100) FROM DUAL； B. SELECT COALESCE(100, NULL, 200) FROM DUAL； C. SELECT NULLIF(100, 'A') FROM DUAL； D. SELECT NULLIF(NULL, 100) FROM DU ...

BOOK_SEQ is an existing sequence in your schema. Which two CREATE TABLE commands are valid? A. CREATE TABLE bookings (bk_id NUMBER(4) NOT NULL PRIMARY KEY, start_date DATE NOT NULL,end_date DATE DEFA ...

PRODUCTS; PROD_ID CHAR(2) PROD_NAME CHAR(4) EXP_DATE TIMESTAMP (6) NEW PRODUCTS; PROD_ID CHAR(4) PROD_NAME VAR ...

Examine the description of the SALES1 table: Name Null Type SALES_ID NOT NULL NUMBER STORE_ID NOT NULL NUMBER ITEMS_ ...