Question 86

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?
  • Question 87

    Examine this command:
    CREATE UNDO TABLESPACE undotbs01
    DATAFILE `undotbs_01.dbf'
    SIZE 100M
    AUTOEXTEND ON;
    Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)
  • Question 88

    In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.
    Examine this command:
    SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
    Which segment or segments, if any, are created as a result of executing the command?
  • Question 89

    Which two statements are true?
  • Question 90

    Which two statements are true regarding a SAVEPOINT? (Choose two.)