In the customers table, the CUST_CITY column contains the value 'Paris' for the
CUST_FIRST_NAME 'Abigail'.
Evaluate the following query:

What would be the outcome?

• A.Abigail Pa
• B.An error message
• C.Abigail PA
• D.Abigail IS

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the SALES1 table:

SALES2is a table with the same description as SALES1.
Some sales data is duplicated in both tables.
You want to display the rows from the SALES1table which are not present in the SALES2 table.
Which set operator generates the required output?
SUBTRACT

• A.
• B.MINUS
• C.UNION ALL
• D.UNION
• E.INTERSECT

Comment: *

Name: *

Email: *

Verification: *

The STORES table has a column START_ DATE of data type DATE, containing the date the row was inserted.
You only want to display details of rows where START_ DATE is within the last 25 months.
Which WHERE clause can be used?

• A.WHERE ADD_ MONTHS (start_ date, 25) <= SYSDATE
• B.WHERE MONTHS_ BETWEEN (SYSDATE, start_ date) <= 25
• C.WHERE MONTHS_ BETWEEN (start_ date, SYSDATE) <= 25
• D.WHERE TO_ NUMBER (start_ date - SYSDATE) <= 25

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the EMPLOYEES table:

Which query is valid?

• A.SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
• B.SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;
• C.SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
• D.SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;

Comment: *

Name: *

Email: *

Verification: *

View and Exhibit and examine the structure and data in the INVOICE table. (Choose two.)

Which two statements are true regarding data type conversion in query expressions?

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

Comment: *

Name: *

Email: *

Verification: *