Loading...
Archive for May, 2008
  1. 1.Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec.
    You executed the following command to enable retention guarantee:
    ALTER TABLESPACE undotbs1 RETENTION GUARANTEE
    What efeect would this statement have on the database?
    A - The extents in undo tablespace retain data until the next full database backup.
    B - The extents containing committed data in the undo tablespace are never overwritten.
    C - The extents which no longer contain uncommitted data in the undo tablespace
    are not overwritten for at least 15 minutes.
    D - The extents containing committed data in the undo tablespace are not overwritten
    until the instance is shut down.

    More…

    Popularity: 36% [?]

  2. 1.Which three statements are true regarding the logical structure of the Oracle database?(choose three)
    A - Each segment contains one or more extents
    B - Mutiple tablespaces can share single datafile
    C - A data block is a smallest unit of I/O for data files.
    D - it is possible to have tablespaces of different blocks size in a database
    E - Each data block in the database always corresponds to one OS block.
    (Answer:A,C,D)

      More…

    Popularity: 33% [?]

  3. 1.What are the consequences of executing the SHUTDOWN ABORT command(Choose tow)

    A - The database files are synchronized.
    B - Uncommitted changes are no rolled back.
    C - The database is closed,but the instance is still started.
    D - Database buffers and redo buffers are not written to the disk.
    E - The data base undergose automatic media recovery during the next startup.

      More…

    Popularity: 36% [?]

  4. I found this web site scribd  by accident.There are lots of books on this site.Here’s another similar site slideshare. Have fun!

    Popularity: 35% [?]

  5. if you get ORA-00600 or the following error message on your Oracle standby database:

    Fri Mar 09 10:57:49 2007
    Errors in file c:\oracle\admin92\crm\bdump\crmsb_mrp0_524.trc:
    ORA-00600: internal error code, arguments: [3020], [356515961], [1], [4606], [2], [16], [], []
    ORA-10567: Redo is inconsistent with data block (file# 85, block# 121)
    ORA-10564: tablespace UNDOTBS2
    ORA-01110: data file 85: ‘K:\ORADATA\CRM\UNDOTBS02_1.DBF’
    ORA-10560: block type ‘KTU SMU HEADER BLOCK’

    Or your undo tablespace has grown to unmanageable size (~ 35 Gbytes), you may want to recreate unto tablespace. Here is how:
    More…

    Popularity: 49% [?]

Powered by ExtJS Theme flavored Wordpress.