← Back to exam page

1z0-082 – Oracle Database Administration I

Loading demo links...

Showing 4–6 of 10 questions

Question 4

Which three statements are true about table data storage in an Oracle Database? (Choose three.)

Select all that apply, then click Submit answer.

  • ○

    Data block headers contain their own Data Block Address (DBA)
  • ○

    A table row piece can be chained across several database blocks
  • ○

    Multiple row pieces from the same row may be stored in different database blocks
  • ○

    Multiple row pieces from the same row may be stored in the same block
  • ○

    Data block free space is always contiguous in the middle of the block
  • ○

    Index block free space is always contiguous in the middle of the block
Question 5

You execute this command:

During the export operation, you detach from the job by using CTRL+C and then execute this command:

Export> STOP_JOB=immediate

Are you sure you wish to stop the job ([yes]/no): yes

Which two statements are true about the job? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    You can no longer monitor it
  • ○

    You can reattach to it and monitor it
  • ○

    It is paused and can be resumed
  • ○

    It continues to run in the background
  • ○

    It terminates
Question 6

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.

The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

Select an option, then click Submit answer.

  • ○

    Dynamic service registration cannot be used for this database instance
  • ○

    The LREG process registers services dynamically with the LISTENER_1 listener
  • ○

    LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
  • ○

    There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
  • ○

    The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration