Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（） A、 Database datafilesB、 Control filesC、 Archived redo logsD、 Online redo logsE、 Flashback logs

题目

Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（） 

  • A、 Database datafiles
  • B、 Control files
  • C、 Archived redo logs
  • D、 Online redo logs
  • E、 Flashback logs
相似考题

1.You issued the following RMAN command to back up the database:Which two statements are true regarding the backup performed?()A. Archived redo log files are backed up along with data files.B. Only data files are backed up and a restore point named FY06Q4 is created.C. Archived log files are backed up along with data files, and the archived log files are deleted.D. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.

2.A user copied files from a CD and now the files can only be opened as read－only. Which of the following utilities can be used to allow the user the ability to edit the files?()A.EDITB.CHMODC.ATTRIBD.CONVERT

3.A system administrator needs to backup datavg which contains a database that pre-allocates files by padding them with nulls, similar to treating them as sparse files. In order to effectively backup and be able to restore the datavg files, which backup method should be used?（）A.savevgB.tarC.cpioD.mksysb

4.Identify two situations in which you can use Data Recovery Advisor for recovery. ()(Choose two.)A. The user has dropped an important table that needs to be recovered.B. The database files are corrupted when the database is open.C. You are not able to start up the database instance because the required database files are missing.D. The archived log files are missing for which backup is not available.

更多“Which files willQ”相关问题

  • 第1题：

    A user states that when the user copies files from ‘My Documents’ to a network share, the files are no longer available locally. Which of the following BEST describes the reason the files are no longer visible?（）

    • A、The user copied to a read-only folder share.
    • B、The user changed the attributes of the files.
    • C、The user copied the files from the local My Documents folder.
    • D、The user moved instead of copied the files.

    正确答案:D

  • 第2题：

    Which program finds only files that are in your PATH？（）


    正确答案:/USR/BINyWHICH

  • 第3题：

    Which of the following is the default location for Fonts in Windows 7?（）

    • A、C:/System Files/Fonts
    • B、C:/Windows/Fonts
    • C、C:/Windows/System Files/Fonts
    • D、C:/System/Fonts

    正确答案:B

  • 第4题：

    Which command restores files from a volume group backup on a specified media?（）

    • A、mksysb-r
    • B、savevg-r
    • C、restorevg-r
    • D、restorevg files

    正确答案:A

  • 第5题：

    When performing an incomplete recover of the whole database， which data files must you restore？ （）

    • A、Only the damaged or lost data files.
    • B、All of the data files of the database.
    • C、Only the data files belonging to the SYSTEM tablespace.
    • D、The data files belonging to the SYSTEM tablespace and the damaged or lost data files.

    正确答案:B

  • 第6题：

    What is the output of this command?（）

    • A、A list of files that require a backup within 3 days
    • B、A list of files requiring more than 3 days of archivelogs to apply
    • C、A list of files that RMAN recommends be backed up only once in every three days, based on low volatility
    • D、A list of files for which a backup as already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them

    正确答案:B

  • 第7题：

    单选题
    Before performing a mksysb system backup, which of the following procedures should a system administrator perform to avoid backing up certain user files?（）
    A

    Add the list of files to /etc/exclude.rootvg.

    B

    Modify the image.data file and add the files to be excluded form the backup.

    C

    Modify the bosinst.data file and specify which files are to be excluded from the backup.

    D

    Specify the files to be excluded on the command line when executing the mksysb command.


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    A system administrator needs to backup datavg which contains a database that pre-allocates files by padding them with nulls, similar to treating them as sparse files. In order to effectively backup and be able to restore the datavg files, which backup method should be used?（）
    A

    savevg

    B

    tar

    C

    cpio

    D

    mksysb


    正确答案： D
    解析： 暂无解析

  • 第9题：

    多选题
    The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files？ （）
    A

    data files

    B

    backup sets

    C

    control files

    D

    archived redo log files


    正确答案： D,A
    解析： 暂无解析

  • 第10题：

    多选题
    Which three statements are true about the stages of database startup？（）
    A

    Data files and redo log files can be renamed at the MOUNT stage.

    B

    Control files are read at the OPEN stage for the location of data files.

    C

    Control files are required to bring the database to the NOMOUNT stage.

    D

    Data files and redo log files are made available to users at the OPEN stage.

    E

    Data files and online redo log files are checked for consistency while opening the database


    正确答案： A,B
    解析： 暂无解析

  • 第11题：

    单选题
    You are operating your database in NOARCHIVELOG mode. Your most recent backup includes a copy of all of the data files and the control files taken when the current log sequence number was 45. You experience disk failure on the drive on which your SYSTEM tablespace data files are stored. At the time of the failure， the current log sequence number is 98. Which files should you restore to recover from the loss of the SYSTEM tablespace data files？（）
    A

    Only the data files.

    B

    All of the data files and the control files.

    C

    Only the data files belonging to the SYSTEM tablespace.

    D

    Only the data files belonging to the SYSTEM tablespace and the control files.


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    Which of the following locations would hold 32-bit application files in Windows Vista 64-bit?（）
    A

    C:/Program Files/

    B

    C:/Program Files (x86)/

    C

    C:/Program Files 32/

    D

    C:/Program files 32-bit/


    正确答案： B
    解析： 暂无解析

  • 第13题：

    A user copied files from a CD and now the files can only be opened as read-only. Which of the following utilities can be used to allow the user the ability to edit the files?（）

    • A、EDIT
    • B、CHMOD
    • C、ATTRIB
    • D、CONVERT

    正确答案:C

  • 第14题：

    Which of the following commands scans and verifies system protected files?（）

    • A、VERIFY
    • B、SFC
    • C、CHKDSK
    • D、CHKNTFS

    正确答案:B

  • 第15题：

    Which of the following protocols uses UDP to transfer files?（）

    • A、FTP
    • B、SFTP
    • C、SMTP
    • D、TFTP

    正确答案:D

  • 第16题：

    You executed the following command in the Recovery Manager （RMAN）：   RMAN> REPORT NEED BACKUP days 3；   What is the output of this command？（）  

    • A、 A list of files that require a backup within 3 days
    • B、 A list of files requiring more than 3 days of archivelogs to apply
    • C、 A list of files that RMAN recommends be backed up only once in every three days，based on low volatility
    • D、 A list of files for which a backup as already been performed in the last three days and which is  required to be backed up again based on the high number of transactions performed on them

    正确答案:B

  • 第17题：

    Identify two situations in which you can use Data Recovery Advisor for recovery.（） 

    • A、 The user has dropped an important table that needs to be recovered.
    • B、 The database files are corrupted when the database is open.
    • C、 You are not able to start up the database instance because the required database files are missing.
    • D、 The archived log files are missing for which backup is not available.

    正确答案:B,C

  • 第18题：

    The loss of which two types of files may require a recovery with the RESETLOGS option？（）

    • A、 control files
    • B、 password file
    • C、 archived log files
    • D、 system-critical data files for which all the redo entries are present
    • E、 non-system-critical data files for which all the redo entries are present

    正确答案:A,C

  • 第19题：

    多选题
    Identify two situations in which you can use Data Recovery Advisor for recovery.（）
    A

    The user has dropped an important table that needs to be recovered.

    B

    The database files are corrupted when the database is open.

    C

    You are not able to start up the database instance because the required database files are missing.

    D

    The archived log files are missing for which backup is not available.


    正确答案： C,B
    解析： 暂无解析

  • 第20题：

    单选题
    When performing an incomplete recover of the whole database， which data files must you restore？ （）
    A

    Only the damaged or lost data files.

    B

    All of the data files of the database.

    C

    Only the data files belonging to the SYSTEM tablespace.

    D

    The data files belonging to the SYSTEM tablespace and the damaged or lost data files.


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    What is the output of this command?（）
    A

    A list of files that require a backup within 3 days

    B

    A list of files requiring more than 3 days of archivelogs to apply

    C

    A list of files that RMAN recommends be backed up only once in every three days, based on low volatility

    D

    A list of files for which a backup as already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them


    正确答案： C
    解析： 暂无解析

  • 第22题：

    多选题
    The loss of which two types of files may require a recovery with the RESETLOGS option？（）
    A

    control files

    B

    password file

    C

    archived log files

    D

    system-critical data files for which all the redo entries are present

    E

    non-system-critical data files for which all the redo entries are present


    正确答案： B,C
    解析： 暂无解析

  • 第23题：

    单选题
    Which files must be synchronized in order for a database to start？（）
    A

    temp files

    B

    online data files

    C

    offline data files

    D

    read only data files


    正确答案： B
    解析： 暂无解析

  • 第24题：

    填空题
    Which program finds only files that are in your PATH？（）

    正确答案： /USR/BINyWHICH
    解析： 暂无解析

相关内容