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?
  • 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?
  • 1Z0-082 Exam Question 25

    Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)