← Back to exam page

1z0-082 – Oracle Database Administration I

Loading demo links...

Showing 7–9 of 10 questions

Question 7

A script abc.sql must be executed to perform a job.

A database user HR, who is defined in this database, executes this command:

$ sqlplus hr/hr@orcl @abc.sql

What will happen upon execution?

Select an option, then click Submit answer.

  • ○

    The command succeeds and HR will be connected to the orcl and abc.sql databases
  • ○

    The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed
  • ○

    The command fails because the script must refer to the full path name
  • ○

    The command fails and reports an error because @ is used twice
Question 8

In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:

1. A size of 100 MB

2. AUTOEXTEND is off

3. UNDO_RETENTION is set to 15 minutes

4. It has RETENTION GUARANTEE

UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.

What will happen when the next update is attempted by any transaction?

Select an option, then click Submit answer.

  • ○

    It succeeds and the generated undo is stored in SYSTEM.
  • ○

    It fails and returns the error message “ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'”.
  • ○

    It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
  • ○

    It succeeds and the generated undo is stored in SYSAUX.
  • ○

    It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.
Question 9

You want to use table compression suitable for OLTP that will:

1. Compress rows for all DML statements on that table 2. Minimize the overheads associated with compression Which compression option is best suited for this?

Select an option, then click Submit answer.

  • ○

    COLUMN STORE COMPRESS FOR QUERY LOW
  • ○

    ROW STORE COMPRESS BASIC
  • ○

    COLUMN STORE COMPRESS FOR ARCHIVE LOW
  • ○

    COLUMN STORE COMPRESS FOR ARCHIVE HIGH
  • ○

    ROW STORE COMPRESS ADVANCED