You issue the following command to drop the PRODUCTStable:
SQL > DROP TABLE products;
Which three statements are true about the implication of this command?

• A.All indexes on the table remain but they are invalidated.
• B.A pending transaction in the session is committed.
• C.All views and synonyms on the table remain but they are invalidated.
• D.All data along with the table structure is deleted.
• E.All data in the table is deleted but the table structure remains.

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the BOOKS_TRANSACTIONS table:
Examine the SQL statement:
Which statement is true about the outcome?

• A.It displays details for only members A101 and A102 who have borrowed before today with RM TRANSACTION_TYPE.
• B.It displays details for members who have borrowed before today's date with either RM as TRANSACTION_TYPE or MEMBER_ID as A101 and A102.
• C.It displays details only for members who have borrowed before today with RM as TRANSACTION_TYPE.
• D.It displays details for members who have borrowed before today with RM as TRANSACTION_TYPE and the details for members A101 or A102.

Comment: *

Name: *

Email: *

Verification: *

Which statements are true regarding primary and foreign key constraints and the effect they can have on table data?

• A.A table can have only one primary key but multiple foreign keys.
• B.It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted.
• C.Primary key and foreign key constraints can be defined at both the column and table level.
• D.Only the primary key can be defined the column and table level.
• E.It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted.
• F.The foreign key columns and parent table primary key columns must have the same names.
• G.A table can have only one primary key and one foreign key.

Comment: *

Name: *

Email: *

Verification: *

You issued this command: DROP TABLE hr. employees;
Which three statements are true?

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

Comment: *

Name: *

Email: *

Verification: *

Examine this Statement which returns the name of each employee and their manager,
SELECT e.last name AS emp,,m.last_name AS mgr
FROM employees e JOIN managers m
ON e.manager_ id = m. employee_ id ORDER BY emp;
You want to extend the query to include employees with no manager. What must you add before JOIN to do this?

• A.CROSS
• B.FULL OUTER
• C.RIGHT OUTER
• D.LEFT OUTER

Comment: *

Name: *

Email: *

Verification: *