Scribd Logo
Upload

Welcome to Scribd!

  • 20 views

    It6203a Prelim Lab Quiz 1

    Uploaded by

    Yacob Mort
    The document contains questions and answers about Oracle database administration topics like ASM, RMAN backups, initialization parameters, and database writer processes. ASM performs mirroring at the database object level. The four commands to enable ARCHIVELOG mode in order are: ALTER DATABASE ARCHIVELOG; ALTER DATABASE OPEN RESETLOGS; ALTER SYSTEM ARCHIVE LOG START; ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='location'. There is no effect on the ASM instance when a connected RDBMS instance fails.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    It6203a Prelim Lab Quiz 1

    Uploaded by

    Yacob Mort
    20 views2 pages
    The document contains questions and answers about Oracle database administration topics like ASM, RMAN backups, initialization parameters, and database writer processes. ASM performs mirroring at the database object level. The four commands to enable ARCHIVELOG mode in order are: ALTER DATABASE ARCHIVELOG; ALTER DATABASE OPEN RESETLOGS; ALTER SYSTEM ARCHIVE LOG START; ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='location'. There is no effect on the ASM instance when a connected RDBMS instance fails.

    Original Title

    IT6203A PRELIM LAB QUIZ 1

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains questions and answers about Oracle database administration topics like ASM, RMAN backups, initialization parameters, and database writer processes. ASM performs mirroring at the database object level. The four commands to enable ARCHIVELOG mode in order are: ALTER DATABASE ARCHIVELOG; ALTER DATABASE OPEN RESETLOGS; ALTER SYSTEM ARCHIVE LOG START; ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='location'. There is no effect on the ASM instance when a connected RDBMS instance fails.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    20 views2 pages

    It6203a Prelim Lab Quiz 1

    Uploaded by

    Yacob Mort
    The document contains questions and answers about Oracle database administration topics like ASM, RMAN backups, initialization parameters, and database writer processes. ASM performs mirroring at the database object level. The four commands to enable ARCHIVELOG mode in order are: ALTER DATABASE ARCHIVELOG; ALTER DATABASE OPEN RESETLOGS; ALTER SYSTEM ARCHIVE LOG START; ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='location'. There is no effect on the ASM instance when a connected RDBMS instance fails.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 2

    What is the maximum number of database writer processes (DBWn) in an Oracle database

    instance?
    20

    At which level does ASM perform mirroring?


    At the database object level
    Which of the following initialization parameters is not valid?
    LOG_ARCHIVE_DEST = ‘SERVICE=RMTDB99’
    Choose the four best commands from the following list that you would use to enable
    ARCHIVELOG mode, and put them in the correct order:
    9, 1, 3, 8
    What happens to the state of an ASM instance when a connected RDBMS instance fails?
    There is no effect on the ASM instance.
    To enable password encryption for a specific backup, use the ____ command.
    set encryption
    Which of the following statement is not true regarding database backups?
    As of Oracle Database 11g, RMAN supports only online backups.
    If you specify the initialization parameter DB_RECOVERY_FILE_DEST, what other initialization
    parameter must be set?
    DB_RECOVERY_FILE_DEST_SIZE
    If you want to use two-way mirroring (normal redundancy) for a new disk group, how many
    failure groups do you need?
    Two failure groups.
    Which of the following background processes exist in both an ASM instance and an RDBMS
    instance, and also support ASM disk groups
    RBAL
    If you are recovering one or more tablespaces or the entire database from backups that
    have different passwords, you can conveniently specify all the passwords at once with
    set decryption
    If you do not use a recovery catalog, what data dictionary or dynamic performance views
    must you query to retrieve RMAN backup information?
    The V$ views on each target such as V$BACKUP_SET and V$DATAFILE_COPY
    Which of the following are not RMAN standalone commands?
    ALLOCATE CHANNEL
    You run the following command to create a whole database backup:
    RMAN< backup as copy database spfile plus archivelog delete input;
    What does the DELETE INPUT clause do?
    After the backup completes, RMAN deletes the archived log files from the flash recovery
    area and any other archived log file destinations.

    What is the value for INSTANCE_TYPE in the init.ora file or SPFILE for an ASM instance?
    ASM
    What are the default characteristics of an ASM file created with no options?
    The ASM object is striped but not mirrored.
    Which of the following parameters are required for an ASM instance?
    INSTANCE_TYPE
    You have just received a pager alert indicating that the flash recovery area is below 3
    percent free space. Which view and column can you query for a possible corrective action
    for this space condition?
    DBA_OUTSTANDING_ALERTS, SUGGESTED_ACTION
    What is the difference between coarse striping and fine striping for files in a disk group?
    Coarse striping spreads files in units of 1MB each across all disks, and fine striping spreads
    files in units of 128KB.
    Which of the following is the default substitution variable for the FORMAT clause of the
    BACKUP command?
    %U

    You might also like