Evaluate the following statement.

Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?

• A.The INSERT statement will return an error because the ELSE clause is missing.
• B.Each row is evaluated by the first WHEN clause and if the condition is true, then the row would be evaluated by the subsequent WHEN clauses.
• C.All rows are evaluated by all the three WHEN clauses.
• D.Each row is evaluated by the first WHEN clause and if the condition is false then the row would be evaluated by the subsequent WHEN clauses.

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the CUSTOMERS table: (Choose two.)

CUSTNO is the PRIMARY KEY.
You must determine if any customers' details have been entered more than once using a different CUSTNO, by listing all duplicate names.
Which two methods can you use to get the required result?

• A.Subquery
• B.Right outer-join with self-join
• C.Self-join
• D.Full outer-join with self-join
• E.Left outer-join with self-join

Comment: *

Name: *

Email: *

Verification: *

Examine the command:

What does ON DELETE CASCADE imply?

• A.When the BOOKStable is dropped, the BOOK_TRANSACTIONStable is dropped.
• B.When the BOOKStable is dropped, all the rows in the BOOK_TRANSACTIONStable are deleted but the table structure is retained.
• C.When a row in the BOOKStable is deleted, the rows in the BOOK_TRANSACTIONStable whose BOOK_ID matches that of the deleted row in the BOOKStable are also deleted.
• D.When a value in the BOOKS.BOOK_IDcolumn is deleted, the corresponding value is updated in the BOOKS_TRANSACTIONS.BOOK_IDcolumn.

Comment: *

Name: *

Email: *

Verification: *

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

The BOOKS table contains details of 100 books.
Examine the commands executed and their outcome:

Which statement is true?

• A.The first rollback restores the 100 rows that were deleted and the second rollback commits only the changes.
• B.Both ROLLBACK commands restore the 101 rows that were deleted.
• C.The first rollback restores the 101 rows that were deleted and the second rollback causes the row was inserted to be deleted and commits the changes.
• D.Both ROLLBACK commands restore the 100 rows that were deleted.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about substitution variables? (Choose two.)

• A.A substitution variable can be used with any clause in a SELECT statement
• B.A substitution variable used to prompt for a column name must be enclosed in a single quotation marks
• C.A substitution variable prefixed with & always prompts only once for a value in a session
• D.A substitution variable can be used only in a SELECT statement
• E.A substitution variable used to prompt for a column name must be enclosed in double quotation marks
• F.A substitution variable prefixed with && prompts only once for a value in a session unless it is set to undefined in the session

Comment: *

Name: *

Email: *

Verification: *