Examine the structure of the MEMBERStable:
Name Null? Type
------------------ --------------- ------------------------------
MEMBER_ID NOT NULL VARCHAR2 (6)
FIRST_NAME VARCHAR2 (50)
LAST_NAME NOT NULL VARCHAR2 (50)
ADDRESS VARCHAR2 (50)
You execute the SQL statement:
SQL > SELECT member_id, ' ' , first_name, ' ' , last_name "ID FIRSTNAME LASTNAME " FROM members; What is the outcome?

• A.It fails because the alias name specified after the column names is invalid.
• B.It fails because the space specified in single quotation marks after the first two column names is invalid.
• C.It executes successfully and displays the column details in a single column with only the alias column heading.
• D.It executes successfully and displays the column details in three separate columns and replaces only the last column heading with the alias.

Comment: *

Name: *

Email: *

Verification: *

Examine the command:

What does ON DELETE CASCADE imply?

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

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the BOOKS table:

The table has 100 rows.
Examine this sequence of statements issued in a new session:

Which two statements are true?

• A.The second ROLLBACK command replays the delete.
• B.The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row.
• C.The second ROLLBACK command undoes the insert.
• D.The second ROLLBACK command does nothing.
• E.The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are correct regarding indexes? (Choose three.)

• A.A non-deferrable PRIMARY KEYor UNIQUE KEYconstraint in a table automatically attempts to create a unique index.
• B.Indexes should be created on columns that are frequently referenced as part of any expression.
• C.When a table is dropped, corresponding indexes are automatically dropped.
• D.For each DML operation performed on a table, the corresponding indexes are automatically updated if required.

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following CREATE TABLEcommand:

Which statement is true regarding the above SQL statement?

• A.It would execute successfully and only ORD_ITM_IDX index would be created.
• B.It would give an error because the USING INDEX clause cannot be used on a composite primary.
• 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: *