1z0-082 Exam Dumps : Oracle Database Administration I

Examine the description of the customers table:

You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit Is below 1000.

Examine this partial query:

SELECT cust_last_name, cust_credit_limit FROM customers

Which two where conditions give the required result?

A)

B)

C)

D)

E)

In one of your databases, you create a user, HR, and then execute this command:

GRANT CREATE SESSION TO hr WITH ADMIN OPTION;

Which three actions can HR perform? (Choose three.)

Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)