View the exhibit and examine the structure of the PROMOTIONStable.

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?
SELECT promo_name, promo_begin_date FROM promotions

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

Comment: *

Name: *

Email: *

Verification: *

In which normal form is a table, if it has no multi-valued attributes and no partial dependencies?

• A.second normal form
• B.first normal form
• C.third normal form
• D.fourth normal form

Comment: *

Name: *

Email: *

Verification: *

Examine the command to create the BOOKS table.

The BOOK_IDvalue 101does not exist in the table.
Examine the SQL statement:

Which statement is true?

• A.It executes successfully and the row is inserted with a rule PUBLISHER_ID.
• B.It executes successfully only if the PUBLISHER_IDcolumn name is added to the columns list in the INSERTstatement.
• C.It executes successfully only if the PUBLISHER_IDcolumn name is added to the columns list and NULL is explicitly specified in the INSERTstatement.
• D.It executes successfully only if NULLis explicitly specified in the INSERTstatement.

Comment: *

Name: *

Email: *

Verification: *

Which three arithmetic operations can be performed on a column by using a SQL function that is built into Oracle database? (Choose three.)

• A.Subtraction
• B.Finding the lowest value
• C.Finding the quotient
• D.Raising to a power
• E.Addition

Comment: *

Name: *

Email: *

Verification: *

Which two are true about self joins?

• A.They are always equijoins.
• B.They have no join condition.
• C.They can use INNER JOIN and LEFT JOIN.
• D.They require the EXISTS opnrator in the join condition.
• E.They require the NOT EXISTS operator in the join condition.
• F.They require table aliases.

Comment: *

Name: *

Email: *

Verification: *