You performed an incomplete recovery on your Oracle Database 10g database using the following command：   SQL> RECOVER DATABASE  2 UNTIL TIME ’2004-08-05：12：10：03’ 3 USING BACKUP CONTROLFILE；  In which situation would the above recovery be required？（）A、 A

题目

You performed an incomplete recovery on your Oracle Database 10g database using the following command：   SQL> RECOVER DATABASE  2 UNTIL TIME ’2004-08-05：12：10：03’ 3 USING BACKUP CONTROLFILE；  In which situation would the above recovery be required？（）

  • A、 A user table was lost at the specified time.
  • B、 A redo log file was lost at the specified time.
  • C、 The backup control file is on a faster disk than the current one.
  • D、 The current control file has a different path compared with the intended time of recovery.
  • E、 The current control file does not match the physical structure of the database at the intended time of recovery.
相似考题

1.You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN >BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）A. Corrupted blocks, if any, are repaired.B. Checks are performed for physical corruptions.C. Checks are performed for logical corruptions.D. Checks are performed to confirm whether all database files exist in correct locationsE. Backup sets containing both data files and archive logs are created.

2.Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）A、You can perform online whole database backups.B、You can performofflinewhole database backups.C、You cannot perform schema-level export/import operations.D、You can perform the backup of only the SYSTEM tablespace when the database is open.

3.You are managing an Oracle Database 11g database with the following backup strategy：1） On Sunday， an incremental level 0 tape backup is performed.2） Monday through Saturday， a cumulative incremental level 1 tape backup is performed. Which twostatements are true regarding the backups performed（）A、The backup performed in step 1 backs up all blocks that have ever been in use in the database.B、The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup.C、The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup.D、The backup performed in step 2 backs up all blocks that have changed since the most recent incrementalbackup at level 1

4.Which two statements are correct regarding the Flashback Versions Query feature？（）A、 You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.B、 You can use this feature to identify the versions of V$ views.C、 You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.D、 You can use this feature for a table only if row movement is enabled for the table.E、 You can use this feature to identify the versions of external and fixed tables.

参考答案和解析
正确答案:E
更多“You performed an&ensp”相关问题

  • 第1题：

    You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday， you issued the following commands：   CONFIGURE DEFAULT DEVICE TYPE TO sbt；   CONFIGURE BACKUP OPTIMIZATION ON；   CONFIGURE RETENTION POLICY TO REDUNDANCY 3；   From Monday to Saturday， you performed the following actions：   Day                         Action  Monday                BACKUP DATABASE  Tuesday                BACKUP DATABASE  Wednesday              BACKUP DATABASE  Thursday               BACKUP DATABASE  Friday                 BACKUP DATABASE  Saturday               BACKUP DATABASE  How many times will the backup of the USERS tablespace be performed？（）

    • A、 The backup will not be performed at all.
    • B、 three times
    • C、 four times
    • D、 six times

    正确答案:C

  • 第2题：

    What happens when you run the SQL Tuning Advisor with limited scope？（）  

    • A、 Access path analysis is not performed for SQL statements.
    • B、 SQL structure analysis is not performed for SQL statements.
    • C、 SQL Profile recommendations are not generated for SQL statements.
    • D、 Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.

    正确答案:B

  • 第3题：

    You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）  

    • A、SQL Access Advisor
    • B、 Memory Advisor
    • C、SQL Tuning Advisor
    • D、 Segment Advisor

    正确答案:A

  • 第4题：

    You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer （OUI） prompts you to enter the path of the inventory directory and also prompts you to specify an operating systemgroup name.  Which statement is true in this case（）

    • A、The ORACLE_BASE parameter is not set.
    • B、The installation is being performed by the root user.
    • C、The operating system group that will be specified should have root user as its member.
    • D、The installation is being performed without the "Create Starter Database" option selected.
    • E、The operating system group that will be specified must have permission to write to the inventory directory

    正确答案:E

  • 第5题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. At present about 90 GB of data is stored in DB1. You made some rough calculations that every day about 1 GB of data is modified or inserted. You set the recovery model of DB1 to Simple. According to the company requirements, during business hours, data loss of more than 120 minutes worth of transactions is unacceptable. You have to choose a backup strategy which must comply with the following two requirements: Using as little disk space as possible Complying with the company requirements. So what action should you perform to achieve this goal?（）  

    • A、A full database backup should be performed once daily. During business hour, a transaction log backup should be performed every two hours. 
    • B、A full database backup should be performed once daily 
    • C、A full database backup should be performed once daily. During business hours, a differential backup should be performed every two hours 
    • D、Perform a full database backup should be performed once every week. A differential backup should be performed once daily. During business hours a transaction log backup should be performed every two hours.

    正确答案:C

  • 第6题：

    单选题
    You created a response file and want to check it before starting installations in silent mode. You started installation of Oracle software in interactive mode by providing the response file. In the middle of the installation， you realize that the behavior of the Oracle Universal Installer （OUI） is not consistent with the response file. What action would you take to detect the cause of this behavior？（）
    A

    Compare the contents of the install.log file with the response file.

    B

    Refer to the contents of the oraInst.loc file to verify the steps performed by OUI.

    C

    Compare the contents of the installActions.log file with that of the response file.

    D

    Refer to the alert log file for information regarding the actions performed by OUI during installation.


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

  • 第7题：

    多选题
    You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）
    A

    Corrupted blocks, if any, are repaired.

    B

    Checks are performed for physical corruptions.

    C

    Checks are performed for logical corruptions.

    D

    Checks are performed to confirm whether all database files exist in correct locations

    E

    Backup sets containing both data files and archive logs are created.


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

  • 第8题：

    单选题
    You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）
    A

     The time when the last flashback operation in your database was performed.

    B

     The time when the first flashback operation in your database was performed.

    C

     A list of flashback operations performed in your database using SCN and time.

    D

     The approximate time and the lowest system change number （SCN） to which you can flash back your database.


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

  • 第9题：

    单选题
    Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available.What would you do in this scenario？（）
    A

     recovery cannot be performed because a backup was not performed after the last incomplete recovery

    B

     restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday

    C

     restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday

    D

     restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday


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

  • 第10题：

    单选题
    You are creating a job class. You want access to the detailed information for all the runs of each job in the class and every operation performed on every job in the class. Which setting will you use for the LOGGING_LEVEL parameter？（）
    A

     LOGGING_OFF

    B

     LOGGING_RUNS

    C

     LOGGING_FULL

    D

     LOGGING_NULL


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

  • 第11题：

    多选题
    You are managing an Oracle Database 11g database with the following backup strategy：1） On Sunday， an incremental level 0 tape backup is performed.2） Monday through Saturday， a cumulative incremental level 1 tape backup is performed. Which twostatements are true regarding the backups performed（）
    A

    The backup performed in step 1 backs up all blocks that have ever been in use in the database.

    B

    The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup.

    C

    The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup.

    D

    The backup performed in step 2 backs up all blocks that have changed since the most recent incrementalbackup at level 1


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

  • 第12题：

    单选题
    You are installing Oracle Database 11g on your server. During the installation Oracle UniversalInstaller （OUI） prompts you to enter the path of the inventory directory and also prompts you to specify anoperating system group name.  Which statement is true in this case（）
    A

    The ORACLE_BASE parameter is not set.

    B

    The installation is being performed by the root user.

    C

    The operating system group that will be specified should have root user as its member.

    D

    The installation is being performed without the Create Starter Database option selected.

    E

    The operating system group that will be specified must have permission to write to the inventorydirectory.


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

  • 第13题：

    You issued the following RMAN command：  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；     What is NOT an impact of using the above command？（）

    • A、 When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.
    • B、 When a structural change is made to the database， then a backup of the current control file is performed.
    • C、 When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.
    • D、 When a structural change is made to the database， then a backup of the alert log file will be performed.

    正确答案:D

  • 第14题：

    You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）

    • A、 The time when the last flashback operation in your database was performed.
    • B、 The time when the first flashback operation in your database was performed.
    • C、 A list of flashback operations performed in your database using SCN and time.
    • D、 The approximate time and the lowest system change number （SCN） to which you can flash back your database.

    正确答案:D

  • 第15题：

    You are creating a job class. You want access to the detailed information for all the runs of each job in the class and every operation performed on every job in the class. Which setting will you use for the LOGGING_LEVEL parameter？（）

    • A、 LOGGING_OFF
    • B、 LOGGING_RUNS
    • C、 LOGGING_FULL
    • D、 LOGGING_NULL

    正确答案:C

  • 第16题：

    You have a file server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). You enable Shadow Copies on all drives by using the default options. You run a full backup every Monday at 02:00. You run an incremental backup every day at 02:00, except on Monday. On Thursday at 14:00, a user reports that he accidentally deleted a file named File1.doc in a shared folder named //Server1/Data/. The user reports that the file was last updated at 09:00 on Thursday. You need to restore the latest version of File1.doc. What should you restore? （）

    • A、the file by using the Previous Versions Client
    • B、the file from the full backup performed on Monday
    • C、the file from the incremental backup performed on Thursday
    • D、the user’s computer by using Automated System Recovery (ASR)

    正确答案:A

  • 第17题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. The latest differential backup is performed at 15:30, the full back up was performed at 13:30, and database snapshots were created at 16:30 and at 17:30. The backups and the database snapshots are stored on a different disk from the database files. At 17:05, the hard disk containing the database files fails at 17:02 hours. You must restore DB1 while reduce data loss to the least.  So what action should you perform to achieve this goal?（）  

    • A、You should restore the full backup 
    • B、You should restore the database snapshot from 16:30 hours. 
    • C、You should restore the database snapshot from 17:30 hours 
    • D、You should restore both the full backup and the differential backup. 

    正确答案:D

  • 第18题：

    单选题
    You issued the following RMAN command：  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；     What is NOT an impact of using the above command？（）
    A

     When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.

    B

     When a structural change is made to the database， then a backup of the current control file is performed.

    C

     When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.

    D

     When a structural change is made to the database， then a backup of the alert log file will be performed.


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

  • 第19题：

    单选题
    You have performed the first step in placing your database into ARCHIVELOG mode. The second step is deciding whether the online redo log files are to be archived automatically or manually.  Which action should you take to enable archiving at instance startup？（）
    A

    A

    B

    B

    C

    C

    D

    D


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

  • 第20题：

    单选题
    You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）
    A

     restore the tablespace from the backup； there is no need to apply the redo information

    B

     restore the full database to recover the data up to the point when you performed the backup

    C

     restore the tablespace from the backup and then perform a recovery using the backup control file

    D

     restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied


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

  • 第21题：

    单选题
    You lost the PRODSTD tablespace， which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace？（）
    A

    restore the tablespace from the backup; there is no need to apply the redo information 

    B

    restore the full database to recover the data up to the point when you performed the backup 

    C

    restore the tablespace from the backup， and then perform a recovery using the backup control file

    D

    restore the tablespace from the backup， and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied


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

  • 第22题：

    单选题
    You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）
    A

    SQL Access Advisor

    B

     Memory Advisor

    C

    SQL Tuning Advisor

    D

     Segment Advisor


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

  • 第23题：

    单选题
    What happens when you run the SQL Tuning Advisor with limited scope？（）
    A

     Access path analysis is not performed for SQL statements.

    B

     SQL structure analysis is not performed for SQL statements.

    C

     SQL Profile recommendations are not generated for SQL statements.

    D

     Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.


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

  • 第24题：

    单选题
    You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday， you issued the following commands：   CONFIGURE DEFAULT DEVICE TYPE TO sbt；   CONFIGURE BACKUP OPTIMIZATION ON；   CONFIGURE RETENTION POLICY TO REDUNDANCY 3；   From Monday to Saturday， you performed the following actions：   Day                         Action  Monday                BACKUP DATABASE  Tuesday                BACKUP DATABASE  Wednesday              BACKUP DATABASE  Thursday               BACKUP DATABASE  Friday                 BACKUP DATABASE  Saturday               BACKUP DATABASE  How many times will the backup of the USERS tablespace be performed？（）
    A

     The backup will not be performed at all.

    B

     three times

    C

     four times

    D

     six times


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

相关内容