Examine the data in the ORDERS table:

Examine the data in the INVOICES table:

Examine this query:
SELECT order_ id, order_ date FROM orders
INTERSECT
SELECT order_ 1d, order_ date FROM invoices;
Which two rows will it return?

• A.3 01-JAN-2019
• B.4 01-FEB-2019
• C.3 <null>
• D.5 01-MAR-2019
• E.2 <null>
• F.1 <null>

Comment: *

Name: *

Email: *

Verification: *

Examine the data in the ORD_ITEMStable:

Evaluate this query:

Which statement is true regarding the result?

• A.It returns an error because the HAVINGclause should be specified after the GROUP BYclause.
• B.It returns an error because all the aggregate functions used in the HAVINGclause must be specified in the SELECT list.
• C.It displays the item nos with their average quantity where the average quantity is more than double the minimum quantity of that item in the table.
• D.It displays the item nos with their average quantity where the average quantity is more than double the overall minimum quantity of all the items in the table.

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the PRODUCTStable:

Which three queries use valid expressions? (Choose three.)
SELECT product_id, (expiry_date - delivery_date) * 2 FROM products;

• A.SELECT product_id, unit_price | | 5 "Discount", unit_price + surcharge -
• B.discount FROM products;
  SELECT product_id, unit_price, 5 "Discount", unit_price + surcharge - discount
• C.FROM products;
  SELECT product_id, unit_price, unit_price + surcharge FROM products;
• D.SELECT product_id, (unit_price * 0.15 / (4.75 + 552.25)) FROM products;
• E.SELECT product_id, expiry_date * 2 FROM products;

Comment: *

Name: *

Email: *

Verification: *

Refer to the exhibit.

Which three statements are true?

• A.The SALARY column must have a value .
• B.The DNAME column has a unique constraint.
• C.The DEPTNO column in the EMP table can contain the value 1.
• D.The DEPTNO column in the EMP table can contain NULLS .
• E.The COMMISSION column can contain negative values .
• F.The MANAGER column is a foreign key referencing the EMPNO column.
• G.An index is created automatically in the MANAGER column.

Comment: *

Name: *

Email: *

Verification: *

Examine these statements:
CREATE TABLE alter_test (c1 VARCHAR2(10), c2 NUMBER(10));
INSERT INTO alter_test VALUES ('123', 123);
COMMIT;
Which is true ahout modifyIng the columns in AITER_TEST?

• A.c1 can be changed to VARCHAR2(5) and c2 can be changed to NUMBER (12,2).
• B.c1 can be changed to NUMBER(10) and c2 can be changed to VARCHAN2 (10).
• C.c2 can be changed to NUMBER(5) but c1 cannot be changed to VARCHAN2 (5).
• D.c1 can be changed to NUMBER(10) but c2 cannot be changed to VARCHAN2 (10).
• E.c2 can be changed to VARCHAR2(10) but c1 cannot be changed to NUMBER (10).

Comment: *

Name: *

Email: *

Verification: *