单选题You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RE

题目
单选题
You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RESETLOGS；   Which of the following options is true about using the RESETLOGS option？（）
A

 The log sequence is reset to 0.

B

 All the online redo logs are deleted.

C

 All the archived redo logs from a previous incarnation become useless.

D

 The full database backup taken from a previous incarnation can be used in future.

E

 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

相似考题

1.You work as a database administrator for Certkiller .com. While granting a role，SELECT_CATALOG_ROLE， to a user， Certkiller， using Oracle Enterprise Manager 10g Database Control， you have cleared the DEFAULT check box. What will be the result？（）A、The user cannot use the role at all.B、The role would not be granted to the user.C、The user needs to enable the role explicitly.D、The user can start using the role immediately.E、The user would have the admin option for the role.

2. Your Oracle Database 10g is online when you execute the following statement：        SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF；   What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）A、 The database does not record flashback logs for MY_TABLESPACEB、 The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.C、 All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.D、 None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE

3. You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set.   How will you migrate your database from UTF8 to AL16UTF16？（）  A、 by using the RMAN utilityB、 by using the export/import utilityC、 by using the ALTER DATABASE commandD、 by enabling the change tracking feature

4.You work as a database administrator for Certkiller .com. You want to administer your database servers，which are running on different host machines，using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）A、Application Server ControlB、Oracle Management ServiceC、Oracle Enterprise Manager RepositoryD、Oracle Enterprise Manager Database Control

更多“You have recovered your Oracle Database 10g by using the con”相关问题

  • 第1题：

    You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RESETLOGS；   Which of the following options is true about using the RESETLOGS option？（）

    • A、 The log sequence is reset to 0.
    • B、 All the online redo logs are deleted.
    • C、 All the archived redo logs from a previous incarnation become useless.
    • D、 The full database backup taken from a previous incarnation can be used in future.
    • E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

    正确答案:D

  • 第2题：

    You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces？（）

    • A、SQL*Plus
    • B、iSQL*Plus
    • C、Management Server
    • D、Management Repository
    • E、Oracle Enterprise Manager 10g Database Control

    正确答案:E

  • 第3题：

    Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario？（）

    • A、The instance aborts.
    • B、The database cannot be recovered.
    • C、The database can be recovered by restoring the control files from the backup.
    • D、The database remains opened and you have to shut it down with the ABORT option.
    • E、The database can be restored till the point of the last closed whole database backup.

    正确答案:A,E

  • 第4题：

    You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）

    • A、 by using the Flashback Database feature
    • B、 by using RMAN incomplete recovery
    • C、 by performing a user-managed incomplete recovery
    • D、 by dropping and re-creating the index tablespace

    正确答案:D

  • 第5题：

    多选题
    In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）
    A

    average row size

    B

    last analyzed date

    C

    size of table in bytes

    D

    size of table in database blocks

    E

    number of free blocks in the free list

    F

    number of extents present in the table


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

  • 第6题：

    单选题
    You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）
    A

    The Oracle kernel will be placed in this location.

    B

    The Oracle software will be placed in this location.

    C

    The server parameter file （SPFILE） will be placed in this location.

    D

    The database files will be placed in this location， if not specified explicitly.

    E

    The location will be considered for the base of Oracle Managed Files （OMF）.

    F

    The location will be considered for the base of Optimal Flexible Architecture （OFA）.


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

  • 第7题：

    单选题
    If you create your database using Oracle Managed Files （OMF）， what is true？（）
    A

    You must use Oracle predefined names to identify raw partitions that will hold OMF structures. 

    B

    You must define directories for two online redo log groups and three copies of the control file. 

    C

    If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. 

    D

    You must use only OMF data files when adding new tablespaces or data files to your database in the future.


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

  • 第8题：

    单选题
    While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space. However, you have another database where more space is available and you want to move your existing recovery catalog to this database. The options that can be considered while moving the recovery catalog are as follows: 1. Using one of the Oracle expdp utilities to export the catalog data 2. Creating a recovery catalog user and granting the necessary privileges in the other database 3. Creating the recovery catalog using the CREATE CATALOG command 4. Using the corresponding impdp utility to import the catalog data into the other database 5. Registering the target database in the new catalog database using the REGISTER DATABASE command Identify the option with the correct sequence for moving the recovery catalog.（）
    A

    2，3，5

    B

    1，2，4

    C

    1，2，4，5

    D

    1, 2, 3, 4, 5


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

  • 第9题：

    单选题
    You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RESETLOGS；   Which of the following options is true about using the RESETLOGS option？（）
    A

     The log sequence is reset to 0.

    B

     All the online redo logs are deleted.

    C

     All the archived redo logs from a previous incarnation become useless.

    D

     The full database backup taken from a previous incarnation can be used in future.

    E

     Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.


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

  • 第10题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）
    A

    use the external table population

    B

    use the Oracle Data Pump export and import utility

    C

    use the conventional path data load of SQL*Loader utility

    D

    use the direct path data load of Oracle export and import utility


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

  • 第11题：

    多选题
    You work as a database administrator for Supportcenter.cn. You want to administer your database servers， which are running on different host machines， using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）
    A

    Application Server Control

    B

    Oracle Management Service

    C

    Oracle Enterprise Manager Repository

    D

    Oracle Enterprise Manager Database Control


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

  • 第12题：

    单选题
    After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?（）
    A

    Opening the database in RESTRICTED mode

    B

    Opening the database with the RESETLOGS option

    C

    Setting a new DBID for the newly restored database

    D

    Restoring the server parameter file (SPFILE) to the new host


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

  • 第13题：

    You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）

    • A、The Oracle kernel will be placed in this location.
    • B、The Oracle software will be placed in this location.
    • C、The server parameter file （SPFILE） will be placed in this location.
    • D、The database files will be placed in this location， if not specified explicitly.
    • E、The location will be considered for the base of Oracle Managed Files （OMF）.
    • F、The location will be considered for the base of Optimal Flexible Architecture （OFA）.

    正确答案:F

  • 第14题：

    If you create your database using Oracle Managed Files （OMF）， what is true？（）

    • A、You must use Oracle predefined names to identify raw partitions that will hold OMF structures. 
    • B、You must define directories for two online redo log groups and three copies of the control file. 
    • C、If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. 
    • D、You must use only OMF data files when adding new tablespaces or data files to your database in the future.

    正确答案:D

  • 第15题：

    You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）

    • A、 target database
    • B、 auxiliary database
    • C、 third-party database
    • D、 recovery catalog database

    正确答案:C

  • 第16题：

    Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）

    • A、 V$DATABASE
    • B、 V$UNDOSTAT
    • C、 V$FLASHBACK_DATABASE_LOG
    • D、 V$FLASHBACK_DATABASE_STAT

    正确答案:C

  • 第17题：

    单选题
    You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature?（）
    A

    ALTER DATABASE ENABLE BLOCK CHANGE TRACKING

    B

    ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE

    C

    ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE

    D

    ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING


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

  • 第18题：

    单选题
    You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）
    A

     by using the Flashback Database feature

    B

     by using RMAN incomplete recovery

    C

     by performing a user-managed incomplete recovery

    D

     by dropping and re-creating the index tablespace


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

  • 第19题：

    多选题
    Your application demands frequent connection and disconnection from the database. You have three listener processes that are listening for the database PROD. While setting up the connect string using Oracle Enterprise Manager 10g Database Control， which two options would you select to balance the connection load across all the listener processes？（）
    A

    Use only the first address.

    B

    Try one address，selected at random.

    C

    Try each address，in order，until one succeeds.

    D

    Try each address，randomly，until one succeeds.


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

  • 第20题：

    单选题
    Your Oracle Database 10g is online when you execute the following statement：        SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF；   What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）
    A

     The database does not record flashback logs for MY_TABLESPACE

    B

     The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.

    C

     All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.

    D

     None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE


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

  • 第21题：

    单选题
    You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set.   How will you migrate your database from UTF8 to AL16UTF16？（）
    A

     by using the RMAN utility

    B

     by using the export/import utility

    C

     by using the ALTER DATABASE command

    D

     by enabling the change tracking feature


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

  • 第22题：

    单选题
    You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces？（）
    A

    SQL*Plus

    B

    iSQL*Plus

    C

    Management Server

    D

    Management Repository

    E

    Oracle Enterprise Manager 10g Database Control


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

  • 第23题：

    多选题
    Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario？（）
    A

    The instance aborts.

    B

    The database cannot be recovered.

    C

    The database can be recovered by restoring the control files from the backup.

    D

    The database remains opened and you have to shut it down with the ABORT option.

    E

    The database can be restored till the point of the last closed whole database backup.


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

  • 第24题：

    单选题
    You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）
    A

     target database

    B

     auxiliary database

    C

     third-party database

    D

     recovery catalog database


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

相关内容