Examine the structure of the PROGRAMS table:
Which two SQL statements would execute successfully? (Choose two.)
Which two statements are true regarding single row functions? (Choose two.)
Examine these statements which execute successfully:
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24 MI: SS'
ALTER SESSION SET TIME_ ZONE = '-5:00';
SELECT DBTIMEZONE, SYSDATE FROM DUAL
Examine the result:
If LOCALTIMESTAMP was selected at the same time what would it return?
Which two tasks can be performed by using Oracle SQL statements? (Choose two.)
View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTSand TIMEStables.
The PROD_IDcolumn is the foreign key in the SALEStable, which references the PRODUCTStable.
Similarly, the CUST_IDand TIME_IDcolumns are also foreign keys in the SALEStable referencing the CUSTOMERSand TIMEStables, respectively.
Evaluate the following CREATE TABLEcommand:
CREATE TABLE new_sales (prod_id, cust_id, order_date DEFAULT SYSDATE)
AS
SELECT prod_id, cust_id, time_id
FROM sales;
Which statement is true regarding the above command?
