单选题Note the following points describing various utilities in Oracle Database 11g： 1. It enables the transfer of data from one database to another. 2. It provides a complete solution for the backup， restoration， and recovery needs of the entire database. 3

题目
单选题
Note the following points describing various utilities in Oracle Database 11g： 1. It enables the transfer of data from one database to another. 2. It provides a complete solution for the backup， restoration， and recovery needs of the entire database. 3. It enables the loading of data from an external file into tables of an Oracle database. 4. It provides a tape backup management for the Oracle ecosystem.  Which point describes the Oracle Data Pump utility（）
A

1

B

2

C

3

D

4

E

1 and 3

F

1， 2， 3， and 4

相似考题

1. Consider the recovery steps in each of the cases given below：  Case 1：  Shut down the database and perform a backup.  Restore all the data files.  Mount the database.  Recover the database.  Without applying all the redo log files， open the database using the RESETLOGS option.  Back up the database.  Case 2：  Shut down the database and perform a backup.  Restore only the data files of the tablespace where user error damaged the data.  Mount the database.  Recover the database.  Open the database with the RESETLOGS option.  Back up the database.  Case 3： Shut down the database  Restore the data files  Open the database  Perform recovery to the current point in time.  Which case has the correct steps for an incomplete recovery？（）A、only case 1B、only case 2C、only case 3D、case 1 and 2E、case 2 and 3F、case 1 and 3G、all cases： case 1， case 2 and case 3

2.A customer has the need to implement a tape backup solution to backup a 500GB database on a daily basis.  Which of the following factors is the most important consideration in the design of a backup and restore solution？（）A、Amount of data in the backupB、Bandwidth available to the tape deviceC、Length of the backup/restore windowD、Speed that the backup system can find files for restoration

3. You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?（）A、It must be executed from the Oracle Database 11g environment.B、It must be executed only after the SYSAUX tablespace has been created.C、It must be executed from the environment of the database that is being upgraded.D、It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.E、It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

4.SQ L*Loader is a utility that can perform which two tasks？（）A、Load data from a disk， tape， or named pipes.B、Load data into an Oracle database using DML statements.C、Extract， reorganize， and insert data within an Oracle database.D、Load data from external files into tables in an Oracle database.E、Load data into an Oracle database using operating system commands.F、Load data directly from a non-Oracle database to an Oracle database.

更多“单选题Note the following points describing various utilities in Oracle Database 11g： 1. It enables the transfer of data from one database to another. 2. It provides a complete solution for the backup， restoration， and recovery needs of the entire database. 3”相关问题

  • 第1题：

    You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）;  Which two statements are true？ （）

    • A、SYSDATE should not be used with TIMESTAMP.
    • B、The database must have multiplexed redo log files.
    • C、The database must be in the MOUNT state to execute the command.
    • D、The database must be opened with the RESETLOGS option after the flashback operation.
    • E、The entire database needs to be restored from the most recent backup before the flashback operation.

    正确答案:C,D

  • 第2题：

    While planning to manage more than one database in your system， you perform the following activities：  1. Organize different categories of files into independent subdirectories.  2. Use consistent naming convention for database files.  3. Separate administrative information pertaining to each database.  Which option corresponds to the type of activities performed by you？（）

    • A、Oracle Managed Files
    • B、Oracle Grid Architecture
    • C、Optimal Flexible Architecture
    • D、Oracle database architecture

    正确答案:C

  • 第3题：

    A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

    • A、 Flash back all the tables in the data file， one by one.
    • B、 Restore the data file to a new location and perform a media recovery.
    • C、 Flash back the database， there is no need to restore the data file.
    • D、 Restore the data file from the most recent backup and flash the database.

    正确答案:B

  • 第4题：

    Note the following points describing various utilities in Oracle Database 11g：  1：It enables the high-speed transfer of data from one database to another.  2：It provides a complete solution for the backup， restoration， and recovery needs of the entire database.  3：It enables the loading of data from an external file into an Oracle database.  4：It provides a tape backup management for the Oracle ecosystem. Which point describes Oracle Secure Backup（）

    • A、1
    • B、2
    • C、3
    • D、4
    • E、1，2，and 4
    • F、1，2，3，and 4

    正确答案:D

  • 第5题：

    Note the following points describing various utilities in Oracle Database 1g：1. It enables the high-speed transfer of data from one database to another. 2. It provides a complete solution for the backup， restoration， and recovery needs of the entire database.3. It enables the loading of data from an external file into an Oracle database.4. It provides a tape backup management for the Oracle ecosystem. Which point describes Oracle Secure Backup（）

    • A、1
    • B、2
    • C、3
    • D、4
    • E、1， 2， and 4
    • F、1， 2， 3， and 4

    正确答案:D

  • 第6题：

    In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure.  How would you recover the lost redo log member？（）

    • A、import the database from the last export
    • B、restore all the members in the group from the last backup
    • C、drop the lost member from the database， and then add a new member to the group
    • D、restore all the database files from the backup， and then perform a complete recovery 
    • E、restore all the database files from the backup， and then perform an incomplete recovery

    正确答案:C

  • 第7题：

    单选题
    Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning， media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.What would you do in this situation？（）
    A

    recover using Oracle Flashback Database technology

    B

    restore the data files from backup and perform a complete recovery

    C

    restore only the corrupted data file and perform tablespace recovery

    D

    restore the data files from backup and perform cancel­based recovery

    E

    restore the entire database from the most recent backup and start the instance and open the database


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

  • 第8题：

    单选题
    Consider the recovery steps in each of the cases given below：  Case 1：  Shut down the database and perform a backup.  Restore all the data files.  Mount the database.  Recover the database.  Without applying all the redo log files， open the database using the RESETLOGS option.  Back up the database.  Case 2：  Shut down the database and perform a backup.  Restore only the data files of the tablespace where user error damaged the data.  Mount the database.  Recover the database.  Open the database with the RESETLOGS option.  Back up the database.  Case 3： Shut down the database  Restore the data files  Open the database  Perform recovery to the current point in time.  Which case has the correct steps for an incomplete recovery？（）
    A

    only case 1

    B

    only case 2

    C

    only case 3

    D

    case 1 and 2

    E

    case 2 and 3

    F

    case 1 and 3

    G

    all cases： case 1， case 2 and case 3


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

  • 第9题：

    单选题
    Note the following points describing various utilities in Oracle Database 11g：  1：It enables the high-speed transfer of data from one database to another.  2：It provides a complete solution for the backup， restoration， and recovery needs of the entire database.  3：It enables the loading of data from an external file into an Oracle database.  4：It provides a tape backup management for the Oracle ecosystem. Which point describes Oracle Secure Backup（）
    A

    1

    B

    2

    C

    3

    D

    4

    E

    1，2，and 4

    F

    1，2，3，and 4


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

  • 第10题：

    单选题
    In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure.  How would you recover the lost redo log member？（）
    A

    import the database from the last export

    B

    restore all the members in the group from the last backup

    C

    drop the lost member from the database， and then add a new member to the group

    D

    restore all the database files from the backup， and then perform a complete recovery 

    E

    restore all the database files from the backup， and then perform an incomplete recovery


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

  • 第11题：

    单选题
    A customer has the need to implement a tape backup solution to backup a 500GB database on a daily basis.  Which of the following factors is the most important consideration in the design of a backup and restore solution？（）
    A

    Amount of data in the backup

    B

    Bandwidth available to the tape device

    C

    Length of the backup/restore window

    D

    Speed that the backup system can find files for restoration


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

  • 第12题：

    单选题
    You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?（）
    A

    It must be executed from the Oracle Database 11g environment.

    B

    It must be executed only after the SYSAUX tablespace has been created.

    C

    It must be executed from the environment of the database that is being upgraded.

    D

    It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.

    E

    It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.


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

  • 第13题：

    Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning，media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.  What would you do in this situation？（）

    • A、recover using Oracle Flashback Database technology
    • B、restore the data files from backup and perform a complete recovery
    • C、restore only the corrupted data file and perform tablespace recovery
    • D、restore the data files from backup and perform cancel-based recovery
    • E、restore the entire database from the most recent backup and start the instance and open the database

    正确答案:E

  • 第14题：

    You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）

    • A、The database crashes.
    • B、The DBA needs to re-create the file.
    • C、The file gets re-created automatically.
    • D、The file gets restored automatically from the last backup.
    • E、The DBA needs to perform a complete database recovery.
    • F、The DBA needs to perform an incomplete database recovery.

    正确答案:C

  • 第15题：

    Case 1：  1. Shut down the database and perform a backup.  2. Restore all the data files.  3. Mount the database.  4. Recover the database.  5. Without applying all the redo log files， open the database using the RESETLOGS option.  6. Back up the database.  Case 2：  1. Shut down the database and perform a backup.  2. Restore only the data files of the tablespace where user error damaged the data.  3. Mount the database. 4. Recover the database.  5. Open the database with the RESETLOGS option.  6. Back up the database.  Case 3：  1. Shut down the database.  2. Restore the data files.  3. Open the database.  4. Perform recovery to the current point in time.  Which case has the correct steps for an incomplete recovery？（）

    • A、 Only case 1
    • B、 Only case 2
    • C、 Only case 3
    • D、 Case 1 and 2
    • E、 Case 2 and 3
    • F、 Case 1 and 3
    • G、 All cases， case 1， case 2， case 3

    正确答案:A

  • 第16题：

    Note the following points describing various utilities in Oracle Database 11g： 1. It enables the transfer of data from one database to another. 2. It provides a complete solution for the backup， restoration， and recovery needs of the entire database. 3. It enables the loading of data from an external file into tables of an Oracle database. 4. It provides a tape backup management for the Oracle ecosystem.  Which point describes the Oracle Data Pump utility（）

    • A、1
    • B、2
    • C、3
    • D、4
    • E、1 and 3
    • F、1， 2， 3， and 4

    正确答案:A

  • 第17题：

    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 the following command: SQL> ALTER TABLESPACE hi_data BEGIN BACKUP; Which two statements are true in this scenario? （）

    • A、No transaction on the tablespace is allowed but you can perform queries.
    • B、The tablespace will automatically come out of backup mode when the file copy is complete.
    • C、The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.
    • D、The database writes the before image of an entire block to the redo stream before modifying. block tor the first time.

    正确答案:A,C

  • 第18题：

    单选题
    Case 1：  1. Shut down the database and perform a backup.  2. Restore all the data files.  3. Mount the database.  4. Recover the database.  5. Without applying all the redo log files， open the database using the RESETLOGS option.  6. Back up the database.  Case 2：  1. Shut down the database and perform a backup.  2. Restore only the data files of the tablespace where user error damaged the data.  3. Mount the database. 4. Recover the database.  5. Open the database with the RESETLOGS option.  6. Back up the database.  Case 3：  1. Shut down the database.  2. Restore the data files.  3. Open the database.  4. Perform recovery to the current point in time.  Which case has the correct steps for an incomplete recovery？（）
    A

     Only case 1

    B

     Only case 2

    C

     Only case 3

    D

     Case 1 and 2

    E

     Case 2 and 3

    F

     Case 1 and 3

    G

     All cases， case 1， case 2， case 3


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

  • 第19题：

    单选题
    Note the following points describing various utilities in Oracle Database 11g： 1. It enables the transfer of data from one database to another. 2. It provides a complete solution for the backup， restoration， and recovery needs of the entire database. 3. It enables the loading of data from an external file into tables of an Oracle database. 4. It provides a tape backup management for the Oracle ecosystem.  Which point describes the Oracle Data Pump utility（）
    A

    1

    B

    2

    C

    3

    D

    4

    E

    1 and 3

    F

    1， 2， 3， and 4


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

  • 第20题：

    单选题
    Note the following points describing various utilities in Oracle Database 11g： 1. It enables the transfer of data from one database to another. 2. It provides a complete solution for the backup， restoration， and recovery needs of the entire database. 3. It enables the loading of data from an external file into tables of an Oracle database. 4. It provides a tape backup management for the Oracle ecosystem.  Which point describes the Oracle Data Pump utility（）
    A

    1

    B

    2

    C

    3

    D

    4

    E

    1 and 3

    F

    1， 2， 3， and 4


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

  • 第21题：

    单选题
    A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）
    A

     Flash back all the tables in the data file， one by one.

    B

     Restore the data file to a new location and perform a media recovery.

    C

     Flash back the database， there is no need to restore the data file.

    D

     Restore the data file from the most recent backup and flash the database.


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

  • 第22题：

    单选题
    You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）
    A

    The database crashes.

    B

    The DBA needs to re-create the file.

    C

    The file gets re-created automatically.

    D

    The file gets restored automatically from the last backup.

    E

    The DBA needs to perform a complete database recovery.

    F

    The DBA needs to perform an incomplete database recovery.


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

  • 第23题：

    多选题
    You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE ？5/24）； Which two statements are true？ （）
    A

    SYSDATE should not be used with TIMESTAMP.

    B

    The database must have multiplexed redo log files.

    C

    The database must be in the MOUNT state to execute the command.

    D

    The database must be opened with the RESETLOGS option after the flashback operation.

    E

    The entire database needs to be restored from the most recent backup before the flashback operation.


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

  • 第24题：

    单选题
    Note the following points describing various utilities in Oracle Database 1g：1. It enables the high-speed transfer of data from one database to another. 2. It provides a complete solution for the backup， restoration， and recovery needs of the entire database.3. It enables the loading of data from an external file into an Oracle database.4. It provides a tape backup management for the Oracle ecosystem. Which point describes Oracle Secure Backup（）
    A

    1

    B

    2

    C

    3

    D

    4

    E

    1， 2， and 4

    F

    1， 2， 3， and 4


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

相关内容