View the exhibit and examine the structure of the PROMOTIONS table.

You have to generate a report that displays the promo name and start date for all promos that started after the last promo in the 'INTERNET' category.
Which query would give you the required output?

• A.SELECT promo_name, promo_begin_date FROM promotionsWHERE promo_begin_date> ANY (SELECT promo_begin_dateFROM promotionsWHERE promo_category= 'INTERNET');
• B.SELECT promo_name, promo_begin_date FROM promotionsWHERE promo_begin_date IN (SELECT promo_begin_dateFROM promotionsWHERE promo_category= 'INTERNET');
• C.SELECT promo_name, promo_begin_date FROM promotionsWHERE promo_begin_date > ALL (SELECT promo_begin_dateFROM promotionsWHERE promo_category = 'INTERNET');
• D.SELECT promo_name, promo_begin_date FROM promotionsWHERE promo_begin_date> ALL (SELECT MAX (promo_begin_date)FROM promotions) ANDpromo_category= 'INTERNET';

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the structure of the PROMOTIONS table.
You have to generate a report that displays the promo name and start date for all promos that started after the last promo in the 'INTERNET' category.
Which query would give you the required output?

• A.SELECT promo_name, promo_begin_date FROM promotionsWHERE
  promo_begin_date> ANY (SELECT promo_begin_dateFROM promotionsWHERE
  promo_category= 'INTERNET');
• B.SELECT promo_name, promo_begin_date FROM promotionsWHERE
  promo_begin_date IN (SELECT promo_begin_dateFROM promotionsWHERE
  promo_category= 'INTERNET');
• C.SELECT promo_name, promo_begin_date FROM promotionsWHERE
  promo_begin_date > ALL (SELECT promo_begin_dateFROM promotionsWHERE
  promo_category = 'INTERNET');
• D.SELECT promo_name, promo_begin_date FROM promotionsWHERE
  promo_begin_date> ALL (SELECT MAX (promo_begin_date)FROM promotions)
  ANDpromo_category= 'INTERNET';

Comment: *

Name: *

Email: *

Verification: *

You issued this command:

Which three statements are true? (Choose three.)

• 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.

Comment: *

Name: *

Email: *

Verification: *

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully?

• A.SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
• B.SELECT TO_CHAR(NVL(cust_credit_limit * .15, 'Not Available')) FROM customers;
• C.SELECT NVL2 (cust_credit_limit * .15, 'Not Available') FROM customers;
• D.SELECT NVL (cust_credit_limit * .15, 'Not Available') FROM customers;
• E.SELECT NVL(TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about sequences in a single instance Oracle database?

• A.Two or more tables cannot have keys generated from the same sequence.
• B.A sequence can only be dropped by a DBA.
• C.A sequence number that was allocated can be rolled back if a transaction fails.
• D.A sequence can issue duplicate values.
• E.A sequence's unallocated cached values are lost if the instance shuts down.
• F.Sequences can always have gaps.

Comment: *

Name: *

Email: *

Verification: *