Complete 1z0-082 Oracle Materials

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.)

Your database instance is started with an SPFILE.

A PFILE is also available. You execute this command:

ALTER SYSTEM SET DB_CACHE_SIZE=100K;

Where Is the value changed?

Examine the description of the SALES1 table:

SALES2 is a table with the same description as SALES1.

Some sales data is duplicated in both tables.

You want to display the rows from the SALES1 table which are not present in the SALES2 table.

Which set operator generates the required output?

Which three statements are true about Oracle synonyms? (Choose three.)