Which three are true about the MERGE statement?

• A.It can use views to produce source rows.
• B.It can combine rows from multiple tables conditionally to insert into a single table.
• C.It can merge rows only from tables.
• D.It can update, insert, or delete rows conditionally in multiple tables.
• E.It can use subqueries to produce source rows.
• F.It can update the same row of the target table multiple times.

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following CREATE TABLEcommand:

Which statement is true regarding the above SQL statement?

• A.It would give an error because the USING INDEX clause cannot be used on a composite primary.
• B.It would execute successfully and only ORD_ITM_IDX index would be created.
• C.It would give an error because the USING INDEX clause is not permitted in the CREATE TABLE command.
• D.It would execute successfully and two indexes ORD_ITM_IDX and ORD_ITM_ID_PK would be created.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about transactions in the Oracle Database server?

• A.If a session has an uncommitted transaction, then a DDL statement issues a COMMIT before starting a new transaction.
• B.Data Manipulation Language (DML) statements always start a new transaction.
• C.A user can always see uncommitted updates made by the same user in a different session.
• D.A Data Definition Language (DDL) statement does a COMMIT automatically only for the data dictionary updates caused by the DDL.
• E.A session can always see uncommitted updates made by itself.
• F.An uncommitted transaction commits automatically if the user exists SQL*Plus.

Comment: *

Name: *

Email: *

Verification: *

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

• A.An INSERT INTO...VALUES.. statement can add multiple rows per execution to a table.
• B.An UPDATE... SET... statement can modify multiple rows based on multiple conditions on a table.
• C.A DELETE FROM..... statement can remove rows based on only a single condition on a table.
• D.An INSERT INTO... VALUES..... statement can add a single row based on multiple conditions on a table.
• E.A DELETE FROM..... statement can remove multiple rows based on multiple conditions on a table.
• F.An UPDATE....SET.... statement can modify multiple rows based on only a single condition on a table.

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following SQL statement:
SQL> select cust_id, cust_last_name "Last name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses either one of which can complete the query.

• A.ORDER BY "Last name"
• B.ORDER BY 2, cust_id
• C.ORDER BY CUST_NO
• D.ORDER BY 2, 1
• E.ORDER BY "CUST_NO"

Comment: *

Name: *

Email: *

Verification: *