View the exhibit and examine the data in ORDERS_MASTERand MONTHLY_ORDERStables.

Evaluate the following MERGEstatement:
MERGE_INTO orders_master o
USING monthly_orders m
ON (o.order_id = m.order_id)
WHEN MATCHED THEN
UPDATE SET o.order_total = m.order_total
DELETE WHERE (m.order_total IS NULL)
WHEN NOT MATCHED THEN
INSERT VALUES (m.order_id, m.order_total)
What would be the outcome of the above statement?

• A.The ORDERS_MASTERtable would contain the ORDER_IDs1, 2, 3 and 4.
• B.The ORDERS_MASTERtable would contain the ORDER_IDs1, 2 and 4.
• C.The ORDERS_MASTERtable would contain the ORDER_IDs1, 2 and 3.
• D.The ORDERS_MASTERtable would contain the ORDER_IDs1 and 2.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about dropping columns from a table? (Choose two.)

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

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following SQL statement
SQL>SELECT promo_id, prom _category FROM promotions
WHERE promo_category='Internet' ORDER BY promo_id
UNION
SELECT promo_id, promo_category FROM Pomotions
WHERE promo_category = 'TV'
UNION
SELECT promoid, promocategory FROM promotions WHERE promo category='Radio'
Which statement is true regarding the outcome of the above query?

• A.It executes successfully and displays rows in the descend ignore of PROMO CATEGORY.
• B.It produces an error because the ORDER BY clause should appear only at the end of a compound query-that is, with the last SELECT statement.
• C.It produces an error because positional, notation cannot be used in the ORDER BY clause with SBT operators.
• D.It executes successfully but ignores the ORDER BY clause because it is not located at the end of the compound statement.

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the SALES table:

The SALES table has 55,000 rows.
Examine this statement:

Which two statements are true?

• A.SALES1 has PRIMARY KEY and UNIQUE constraints on any selected columns which had those constraints in the SALES table.
• B.SALES1 is created with 1 row.
• C.SALES1 is created with no rows.
• D.SALES1 has NOT NULL constraints on any selected columns which had those constraints in the SALES table.
• E.SALES1 is created with 55,000 rows.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibits and examine PRODUCTSand SALES tables.
Exhibit 1

Exhibit 2

You issue the following query to display product name the number of times the product has been sold:

What happens when the above statement is executed?

• A.The statement produces an error because a subquery in the FROMclause and outer-joins cannot be used together.
• B.The statement produces an error because ITEM_CNTcannot be displayed in the outer query.
• C.The statement produces an error because the GROUP BYclause cannot be used in a subquery in the FROM clause.
• D.The statement executes successfully and produces the required output.

Comment: *

Name: *

Email: *

Verification: *