Which three are true about subqueries?

• A.< any returns true if the argument is less than the lowest value returned by the subquery.
• B.A subquery can be used in a HAVING clause.
• C.<ANY returns true if the argument is less than the highest value returned by the subquery.
• D.A subquery can be used in a WHERE clause.
• E.=ANY can only evaluate the argument against a subcjuery if it returns two or more values.
• F.A subquery cannot be used in a FROM clause.
• G.A subquery cannot be used in the select list.

Comment: *

Name: *

Email: *

Verification: *

When does a transaction complete? (Choose all that apply.)

• A.When a DELETE statement is executed
• B.When a PL/SQL anonymous block is executed
• C.When a ROLLBACK command is executed
• D.When a TRUNCATE statement is executed after the pending transaction
• E.When a data definition language statement is executed

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the PROMOTION table.

You have to generate a report that displays the promo named start data for all promos that started after that last promo in the 'INTTERNET' category.

• 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 promotion
  WHERE promo-being-date IN (SELECT promo_biing_date
  FROM promotions
  WHERE promo_category='INTYERNET');
• 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 promoptions
  WHERE promo_being_data > ANY (SELCT promo_being-date
  FROM promotions
  WHERE promo_category = 'INTERNET'

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the PROMOTIONS table:

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

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

Comment: *

Name: *

Email: *

Verification: *

SCOTTis a user in the database.
Evaluate the commands issued by the DBA:

Which statement is true regarding the execution of the above commands?

• A.Statement 3 would not execute because role and system privileges cannot be granted together in a single GRANTstatement.
• B.Statement 2 would not execute because system privileges and object privileges cannot be granted together in a single GRANTcommand.
• C.Statement 1 would not execute because the WITH GRANToption is missing.
• D.Statement 1 would not execute because the IDENTIFIED BY <password>clause is missing.

Comment: *

Name: *

Email: *

Verification: *