Backup and Recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Backup and Recovery

  1. #1
    Join Date
    Jun 2001
    Posts
    14
    Hi
    I am preparing for Oracle 8i backup and recovery and I have with ILT and STS. Actually I am working full time in fiance field. I have taken a week off to prepare for this examination.
    i will appreciate somebody can give me some suggestions. Please
    Thanks


  2. #2
    Join Date
    Jan 2002
    Posts
    83

    Talking study study

    just study all modules in the ILT and also undertans all questions from STS. Do not stop practising STS until u get 100% and also understand the explanation provided by the STS with the answers. Study RMAN properly.

    ICEMAN

  3. #3
    Join Date
    Dec 2001
    Posts
    26

    Here are few exam questions !!!!

    Hi zenith..

    Here are few very imp questions....

    1. What kind of destination can a DBA choose when specifying the LOG_ARCHIVE_DEST_n parameter?
    A. net8 listener name
    B. only a local directory
    C. only a net8 alias for a remote database
    D. a local directory or a net8 alias for a remote database

    2. Which technique does Oracle use to perform full backup of data files?
    A. The server process reads and backs up the entire file.
    B. The server process reads the entire file and skips blocks that have never been used.
    C. The server process reads the entire file and skips blocks assigned to temporary segments.
    D. The server process reads the entire file and skips blocks currently not being used.
    E. The server process reads the entire file and skips blocks unchanged from last backup.

    3. What is the difference between using NOLOGGING operation in a single database environment and a standby database environment.
    A. No difference
    B. NOLOGGING operation not available in release 8.1
    C. The affected data files need to be copied from primary to standby server.
    D. NOLOGGING operation can be used on standby but not on primary database.

    Question: Level 1 backup is taken on the first of each
    month. Level 2 backup is taken every Sunday. Level 3
    backup is taken daily. If database gets corrupted on the
    2nd Wednesday of the month and is lost, which scenario will
    restore the database completely?
    A) Level 2 & Level 3 backups should be used.
    B) Level 1 & Level 3 backups should be used.
    C) A baseline backup (Level 0) is missing so nothing can
    be recovered.
    D) Level 1, Level 2, & Level 3 backups should be used.

    Question: Which statement about RMAN w/ a database in
    NOARCHIVELOG mode is true?
    A) RMAN requires a recovery catalog.
    B) RMAN supports multi-level incremental backups.
    C) RMAN is compatible w/ Enterprise Backup utility.
    D) RMAN only works in conjunction w/ a tape subsystem.

    Question: When using RMAN w/out a catalog, the connection
    to the target database ________________.
    A) Must be local.
    B) Must be remote.
    C) Can be either local or remote.
    D) Must be specified using a Net8 service name.

    Question: Which statement about allocation of processes to
    RMAN is true?
    A) When enabling I/O slaves, ensure that the shared pool
    is sized appropriately.
    B) I/O slaves can only be used if the operating system
    supports asynchronized I/O.
    C) Enabling I/O slaves can be controlled by setting
    USE_IO_SLAVES appropriately.
    D) Setting BACKUP_TAPE_IO_SLAVES = true will enable a
    dedicated slave to write a tape device.

    Question: Which TWO types of data files can be considered
    non-essential?
    A) Datafiles belong to a lost tablespace.
    B) Datafiles belong to an index tablespace.
    C) Datafiles belong to a system tablespace.
    D) Datafiles belong to a temporary tablespace.
    E) Datafiles belong to an application data tablespaces.
    F) Datafiles belong to a rollback segment tablespace.

    Question: What is the recommended initial size of a
    tablespace containing RMAN recovery catalog?
    A) 1M
    B) 20M
    C) 100M
    D) 10% of the size of the target database.

    Question: What are the TWO purposes of using RMAN command
    CATALOG?
    A) Update recovery catalog about rollback segment creation.
    B) Update recovery catalog about files created before RMAN.
    C) Update recovery catalog about operating system backups.
    D) Update recovery catalog about files created before
    Oracle 8.
    E) Update recovery catalog about files belong to a clone
    database.

    Question: Work is done by RMAN through ___________.
    A) Pl/SQL packages
    B) external procedures
    C) operating system scripts
    D) operating system commands.

    Question: When the status of a tablespace moves from
    read-only to read-write, which TWO events occur?
    A) Redo log switch must take place.
    B) Normal checkpoint on the files now occur.
    C) Oracle automatically marks the file for backup.
    D) All objects in tablespace are checked for integrity.
    E) DBWn process writes to the data files of the tablespace.

    Question: There was a question about cancel-based recovery asking you basically:
    how can you stop a cancel-based recovery?
    A. Recovery can be stopped by entering cancel at the recovery prompt
    B. Recovery can be stopped by pressing ctrl-C at the recovery prompt
    .... (I forgot the rest?)


    Best of Luck....

    Justin !!!!!

  4. #4
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    Hi ,
    can any one check these answers .

    1. What kind of destination can a DBA choose when specifying the LOG_ARCHIVE_DEST_n parameter?
    A. net8 listener name
    B. only a local directory
    C. only a net8 alias for a remote database
    D. a local directory or a net8 alias for a remote database

    Ans D

    Question: Which TWO types of data files can be considered
    non-essential?
    A) Datafiles belong to a lost tablespace.
    B) Datafiles belong to an index tablespace.
    C) Datafiles belong to a system tablespace.
    D) Datafiles belong to a temporary tablespace.
    E) Datafiles belong to an application data tablespaces.
    F) Datafiles belong to a rollback segment tablespace.

    D & F

    Question: What is the recommended initial size of a
    tablespace containing RMAN recovery catalog?
    A) 1M
    B) 20M
    C) 100M
    D) 10% of the size of the target database.

    20M

    Question: Work is done by RMAN through ___________.
    A) Pl/SQL packages
    B) external procedures
    C) operating system scripts
    D) operating system commands.

    PL/SQL Packages and Operating System Commands


    also anyone can put their views on the other questions .

    thanks
    siva prakash
    DBA

  5. #5
    Join Date
    Jun 2000
    Location
    GA
    Posts
    43
    Question: Work is done by RMAN through ___________.
    A) Pl/SQL packages
    B) external procedures
    C) operating system scripts
    D) operating system commands

    I think this should be Pl/SQL packages
    OCP 8i DBA
    I'm still learning

  6. #6
    Join Date
    Jan 2001
    Posts
    3,131
    Sure don't bother to study, just memorize the answers. What the heck B&R isn't that important anyway right? Jeez!

    Study all the chapters in the ILT, after you complete each chapter do ALL the STS questions for that chapter. When you get a question wrong make sure you "UNDERSTAND" why and move on. This is the way I did it, way back in 2000. Don't just mindlessly memorize questions.

    Ps What exactly is the "fiance field" do you arrange marriages?

    MH
    I remember when this place was cool.

  7. #7
    Join Date
    May 2002
    Posts
    2,645
    I think it's a lot like writing $100 instead of $1000. No big deal, extra letter, extra zero here and there.

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Originally posted by prakashs43
    Hi ,
    Question: Which TWO types of data files can be considered
    non-essential?
    A) Datafiles belong to a lost tablespace.
    B) Datafiles belong to an index tablespace.
    C) Datafiles belong to a system tablespace.
    D) Datafiles belong to a temporary tablespace.
    E) Datafiles belong to an application data tablespaces.
    F) Datafiles belong to a rollback segment tablespace.

    D & F
    ROLLBACK is ESSENTIAL!

  9. #9
    Join Date
    Oct 2001
    Location
    Toronto, Canada
    Posts
    236
    B & D
    Leo
    Oracle 8i OCP DBA
    Toronto, Canada

  10. #10
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Yeah ogbologbo, remembering back to my B&R exam, I got that question.
    OCP 8i, 9i DBA
    Brisbane Australia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width