Examine the description of the PRODCTS table which contains data:

Which two are true?

• A.The PROD ID column can be renamed.
• B.The EXPIRY DATE column cannot be dropped.
• C.The PROD_ ID column data type can be changed to VARCHAR2 (2).
• D.The PROD NAME column cannot have a DEFAULT clause added to it.
• E.The EXPIRY DATE column data type can be changed to TIME STAMP.

Comment: *

Name: *

Email: *

Verification: *

You need to produce a report where each customer's credit limit has been incremented by $1000. In the output, the customer's last name should have the heading Nameand the incremented credit limit should be labeled New Credit Limit. The column headings should have only the first letter of each word in uppercase.
Which statement would accomplish this requirement?

• A.SELECT cust_last_name AS "Name", cust_credit_limit + 1000
  AS "New Credit Limit"
  FROM customers;
• B.SELECT cust_last_name AS Name, cust_credit_limit + 1000
  "New Credit Limit"
  FROM customers;
• C.SELECT INITCAP (cust_last_name) "Name", cust_credit_limit + 1000
  INITCAP ("NEW CREDIT LIMIT")
  FROM customers;
• D.SELECT cust_last_name AS Name, cust_credit_limit + 1000
  AS New Credit Limit
  FROM customers;

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the data in the PRODUCTStable.

Which statement would add a column called PRICE, which cannot contain NULL?
ALTER TABLE products

• A.ADD price NUMBER(8,2) DEFAULT CONSTRAINT p_nn NOT NULL.
• B.ADD price NUMBER(8,2) DEFAULT NOT NULL;
  ALTER TABLE products
• C.ADD price NUMBER(8,2) NOT NULL;
  ALTER TABLE products
• D.ADD price NUMBER(8,2) DEFAULT 0 NOT NULL;
  ALTER TABLE products

Comment: *

Name: *

Email: *

Verification: *

A session's NLS_DATE_FORMAT is set to DD Mon YYYY.
Which two queries return the value 1 Jan 2019?
SELECT TO_DATE('2019-01-01') FROM DUAL;

• A.SELECT DATE '2019-01-01' FROM DUAL;
• B.SELECT '2019-01-01' FROM DUAL;
• C.SELECT TO_CHAR('2019-01-01') FROM DUAL;
• D.SELECT TO_DATE('2019-01-01', 'YYYY-MM-DD') FROM DUAL;
• E.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the PRODUCT_INFORMATION and INVENTORIES tables.

You have a requirement from the supplies department to give a list containing PRODUCT_ID, SUPPLIER_ID, and QUANTITY_ON_HAND for all the products wherein QUANTITY_ON_HAND is less than five.
Which two SQL statements can accomplish the task? (Choose two.)

• A.SELECT i.product_id, i.quantity_on_hand, pi.supplier_idFROM product_information pi JOIN inventories iUSING (product_id) AND quantity_on_hand < 5;
• B.SELECT i.product_id, i.quantity_on_hand, pi.supplier_idFROM product_information pi JOIN inventories iON (pi.product_id=i.product_id) AND quantity_on_hand < 5;
• C.SELECT i.product_id, i.quantity_on_hand, pi.supplier_idFROM product_information pi JOIN inventories iON (pi.product_id=i.product_id)WHERE quantity_on_hand < 5;
• D.SELECT product_id, quantity_on_hand, supplier_idFROM product_informationNATURAL JOIN inventories AND quantity_on_hand < 5;

Comment: *

Name: *

Email: *

Verification: *