View the Exhibit and examine the structure of the PRODUCT_INFORMATIONtable.

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?
SELECT product_name, SYSDATE+warranty_period AS "Warranty expire date"

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

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the structures of the EMPLOYEESand DEPARTMENTStables.
EMPLOYEES
Name Null? Type
- ---------------- ----- -------------
EMPLOYEE_ID NOT NULL NUMBER(6)
FIRST_NAME VARCHAR2(20)
LAST_NAME NOT NULL VARCHAR2(25)
HIRE_DATE NOT NULL DATE
JOB_ID NOT NULL VARCHAR2(10)
SALARY NUMBER(10,2)
COMMISSION NUMBER(6,2)
MANAGER_ID NUMBER(6)
DEPARTMENT_ID NUMBER(4)
DEPARTMENTS
Name Null? Type
----------------- ----- -------------
DEPARTMENT_ID NOT NULL NUMBER(4)
DEPARTMENT_NAME NOT NULL VARCHAR2(30)
MANAGER_ID NUMBER(6)
LOCATION_ID NUMBER(4)
You want to update EMPLOYEEStable as follows:
Update only those employees who work in Boston or Seattle (locations 2900 and 2700).

Set department_idfor these employees to the department_idcorresponding to London

(location_id 2100).
Set the employees' salary in location_id2100 to 1.1 times the average salary of their department.

Set the employees' commission in location_id2100 to 1.5 times the average commission of their

department.
You issue the following command:
SQL> UPDATE employees
SET department_id
( SELECT department_id
FROM departments
WHERE location_id = 2100),
( salary, commission)
( SELECT 1.1*AVG(salary), 1.5*AVG(commission)
FROM employees, departments
WHERE departments.location_id IN(2900, 2700, 2100))
WHERE department_id IN
( SELECT department_id
FROM departments
WHERE location_id = 2900
OR location_id = 2700;
What is outcome?

• A.It executes successfully but does not give the correct result.
• B.It executes successfully and gives the correct result.
• C.It generates an error because a subquery cannot have a join condition in a UPDATEstatement.
• D.It generates an error because multiple columns (SALARY, COMMISSION)cannot be specified together in an UPDATEstatement.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about Oracle synonyms?

• A.A synonym can have a synonym.
• B.All private synonym names must be unique in the database.
• C.Any user can create a PUBLICsynonym.
• D.A synonym can be created on an object in a package.
• E.A synonym has an object number.

Comment: *

Name: *

Email: *

Verification: *

View and Exhibit and examine the structure and data in the INVOICE table.

Which two statements are true regarding data type conversion in query expressions? (Choose two.)

• A.inv_no BETWEEN '101' AND '110' : uses implicit conversion
• B.inv_date > '01-02-2008' : uses implicit conversion
• C.inv_amt = '0255982' : requires explicit conversion
• D.CONCAT(inv_amt, inv_date) : requires explicit conversion
• E.inv_date = '15-february-2008' :uses implicit conversion

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true reading subqueries? (Choose three.)

• A.A subquery can have more than one main query.
• B.The subquery and main query must retrieve date from the same table.
• C.A Main query can have many subqueries.
• D.Only one column or expression can be compared between the subquery and main query.
• E.Multiple columns or expressions can be compared between the subquery and main query.
• F.The subquery and main query can retrieve data from different tables.

Comment: *

Name: *

Email: *

Verification: *