Examine the description of the EMPLOYEES table:

The session time zone is the same as the database server
Which two statements will list only the employees who have been working with the company for more than five years?

• A.SELECT employee_ name FROM employees WHERE (SYSNAYW - hire_ data / 12> 3
• B.SELECT employee_ name FROM employees WHERE (CUNACV_ DATE - hire_ data / 12> 3
• C.SELECT employee_ name FROM employees WHERE (CUARENT_ DATE - hire_ data / 365>5
• D.SELECT employee_ name FROM employees WHERE (SYSTIMESTAMP - hire_ data) / 365>
• E.SELECT employee_ name FROM employees WHERE (SYSDATE - hire_ data) / 365>5
• F.SELECT employee_ name FROM employees WHERE (SYSNAYW - hire_ data / 12> 3

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the details of the PRODUCT_INFORMATION table. (Choose two.)

Evaluate this SQL statement:
SELECT TO_CHAR (list_price, '$9,999')
From product_information;
Which two statements are true regarding the output?

• A.A row whose LIST_PRICE column contains value 1123.90 would be displayed as $1,123.
• B.A row whose LIST_PRICE column contains value 11235.90 would be displayed as #######.
• C.A row whose LIST_PRICE column contains value 1123.90 would be displayed as $1,124.
• D.A row whose LIST_PRICE column contains value 11235.90 would be displayed as $1,123.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the data in the employees table.

You want to generate a report showing the total compensation paid to each employee to date.
You issue the following query:

What is the outcome?

• A.It generates an error because the usage of the round function in the expression is not valid
• B.It executes successfully and gives the correct output.
• C.It generates an error because the concatenation operator can be used to combine only two items.
• D.It generates an error because the alias is not valid.
• E.It executes successfully but does not give the correct output.

Comment: *

Name: *

Email: *

Verification: *

The PRODUCT_INFORMATIONtable has a UNIT_PRICEcolumn of data type NUMBER (8, 2).
Evaluate this SQL statement:
SELECT TO_CHAR(unit_price, '$9,999') FROM product_information;
Which two statements are true about the output? (Choose two.)

• A.A row whose UNIT_PRICEcolumn contains the value 10235.99will be displayed as $1,023.
• B.A row whose UNIT_PRICEcolumn contains the value 10235.99will be displayed as $1,0236.
• C.A row whose UNIT_PRICEcolumn contains the value 1023.99will be displayed as $1,024.
• D.A row whose UNIT_PRICEcolumn contains the value 10235.99will be displayed as #######.
• E.A row whose UNIT_PRICEcolumn contains the value 1023.99will be displayed as $1,023.

Comment: *

Name: *

Email: *

Verification: *

Examine the data in the CUSTOMERS table:

You want to list all cities that have more than one customer along with the customer details.
Evaluate the following query:

Which two JOIN options can be used in the blank in the above query to give the correct output? (Choose two.)

• A.JOIN
• B.FULL OUTER JOIN
• C.NATURAL JOIN
• D.LEFT OUTER JOIN
• E.RIGHT OUTER JOIN

Comment: *

Name: *

Email: *

Verification: *