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> ALL (SELECT MAX (promo_begin_date)FROM promotions) ANDpromo_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> ANY (SELECT promo_begin_dateFROM promotionsWHERE promo_category= 'INTERNET');
• D.SELECT promo_name, promo_begin_date FROM promotionsWHERE promo_begin_date > ALL (SELECT promo_begin_dateFROM promotionsWHERE promo_category = 'INTERNET');

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the EMPLOYEEStable:

Which two queries return all the rows for employees whose salary is greater than the average salary in their department? (Choose two.)

• A.
• B.
• C.
• D.
• E.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about dropping columns from a table?

• A.A column can be removed only if it contains no data.
• B.Multiple columns can be dropped simultaneously using the ALTER TABLE command.
• C.A column must be set as unused before it is dropped from a table.
• D.A primary key column cannot be dropped.
• E.A column drop is implicitly committed.
• F.A column that is referenced by another column in any other table cannot be dropped.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the description of the PRODUCT_INFORMATION table.

Which SQL statement would retrieve from the table the number of products having LIST_PRICE as NULL?

• A.SELECT COUNT (DISTINCT list_price)FROM product_informationWHERE list_price is NULL
• B.SELECT COUNT (NVL(list_price, 0))FROM product_informationWHERE list_price is NULL
• C.SELECT COUNT (list_price)FROM product_informationWHERE list_price i= NULL
• D.SELECT COUNT (list_price)FROM product_informationWHERE list_price is NULL

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the details of the PRODUCT_INFORMATION table. (Choose two.)

Evaluate this SQL statement:
SELECT TO_CHAR(list_price,'$9,999')
From product_information;
Which two statements are true regarding the output? (Choose two.)

• A.A row whose LIST_PRICE column contains value 1123.90 would be displayed as $1,123.
• B.A row whose LIST_PRICE column contains value 11235.90 would be displayed as #######.
• C.A row whose LIST_PRICE column contains value 11235.90 would be displayed as $1,123.
• D.A row whose LIST_PRICE column contains value 1123.90 would be displayed as $1,124.

Comment: *

Name: *

Email: *

Verification: *