1Z0-082 Exam Question 71
Which two functions are performed by a listener?
1Z0-082 Exam Question 72
Your database instance is started with a PFILE.
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?
1Z0-082 Exam Question 73
Examine this command and some partial output:

Why does the DB01.abc.com service show unknown status?

Why does the DB01.abc.com service show unknown status?
1Z0-082 Exam Question 74
Which three statements are true about inner and outer joins? (Choose three.)
1Z0-082 Exam Question 75
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?

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?
