053最新题库

1.you configured the fast recovery area for one of your database but it is now running out of space.
which two could make space available in the flash recover area?
A.change the RMAN archived log deletion policy.
B.use os commands to remove files from the fast recovery area.
C.use the rman crosscheck command to reclaim the archived log space.
D.reduce the rman retention policy window or day count.
Answer：BC（不确定）

2. Which two statements are true about compressed backups in RMAN?
   A) The compression algorithm is automatically selected by RAMN.
   B) Binary compression adds some performance overhead when taking backups.
   C) Media manager compression should be enabled when backing up to tape.
   D) Compressed backups can only be written if using a media manager.
   Answer：BC

3. Identify two scenarios in which the RMAN CROSSCHECK command is useful
   A)To check that the obsolete backups are deleted from the repository records and from the disk
   B)To synchronize the actual files on disk or in the media management catalog with the RMAN repository for which
   the backup was not taken using RMAN
   C) To update the RMAN repository if you delete archived redo logs with operating system commands
   D)To update outdated information about backups that disappeared from disk or tape or became corrupted and
   inaccessible
   Answer：CD

4. Your database is running in ARCHIVELOG mode . One of the data files USERDATA01.DBF in the USER Tablespace is damaged and you need to recover the file until the point of failure.The Backup for the data file is available.
   Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?
   A) The latest backup of all the files in the USERS tablespace
   B) Temporary files of temporary tablespace
   C) Redo logs
   D) Control file
   E) The latest backup of only the damaged data file
   Answer：CDE

5. Which two conditions must be met before you can create an Recovery Manager (RMAN)Virtual Private Catalog(vpc)?
   A)A base catalog must exist.
   B)A target database is registered in the recovery catalog
   C) The recovery catalog owner role must be granted to the user who will own the vpc
   D) The recovery catalog must be empty

E)The database containing the catalog must use a Flash Recovery Area(FRA)
Answer：AC

6. Identify three channel settings that can be performed using the CONEIGURE CHANNEL or ALLOCATE CHANNEL commands in RMAN
   A)specifying the size of backup sets and backup pieces
   B) specifying the size of proxy copies
   C)limiting the input/output(1/0) bandwidth consumption
   D) specifying vendor-specific information for a media manager
   E)specifying the size of image copies
   F) specifying the parallelism for backup and restore operations
   Answer：CDF

7. One of your databases has resumable space allocation enabled
   Which four conditions will suspend a session performing DML in that database instance
   Such that they can resume later rether than throw an error?
   A)A transaction causes an index segment to reach maximum extents which is set to 1000
   B) A transaction reaches the session users tablespace space quota
   C)A transaction causes a table segment to reach maximum extents which is set to 750
   D) Total undo space for a session exceeds the resource manager limit
   E)A query can not build a read consistent image of a block updated by a transaction that is already committed
   F) A query can not build a read consistent image of a block updated by a transaction that is not yetcommitted
   G)A transaction causes a tablespace to run out of space and autoextend is not enabled

Answer：ABCG

9.Which three are true about the recycle bin in Oracle 11g
A) Space occupied by objects in the recycle bin count agaInst the quota of the schema owner
B) More than one table originally called HR. EMPLOYEES may reside in the recycle bin
C) A dropped index may be flashed back from the recycle bin
D) Objects in the recycle bin are stored in the same tablespace as they were before they were dropped
E)A dropped table may always be flashed back from the recycle bin
F) Objects in the recycle bin are stored in the reMe tablespace of the schema owner
answer: BCD

10. Which two are true about configuring the fast recovery area?
    A)Archive log destinations must be specified using LOG_AECHIVE_DEST_n parameters.
    b)DB_FLASHBACK_RETETION_TARGET must be set if defining a retention policy.
    c)DB_RECOVERY_FILE_DEST must be set in order to use the FLASHBACK DATABASE command.
    d)USE_DB_RECOVERY_FILE_DEST must be explicitly set to LOG_ARCHIVE_DEST_10.
    e) DB_RECOVERY_FILE_DEST_SIZE must be set if DB_RECOVERY_FILE_DEST is set.
    ANSWER: CE（不确定）

11. One of your databases is in archivelog mode and registered in an RMAN catalog
    Which two can affect the RMAN recovery window?
    A)the value of control file record keep time
    B)the frequency of catalog resynchronization
    C)using the fast recovery area
    D)configuring backup optimization
    E)using backup redundancy

ANSWER: DE（不确定）

12. In one of your databases
    You use Recovery Manager( RMAN) to perform incremental backups
    You have backups for the last 30 days
    The database is in NOARCHIVETOG mode
    One of its data files is corrupt
    The online redo log files are lost due to media failure.
    The instance is shut down
    Examine this list of steps
    1)Start up NOMOUNT the database

2. Mount the database.
3. Restore the control file
4. Restore the database
5. Open the database RESETLOGS
   6)Recover the database NOREDO
   7)Recover the database
   8)Start up MOUNT the database
   Which is the list of required steps in the correct order to recover the database?
   A)8,3,2,4,6,5
   B)8,4,6,5
   C)1,3,2,4,6,5
   D)1,2,3,4,6,5
   o8,4,7,5

ANSWER: C

13. Identify the three persistent configuration settings for target database that can be set for the backups by using RMAN
    A) multiple backup device types for single backup

B）default destinations for backups

C) default backup device type

E) default section size for backups IFA
Answer:ABC（不确定）

14. Identify two scenarios in which the RMAN crosscheck command is useful.
    A) To check that the obsolete backups are deleted from the repository records and from the disk.
    B) To synchronize the actual files on disk or in the media management catalog with the RMAN repository for which
    the backup was not taken using RMAN.
    C） To update the RMAN repository if you delete archived redo logs with operation system commands.
    D) To update outdated information about backups that disappeared from disk or tape or became conrupted and
    inaccessible.
    Answer:CD

15. The database is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform
    user-managed backup for the data files of the HR DATA tablespace
    To accomplish the task, you issued this command
    SOL> ALTER TABLESPACE hr data BEGIN BACKUP:
    Which two statements are true in this scenario?
    O A)No transaction on the tablespace is allowed but you can perform queries
    O B)The tablespace will automatically come out of backup mode when the file copy is complete.
    O C)The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode
    O D)The database writes the before image of an entire block to the redo stream before modifying a block for the first
    time.
    Answer:CD

16. View the Exhibit and examine the output and commands executed on the ALTB table.
    Why does the number of blocks for the table remain the same after the shrink operation?
    A) Because the row IDs remain the same foe all rows during the shrink operation
    B) Because the table did not contain migrated or chained rows
    C) Because the progress of the shrink operation is not saved in the bitmap blocks of the table
    D) Because the high-water mark(HWM) did not move due to the COMPACT option that is used in the shrink
    operation
    Answer:D

17. Using Recovery Manager(RMAN),you take image copies of a production database’s data files.
    You then roll them forward at regular intervals.
    An instance startup fails to open the database due to an error opening the USERS tablespace data file.
    You must recover the data file using the image copy.
    Examine this list of steps:

1. Mount the database.

2. Take the data file offline.

3. Bring the tablespace online.

4. Use the RMAN SWITCH TO command to switch to the image copy.

5. Recover the datafile.

6. Open the database.

7. Use the RMAN RESTORE TO command to switch to the image copy.
   What is the minimum sequence of steps in the correct correct sequence?
   A) 1,2,7,5,3,6
   B) 1,2,4,6,3
   C) 2,6,4,5,3
   D) 2,7,5,3,6
   E) 1,2,6,4,5,3
   Answer：C（不确定）

---

作者：byrgzs
来源：CSDN
原文：https://blog.csdn.net/byrgzs/article/details/82907613?utm_source=copy
版权声明：本文为博主原创文章，转载请附上博文链接！@TOC

io/flowchart.js/