A.It fails because a column number and a column alias cannot be used together in the ORDER BY clause.

B.It displays all cities in descending order, within which the last names are further sorted in descending order.

C.It fails because a column alias cannot be used in the ORDER BY clause.

D.It displays all cities in ascending order, within which the last names are further sorted in descending order.

A.SELECT 'The first_name is '' || first_name || '' FROM employees;

B.SELECT 'The first_name is ' || first_name || '' FROM employees;

C.SELECT 'The first_name is ''' || first_name || ''' FROM employees;

D.SELECT 'The first_name is \'' || first_name || '\'' FROM employees;

E.SELECT 'The first_name is ''' || first_name || '''' FROM employees;

A.Views referencing HR.EMPLOYEESare dropped.

B.All constraints defined on HR.EMPLOYEESare dropped.

C.Sequences used to populate columns in the HR.EMPLOYEEStable are dropped.

D.The HR.EMPLOYEEStable may be moved to the recycle bin.

E.All indexes defined on HR.EMPLOYEESare dropped.

F.Synonyms for HR.EMPLOYEESare dropped.

A.They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.

B.They are evaluated by the first WHEN clause. If the condition is true, then the row would be evaluated by the subsequent WHEN clauses.

C.They are evaluated by the first WHEN clause. If the condition is false, then the row would be evaluated by the subsequent WHEN clauses.

D.The insert statement would give an error because the ELSE clause is not present for support in case none of WHEN clauses are true.

A.SELECT promo_neme, promo_being_date FROM promotions
WHERE promo_being_date > All (SELECT promo_beinjg-date
FROM promotions
WHERE promo_category ='INTERNET' );

B.Select promo_name, promo_being_date FROM promoptions
WHERE promo_being_data > ANY (SELCT promo_being-date
FROM promotions
WHERE promo_category = 'INTERNET'

C.SELECT promo-name, promo-being _date FROM promotions
Where promo_being_data >ALL (SELECT MAX (promo_being-date)
FROM promotions ) AND
Promo-category ='INTERNET';

D.SELECT promo-name, promo-being_date FROM promotion
WHERE promo-being-date IN (SELECT promo_biing_date
FROM promotions
WHERE promo_category='INTYERNET');