Which statement is true regarding the default behaviour of the ORDER by clause?

• A.NULLs are not including in the sort operation
• B.In a character sort, the values are case-sensitive.
• C.Only columns that are specified in the SELECT list can be used in the ORDER by clause.
• D.Numeric values are displayed in descending order if they have decimal positions.

Comment: *

Name: *

Email: *

Verification: *

View the exhibits and examine the structures of the COSTSand PROMOTIONStables.


Evaluate the following SQL statement:
SQL> SELECT prod_id FROM costs
WHERE promo_id IN (SELECT promo_id FROM promotions
WHERE promo_cost < ALL
( SELECT MAX(promo_cost) FROM promotions
GROUP BY (promo_end_date-
promo_begin_date)));
What would be the outcome of the above SQL statement?

• A.It displays prod IDs in the promos with the lowest cost in the same time interval.
• B.It displays prod IDs in the promos which cost less than the highest cost in the same time interval.
• C.It displays prod IDs in the promos with the highest cost in the same time interval.
• D.It displays prod IDs in the promo with the lowest cost.

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the PROMOTIONS table: (Choose the best answer.)

Management requires a report of unique promotion costs in each promotion category.
Which query would satisfy this requirement?

• A.SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1
• B.SELECT DISTINCT promo_cost, promo_category FROM promotions
• C.SELECT promo_category, DISTINCT promo_cost FROM promotions
• D.SELECT DISTINCT promo_cost, DISTINCT promo_category FROM promotions;

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following CRTEATE TABLE commands:
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) );
The above command fails when executed. What could be the reason?

• A.SYSDATE cannot be used with the CHECK constraint.
• B.ORD_NO and ITEM_NO cannot be used as a composite primary key because ORD_NO is also the FOREIGN KEY.
• C.The BETWEEN clause cannot be used for the CHECK constraint.
• D.The CHECK constraint cannot be placed on columns having the DATE data type.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about queries using set operators (UNION, UNION ALL, INTERSECT and MINUS?

• A.The name off each column in the first Select list must match the name of the corresponding column In each subsequent select list.
• B.The FOR update clause cannot be specified.
• C.None of the set operators can be used when selecting CLOB columns.
• D.The must be an equal number of columns In each select list.
• E.Each select statement In the query can have an order by clause.

Comment: *

Name: *

Email: *

Verification: *