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

You want to see the product names and the date of expiration of warranty for all the products, if the product is purchased today. The products that have no warranty should be displayed at the top and the products with maximum warranty period should be displayed at the bottom.
Which SQL statement would you execute to fulfill this requirement?

• A.SELECT product_name, SYSDATE+warranty_period AS "Warranty expire date"FROM product_informationORDER BY SYSDATE
• B.SELECT product_name, SYSDATE+warranty_period AS "Warranty expire date"FROM product_informationORDER BY SYSDATE+warranty_period
• C.SELECT product_name, SYSDATE+warranty_period AS "Warranty expire date"FROM product_informationWHERE warranty_period > SYSDATE
• D.SELECT product_name, SYSDATE+warranty_period AS "Warranty expire date"FROM product_informationORDER BY SYSDATE-warranty_period

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure in the EMPLOYEES tables.

Evaluate the following SQL statement:
SELECT employee_id, department_id
FROM employees
WHERE department_id= 50 ORDER BY department_id
UNION
SELECT employee_id, department_id
FROM employees
WHERE department_id=90
UNION
SELECT employee_id, department_id
FROM employees
WHERE department_id=10;
What would be the outcome of the above SQL statement?

• A.The statement would execute successfully but it will ignore the ORDER BY clause and display the rows in random order.
• B.The statement would execute successfully and display all the rows in the ascending order of DEPARTMENT_ID.
• C.The statement would not execute because the positional notation instead of the column name should be used with the ORDER BY clause.
• D.The statement would not execute because the ORDER BY clause should appear only at the end of the SQL statement, that is, in the last SELECT statement.

Comment: *

Name: *

Email: *

Verification: *

In which three situations does a transaction complete?

• A.when a PL/SQL anonymous block is executed
• B.when a DELETE statement is executed
• C.when a ROLLBACK command is executed
• D.when a data definition language (DDL) statement is executed
• E.when a TRUNCATE statement is executed after the pending transaction

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the BOOKS_TRANSACTIONS table:

You want to display the member IDs, due date, and late fee as $2 for all transactions.
Which SQL statement must you execute?

• A.SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", '$2' AS "LATE FEE" FROM BOOKS_TRANSACTIONS
• B.SELECT member_id AS MEMBER_ID, due_date AS DUE_DATE, $2 AS LATE_FEE
  FROM BOOKS_TRANSACTIONS
• C.SELECT member_id 'MEMBER ID', due_date 'DUE DATE', '$2 AS LATE FEE' FROM BOOKS_TRANSACTIONS;
• D.SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", $2 AS "LATE FEE" FROM BOOKS_TRANSACTIONS

Comment: *

Name: *

Email: *

Verification: *

Examine this business rule:
Each student can work on multiple projects and each project can have multiple students.
You must design an Entity Relationship(ER) model for optimal data storage and allow for generating reports in this format:

Which two statements are true?

• A.STUDENT ID must be the primary key in the STUDENTS entity and foreign key in the PROJECTS entity.
• B.PROJECT_ID must be the primary key in the PROJECTS entity and foreign key in the STUDENTS entity.
• C.The ER must have a many to-many relationship between the STUDENTS and PROJECTS entities that must be resolved into 1-to-many relationships.
• D.The ER must have a 1-to-many relationship between the STUDENTS and PROJECTS entities.
• E.An associative table must be created with a composite key of STUDENT_ID and PROJRCT_ID, which is the foreign key linked to the STUDENTS and PROJECTS entities.

Comment: *

Name: *

Email: *

Verification: *