Which three statements are true about Data Manipulation Language (DML)? (Choose three.)

• A.UPDATE statements can have different subqueries to specify the values for each updated column.
• B.INSERT INTO...SELECT...FROMstatements automatically commit.
• C.INSERTstatements can insert NULLS explicitly into a column.
• D.DELETEstatements can remove multiple rows based on multiple conditions.
• E.DML statements require a primary key be defined on a table.

Comment: *

Name: *

Email: *

Verification: *

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

CUSTOMER_VU is a view based on CUSTOMERS_BR1 table which has the same structure as CUSTOMERS table.
CUSTOMERS need to be updated to reflect the latest information about the customers.
What is the error in the following MERGE statement?

• A.The WHERE clause cannot be used with INSERT.
• B.The INTO clause is misplaced in the command.
• C.CUSTOMER_VU cannot be used as a data source.
• D.The CUSTOMER_ID column cannot be updated.

Comment: *

Name: *

Email: *

Verification: *

You issued this command:

Which three statements are true?

• A.Synonyms for HR.EMPLOYEES are dropped.
• B.Sequences used to populate columns in the HR.EMPLOYEES table are dropped.
• C.All constraints defined on HR.EMPLOYEES are dropped.
• D.All indexes defined on HR.EMPLOYEES are dropped.
• E.Views referencing HR.EMPLOYEES are dropped.
• F.The HR.EMPLOYEES table may be moved to the recycle bin.

Comment: *

Name: *

Email: *

Verification: *

View and Exhibit and examine the structure and data in the INVOICE table. (Choose two.)

Which two statements are true regarding data type conversion in query expressions?

• A.inv_no BETWEEN '101' AND '110' : uses implicit conversion
• B.CONCAT(inv_amt, inv_date) : requires explicit conversion
• C.inv_date > '01-02-2008' : uses implicit conversion
• D.inv_date = '15-february-2008' :uses implicit conversion
• E.inv_amt = '0255982' : requires explicit conversion

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the PROMOTIONS table: (Choose the best answer.)

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 DISTINCT promo_cost, promo_category FROM promotions
• D.SELECT promo_category, DISTINCT promo_cost FROM promotions

Comment: *

Name: *

Email: *

Verification: *