1Z0-082 Exam Question 21
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?
A PFILE is also available. You execute this command:
ALTER SYSTEM SET DB_CACHE_SIZE=100K;
Where Is the value changed?
1Z0-082 Exam Question 22
Examine the description of the BOOKS_TRANSACTIONS table:


1Z0-082 Exam Question 23
Which two statements are true about UNDO and REDO? (Choose two.)
1Z0-082 Exam Question 24
The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.
Each database has a tnsnames.ora file defining DALLAS_DB as a service name.
Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING 'dallas_db'; How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?
Each database has a tnsnames.ora file defining DALLAS_DB as a service name.
Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING 'dallas_db'; How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?
1Z0-082 Exam Question 25
Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)
