Examine thee statements Which execute successfully:

Which two are true? (Choose two.)

A. User FIN_CLERK can grant SELECT on SCOTT.EMP to user FIN_MANAGER.

B. Dropping user FINANCE will automatically revoke SELECT on SCOTT.EMP from user FIN_CLERK.

C. User FINANCE can grant CREATE SESSION to user FIN_MANAGER.

D. Revoking SELECT on SCOTT.EMP from user FINANCE will also revoke the privilege from user FIN_CLERK.

E. User FINANCE is unable to grant all on SCOTT.EMP to FIN_MANAGER.

The SALES table has columns PROD_ID and QUANTITY_SOLD of data type NUMBER.

Which two queries execute successfully?

A. SELECT COUNT(prod_id) FROM sales WHERE quantity_sold>55000 GROUP BY prod_id;

B. SELECT prod_id FROM sales WHERE quantity_sold> 55000 GROUP BY prod_id HAVING COUNT(*)> 10;

C. SELECT COUNT(prod_id) FROM sales GROUP BY prod_id WHERE quantity_sold> 55000;

D. SELECT prod_id FROM sales WHERE quantity_sold> 55000 AND COUNT(*)> 10 GROUP BY COUNT(*)> 10;

E. SELECT prod_id FROM sales WHERE quantity_sold> 55000 AND COUNT(*)> 10 GROUP BY prod_id HAVING COUNT(*)> 10;

Which three statements are true about sequences in a single instance Oracle database? (Choose three.)

A. A sequence's unallocated cached values are lost if the instance shuts down.

B. A sequence number that was allocated can be rolled back if a transaction fails.

C. A sequence can only be dropped by a DBA.

D. A sequence can issue duplicate values.

E. Sequences can always have gaps.

F. Two or more tables cannot have keys generated from the same sequence.

Which two are true about savepoints? (Choose two.)

A. After issuing a savepoint, you can roll back to the savepoint name within the current transaction.

B. They make uncommitted updates visible to sessions owned by other users.

C. You can commit updates done between two savepoints without committing other updates in the current transaction.

D. A ROLLBACK TO SAVEPOINT command issued before the start of a transaction results in an error.

E. They make uncommitted updates visible to other sessions owned by the same user.

F. After issuing a savepoint, you cannot roll back the complete transaction.

View the Exhibit and examine the structure of CUSTOMERS table.

Using the CUSTOMERS table, you need to generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not been entered should have the message "Not Available" displayed.

Which SQL statement would produce the required result?

A. SELECT NVL (TO CHAR(cust_credit_limit * .15), 'Not Available') "NEW CREDIT" FROM customers;

B. SELECT TO_CHAR (NVL(cust_credit_limit * .15), 'Not Available') "NEW CREDIT" FROM customers;

C. SELECT NVL(cust_credit_limit * .15), 'Not Available') "NEW CREDIT" FROM customers;

D. SELECT NVL(cust_credit_limit), 'Not Available') "NEW CREDIT" FROM customers;