单选题When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?（）A Online B Pending online C Offline D Stale

题目
单选题
When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?（）
A

Online 

B

Pending online 

C

Offline 

D

Stale

相似考题

1. You execute the following command to change the status of the SALES tablespace：  SQL> ALTER TABLESPACE sales OFFLINE；  Which statements describe the effect of the command（）A、The tablespace would require recovery to go back online.B、A checkpoint is taken on all data files that are associated with the SALES tablespace.C、The sessions that subsequently try to access the objects in the SALES tablespace receive an error.D、The new status of the SALES tablespace is recorded in the control file when the database instance is closed.

2.You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）  A、 The database will not start.B、 The database will start but will not retain the undo data in the undo segment.C、 The database will start， and the undo segment will contain the undo data for at least one hour.D、 The database will start， and the undo segment will retain the undo data for at least 15 minutes.

3.When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?（）A、Online B、Pending online C、Offline D、Stale

4.Which two tasks can be performed when WLST is in OFFLINE mode?（）A、modifying the configuration of an online domainB、modifying the configuration of an offline domainC、viewing runtime performance data in ONLINE modeD、viewing runtime performance data in OFFLINE modeE、creating and extending domains

更多“单选题When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?（）A Online B Pending online C Offline D Stale”相关问题

  • 第1题：

    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

  • 第2题：

    Which two statements are true regarding transactions in an Oracle database（）

    • A、Multiple transactions can use the same undo segment.
    • B、A transaction is assigned an undo segment when it is started.
    • C、More than one transaction cannot share the same extent in the undo tablespace.
    • D、The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.

    正确答案:A,B

  • 第3题：

    Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database？（）  

    • A、 Oracle will automatically take the datafile out of hot backup mode，generate a warning message，and then open the database.
    • B、 Oracle will automatically take the datafile out of hot backup mode and then open the database.
    • C、 Oracle will generate an error when trying to open the database，indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.
    • D、 The database will open with the file in hot backup mode. You can restart the backup at any time.
    • E、 The datafile in hot backup mode will be corrupted and you will have to recover it.

    正确答案:C

  • 第4题：

    You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace， UNDO_TBS1， in your database. Which two additional steps would you perform to achieve this？（）

    • A、Set the UNDO_RETENTION parameter to 900 or more.
    • B、Create an initial undo segment in the undo tablespace.
    • C、Enable the retention guarantee for the undo tablespace.
    • D、Set the UNDO_TABLESPACE parameter to UNDO_TBS1.
    • E、Set the UNDO_MANAGEMENT initialization parameter to AUTO.

    正确答案:D,E

  • 第5题：

    You execute the following command to change the status of the SALES tablespace：SQL> ALTER TABLESPACE sales OFFLINE； Which statements describe the effect of the command（）

    • A、The tablespace would require recovery to go back online.
    • B、A checkpoint is taken on all data files that are associated with the SALES tablespace.
    • C、The sessions that subsequently try to access the objects in the SALES tablespace receive an error
    • D、The new status of the SALES tablespace is recorded in the control file when the database instance isclosed

    正确答案:B,C

  • 第6题：

    When performing a database duplication， which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location？（）  

    • A、 log_file_name_convert
    • B、 convert_log_file_name
    • C、 file_name_convert_log
    • D、 redo_log_file_name_convert
    • E、 logfile_convert_directory

    正确答案:A

  • 第7题：

    多选题
    Which two tasks can be performed when WLST is in OFFLINE mode?（）
    A

    modifying the configuration of an online domain

    B

    modifying the configuration of an offline domain

    C

    viewing runtime performance data in ONLINE mode

    D

    viewing runtime performance data in OFFLINE mode

    E

    creating and extending domains


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

  • 第8题：

    单选题
    You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the optimal size of the online redo log files. Which tool enables you to determine the optimal size of the online redo log files？（）
    A

     Oracle Enterprise Manager

    B

     The V$LOG view

    C

     The V$LOGFILE view

    D

     The V$FLASHBACK_DATABASE_LOGS view


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

  • 第9题：

    多选题
    You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace， UNDO_TBS1， in your database. Which two additional steps would you perform to achieve this？（）
    A

    Set the UNDO_RETENTION parameter to 900 or more.

    B

    Create an initial undo segment in the undo tablespace.

    C

    Enable the retention guarantee for the undo tablespace.

    D

    Set the UNDO_TABLESPACE parameter to UNDO_TBS1.

    E

    Set the UNDO_MANAGEMENT initialization parameter to AUTO.


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

  • 第10题：

    单选题
    You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）
    A

     The database will not start.

    B

     The database will start but will not retain the undo data in the undo segment.

    C

     The database will start， and the undo segment will contain the undo data for at least one hour.

    D

     The database will start， and the undo segment will retain the undo data for at least 15 minutes.


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

  • 第11题：

    单选题
    When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?（）
    A

    Online 

    B

    Pending online 

    C

    Offline 

    D

    Stale


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

  • 第12题：

    多选题
    You execute the following command to change the status of the SALES tablespace：  SQL> ALTER TABLESPACE sales OFFLINE；  Which statements describe the effect of the command（）
    A

    The tablespace would require recovery to go back online.

    B

    A checkpoint is taken on all data files that are associated with the SALES tablespace.

    C

    The sessions that subsequently try to access the objects in the SALES tablespace receive an error.

    D

    The new status of the SALES tablespace is recorded in the control file when the database instance is closed.


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

  • 第13题：

    You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace： RMAN> BACKUP TABLESPACE DETTBS；  Under which conditions would this command execute successfully？ （）

    • A、 The database is in NOMOUNT state.
    • B、 The database is in NOARCHIVELOG mode and the tablespace is online.
    • C、 The database is in NOARCHIVELOG mode and the tablespace is offline.
    • D、 The database is in ARCHIVELOG mode and the tablespace is offline.
    • E、 The database is in ARCHIVELOG mode and the tablespace is online.

    正确答案:C,D,E

  • 第14题：

    In what state are the datafiles of a tablespace after a TSPITR has been successfully completed？（）  

    • A、 The datafiles have an ONLINE status.
    • B、 The datafiles have an OFFLINE status.
    • C、 The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.
    • D、 The datafiles have an OFFLINE status and are in hot backup mode for an online backup.
    • E、 The datafiles are in STANDBY mode.

    正确答案:A

  • 第15题：

    Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）

    • A、When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.
    • B、When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.
    • C、When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
    • D、When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

    正确答案:A

  • 第16题：

    You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?（）

    • A、DB_CREATE_FILE_DEST 
    • B、DB_CREATE_ONLINE_LOG_1 
    • C、DB_CREATE_ONLINE_LOG_2
    • D、The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed

    正确答案:A

  • 第17题：

    You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? （）

    • A、ALTER DATABASE 
    • B、SET TRANSACTION 
    • C、ALTER ROLLBACK SEGMENT 
    • D、ALTER TABLE

    正确答案:B

  • 第18题：

    单选题
    Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database？（）
    A

     Oracle will automatically take the datafile out of hot backup mode，generate a warning message，and then open the database.

    B

     Oracle will automatically take the datafile out of hot backup mode and then open the database.

    C

     Oracle will generate an error when trying to open the database，indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.

    D

     The database will open with the file in hot backup mode. You can restart the backup at any time.

    E

     The datafile in hot backup mode will be corrupted and you will have to recover it.


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

  • 第19题：

    单选题
    In what state are the datafiles of a tablespace after a TSPITR has been successfully completed？（）
    A

     The datafiles have an ONLINE status.

    B

     The datafiles have an OFFLINE status.

    C

     The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.

    D

     The datafiles have an OFFLINE status and are in hot backup mode for an online backup.

    E

     The datafiles are in STANDBY mode.


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

  • 第20题：

    单选题
    When performing a database duplication， which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location？（）
    A

     log_file_name_convert

    B

     convert_log_file_name

    C

     file_name_convert_log

    D

     redo_log_file_name_convert

    E

     logfile_convert_directory


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

  • 第21题：

    单选题
    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
    解析： 暂无解析

  • 第22题：

    单选题
    You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? （）
    A

    ALTER DATABASE 

    B

    SET TRANSACTION 

    C

    ALTER ROLLBACK SEGMENT 

    D

    ALTER TABLE


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

  • 第23题：

    多选题
    You execute the following command to change the status of the SALES tablespace：SQL> ALTER TABLESPACE sales OFFLINE； Which statements describe the effect of the command（）
    A

    The tablespace would require recovery to go back online.

    B

    A checkpoint is taken on all data files that are associated with the SALES tablespace.

    C

    The sessions that subsequently try to access the objects in the SALES tablespace receive an error

    D

    The new status of the SALES tablespace is recorded in the control file when the database instance isclosed


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

  • 第24题：

    单选题
    You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?（）
    A

    DB_CREATE_FILE_DEST 

    B

    DB_CREATE_ONLINE_LOG_1 

    C

    DB_CREATE_ONLINE_LOG_2

    D

    The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed


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

相关内容