Evaluate the structure of the following PRODUCTS table. 

Analyze the following two SQL statements: 

>SELECT prod_id, NVL2 (prod_expiry_date, prod_expiry_date + 15, ‘ ‘) FROM products; >SELECT prod_id, NVL (prod_expiry_date, prod_expiry_date + 15) FROM products; 

Which from the following statements is true about the outcome?

When you issue the following CREATE TABLE statement it results in an error: 

SQL> CREATE TABLE employees(emp_id NUMBER(10) PRIMARY KEY, ename VARCHAR2(20), email NUMBER(3) UNIQUE, address VARCHAR2 (500), phone VARCHAR2(20), resume LONG, hire_date DATE, remarks LONG, dept_id NUMBER(3) CONSTRAINT emp_dept_id_fk REFERENCES departments (dept_id), CONSTRAINT ename_nn NOY NULL(ename)); 

Which from the following statements can explain the error? (Select two.)

Which of the following statements are true regarding conditional INSERT ALL? (Select two.)

Evaluate the structure of the CUSTOMERS table in the 

Exhibit below. 

Evaluate the following two queries, knowing that the report wanted must show the last names and credit limits of all customers whose last names start with A, B, o 

► SELECT cust_last_name, cust_credit_limit FROM customers WHERE (UPPER(cust_last_name) LIKE ‘A%’ OR UPPER (cust_last_name) LIKE ‘B%’ OR UPPER (cust_last_name) LIKE ‘C%’) AND cust_credit_limit < 10000; 

► SELECT cust_last_name, cust_credit_limit FROM customers WHERE UPPER (cust_last_name) BETWEEN ‘A’ AND ‘C’ AND cust_credit_limit < 10000;r C, and their credit limit stands below 10,000. 

Which from the following statements is true in regards of the above queries’ execution?

Analyze the CREATE TABLE commands that follow: 

►CREATE_TABLE orders (ord_no NUMBER (2) CONSTRAINT ord_pk PRIMARY KEY, ord_date DATE, cust_id NUMBER (4)); 

►CREATE TABLE ord_items (ord _no NUMBER (2), item_no NUMBER(3), qty NUMBER (3) CHECK (qty BETWEEEN 100 AND 200), expiry_date date CHECK (expiry_date> SYSDATE), CONSTRAINT it_pk PRIMARY KEY (ord_no, item_no), CONSTARAINT ord_fk FOREIGN KEY (ord_no) REFERENCES orders (ord_no) ); 

Identify a reason for the ORD_ITEMS table has not been created?

Analyze the structure of the PRODUCT table in the Exhibit below. 

Which from the following tasks would require subqueries? (Select two.)

Analyze the structure of ORDERS and CUSTOMERS tables in the Exhibi below. Only one customer shows the value Roberts in the cust_last_name column. 

Which from the following INSERT statements should you use to add a row into the ORDERS table for the customer with the CUST_LAST_NAME as Roberts and whose CREDIT_LIMIT is 600?

Analyze the structure of the following SHIPMENTS table: 

Analyze the following two queries, knowing that is wanted to generate a report which displays the PO_ID along a penalty amount of $20 per day if the SHIPMENT_DATE is later than one month from the PO_DATE. 

Which from the following statements is true in regards of above commands?