The SQL statements executed in a user session are as follows:

Which two statements describe the consequences of issuing the ROLLBACK TO SAVE POINT acommand in the session? (Choose two.)

• A.The rollback generates an error.
• B.Only the second DELETEstatement is rolled back.
• C.Both the DELETEstatements and the UPDATEstatement are rolled back.
• D.Only the DELETEstatements are rolled back.
• E.No SQL statements are rolled back.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about date/time functions in a session where NLS_DATE_PORMAT is set to DD-MON-YYYY SH24:MI:SS

• A.SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server.
• B.SYSDATE can be queried only from the DUAL table.
• C.CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of functional seconds.
• D.CURRENT_DATE returns the current date and time as per the session time zone
• E.CURRENT_TIMESTAMP returns the same date as CURRENT_DATE.
• F.SYSDATE can be used in expressions only if the default date format is DD-MON-RR.

Comment: *

Name: *

Email: *

Verification: *

Examine this statement:
SELECT last name
FROM employees
ORDER BY CASE WHEN salary = (SELECT MAX(salary) FROM employees)
THEN 'A'
ELSE last_ name
END ,last_name DESC;
Which two statements are true?

• A.The names of employees earning the maximum salary will appear first in descending order.
• B.All remaining employee names will appear in ascending order.
• C.All remaining employee names will appear in descending order.
• D.The names of employees earning the maximum salary will appear first in an unspecified order.
• E.The names of employees earning the maximum salary will appear first In ascending order.
• F.All remaining employee names will appear in an unspecified order.

Comment: *

Name: *

Email: *

Verification: *

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

Which two SQL statements would execute successfully? (Choose two.)

• A.SELECT MAX(inv_date),MIN(cust_id)FROM invoice;
• B.SELECT AVG(inv_date)FROM invoice;
• C.SELECT AVG( inv_date - SYSDATE), AVG(inv_amt)FROM invoice;
• D.SELECT MAX(AVG(SYSDATE -inv_date))FROM invoice;

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the SALES and PRODUCTS tables. (Choose two.)

In the SALES table, PROD_ID is the foreign key referencing PROD_ID in the PRODUCTS table. You must list each product ID and the number of times it has been sold.
Examine this query which is missing a JOIN operator:
SQL > SELECT p.prod_id, count(s.prod_id)
FROM products p ______________ sales s
ON p.prod_id = s.prod_id
GROUP BY p.prod_id;
Which two JOIN operations can be used to obtain the required output?

• A.JOIN
• B.RIGHT OUTER JOIN
• C.FULL OUTER JOIN
• D.LEFT OUETR JOIN

Comment: *

Name: *

Email: *

Verification: *