单选题You work as a database administrator for Supportcenter.cn. You received the following error while working on your database： ORA-01555： snapshot too old ，In which situation would you receive such an error？（）A You performed rollback after commit.B If a l

题目
单选题
You work as a database administrator for Supportcenter.cn. You received the following error while working on your database： ORA-01555： snapshot too old ，In which situation would you receive such an error？（）
A

You performed rollback after commit.

B

If a log switch occurs in your database.

C

Thearchiverfails to generate an archived log file.

D

Instance recovery fails to find one of the redo log files.

E

A long-running query is unable to get read-consistent image.

F

If you perform manual undo management operations in auto mode.

相似考题

1. You work as a database administrator for Certkiller .com. You received the following error while working on your database： ORA-01555： snapshot too old  In which situation would you receive such an error？（）A、You performed rollback after commit.B、If a log switch occurs in your database.C、Thearchiverfails to generate an archived log file.D、Instance recovery fails to find one of the redo log files.E、A long-running query is unable to get read-consistent image.F、If you perform manual undo management operations in auto mode.

2.You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）A、guarantee undo retentionB、add one more redo log groupC、size the redo log files appropriatelyD、size the UNDO tablespace appropriatelyE、size the SYSTEM tablespace appropriatelyF、configure an appropriate undo retention intervalG、change automatic undo management to manual

3. You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error：   ERROR：   ORA-12541：TNS：no_listener   You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener.   lsnrctl>START   What statement is true？（）A、It would attempt to start the default listenerB、It would start the most recently created listener.C、It would display an error with a message asking for the listener name to be specified.D、It would show you a list of listeners and prompts for the listener name that you want to start.

4.You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）A、Database ControlB、Management ServerC、Management RepositoryD、Application Server ControlE、Oracle Management Agent

更多“单选题You work as a database administrator for Supportcenter.cn. You received the following error while working on your database： ORA-01555： snapshot too old ，In which situation would you receive such an error？（）A You performed rollback after commit.B If a l”相关问题

  • 第1题：

    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

    正确答案:C,D

  • 第2题：

    You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning， while querying the user1.employeestable， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51）  ORA-01110： data file 5：’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following：  The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file and all the archived logs are accessible.  Which option would you choose？（）

    • A、 flash back the corrupted blocks
    • B、 use the DBMS_REPAIR package
    • C、 use the RMAN TSPITR command
    • D、 use the RMAN BLOCKRECOVER command
    • E、 use the RESTORE DATABASE and RECOVER DATABASE commands
    • F、 investigate the time at which the corruption occurred and perform a point-in-time recovery

    正确答案:D

  • 第3题：

    You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？（）

    • A、Hot backup
    • B、Online backup
    • C、consistent backup
    • D、incremental backup
    • E、inconsistent backup

    正确答案:C

  • 第4题：

    You work as a database administrator for Certkiller .com. When you tried to connect to the database， you received the following error： ERROR：  ORA-12541：TNS：no_listener  You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener.  lsnrctl>START  What statement is true？（）

    • A、It would attempt to start the default listener
    • B、It would start the most recently created listener.
    • C、It would display an error with a message asking for the listener name to be specified.
    • D、It would show you a list of listeners and prompts for the listener name that you want to start.

    正确答案:A

  • 第5题：

    You work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）

    • A、All control files are opened
    • B、All redo files are opened
    • C、The password file is opened
    • D、The parameter file is opened
    • E、All online data files are opened

    正确答案:B,E

  • 第6题：

    单选题
    You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning， while querying the user1.employeestable， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51）  ORA-01110： data file 5：’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following：  The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file and all the archived logs are accessible.  Which option would you choose？（）
    A

     flash back the corrupted blocks

    B

     use the DBMS_REPAIR package

    C

     use the RMAN TSPITR command

    D

     use the RMAN BLOCKRECOVER command

    E

     use the RESTORE DATABASE and RECOVER DATABASE commands

    F

     investigate the time at which the corruption occurred and perform a point-in-time recovery


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

  • 第7题：

    多选题
    You work as a database administrator for Supportcenter.cn. You decided to manage client and server connections using Local Naming method in Supportcenter.cn. When you try to connect to the database you get the following error： ERROR：   ORA-12154：TNS：couldnot resolve service name   Which network configuration files would you look into to resolve this error？（）
    A

    snmp.ora

    B

    names.ora

    C

    spfile.ora

    D

    sqlnet.ora

    E

    listener.ora

    F

    tnsnames.ora


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

  • 第8题：

    单选题
    When you try to open your database， you receive the following error：  ORA-00205： error in identifying controlfile  Where would you find the details required to resolve this error？（）
    A

    audit trail

    B

    alert log file

    C

    user trace file

    D

    online trace file

    E

    background trace file

    F

    operating system event viewer


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

  • 第9题：

    单选题
    While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）
    A

     Memory Advisor

    B

     Segment Advisor

    C

     Undo Advisor

    D

     SQL Tuning Advisor


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

  • 第10题：

    单选题
    You work as a database administrator for Certkiller .com. You received the following error while working on your database： ORA-01555： snapshot too old  In which situation would you receive such an error？（）
    A

    You performed rollback after commit.

    B

    If a log switch occurs in your database.

    C

    Thearchiverfails to generate an archived log file.

    D

    Instance recovery fails to find one of the redo log files.

    E

    A long-running query is unable to get read-consistent image.

    F

    If you perform manual undo management operations in auto mode.


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

  • 第11题：

    单选题
    You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？（）
    A

    Hot backup

    B

    Online backup

    C

    consistent backup

    D

    incremental backup

    E

    inconsistent backup


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

  • 第12题：

    单选题
    You work as a database administrator for Supportcenter.cn. You received the following error while working on your database： ORA-01555： snapshot too old ，In which situation would you receive such an error？（）
    A

    You performed rollback after commit.

    B

    If a log switch occurs in your database.

    C

    Thearchiverfails to generate an archived log file.

    D

    Instance recovery fails to find one of the redo log files.

    E

    A long-running query is unable to get read-consistent image.

    F

    If you perform manual undo management operations in auto mode.


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

  • 第13题：

    While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）

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

    正确答案:C

  • 第14题：

    When you try to open your database， you receive the following error：  ORA-00205： error in identifying control file   Where would you find the details required to resolve this error？（）

    • A、audit trail
    • B、alert log file
    • C、user trace file
    • D、online trace file
    • E、background trace file
    • F、operating system event viewer

    正确答案:B

  • 第15题：

    You work as a database administrator for Supportcenter.cn. You received the following error while working on your database： ORA-01555： snapshot too old ，In which situation would you receive such an error？（）

    • A、You performed rollback after commit.
    • B、If a log switch occurs in your database.
    • C、Thearchiverfails to generate an archived log file.
    • D、Instance recovery fails to find one of the redo log files.
    • E、A long-running query is unable to get read-consistent image.
    • F、If you perform manual undo management operations in auto mode.

    正确答案:E

  • 第16题：

    You work as a database administrator for Supportcenter.cn. You decided to manage client and server connections using Local Naming method in Supportcenter.cn. When you try to connect to the database you get the following error： ERROR：   ORA-12154：TNS：couldnot resolve service name   Which network configuration files would you look into to resolve this error？（）

    • A、snmp.ora
    • B、names.ora
    • C、spfile.ora
    • D、sqlnet.ora
    • E、listener.ora
    • F、tnsnames.ora

    正确答案:D,F

  • 第17题：

    You work as a database administrator for Certkiller .com. You decided to manage client and server connections using Local Naming method in Certkiller .com. When you try to connect to the database you get the following error： ERROR：  ORA-12154：TNS：couldnot resolve service name  Which network configuration files would you look into to resolve this error？（）

    • A、snmp.ora
    • B、names.ora
    • C、spfile.ora
    • D、sqlnet.ora
    • E、listener.ora
    • F、tnsnames.ora

    正确答案:D,F

  • 第18题：

    单选题
    You work as a database administrator for Supportcenter.cn. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation. Which advisory component would you refer to， in order to determine the appropriate indexes？（）
    A

    Memory Advisors

    B

    Segment Advisors

    C

    SQL Tuning and Access Advisors

    D

    Automated Workload Repository （AWR）

    E

    Automatic Database Diagnostic Monitor （ADDM）


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

  • 第19题：

    单选题
    You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）
    A

    Database Control

    B

    Management Server

    C

    Management Repository

    D

    Application Server Control

    E

    Oracle Management Agent


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

  • 第20题：

    多选题
    You work as a database administrator for Certkiller .com. You decided to manage client and server connections using Local Naming method in Certkiller .com. When you try to connect to the database you get the following error： ERROR：  ORA-12154：TNS：couldnot resolve service name  Which network configuration files would you look into to resolve this error？（）
    A

    snmp.ora

    B

    names.ora

    C

    spfile.ora

    D

    sqlnet.ora

    E

    listener.ora

    F

    tnsnames.ora


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

  • 第21题：

    单选题
    You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error：   ERROR：   ORA-12541：TNS：no_listener   You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener.   lsnrctl>START   What statement is true？（）
    A

    It would attempt to start the default listener

    B

    It would start the most recently created listener.

    C

    It would display an error with a message asking for the listener name to be specified.

    D

    It would show you a list of listeners and prompts for the listener name that you want to start.


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

  • 第22题：

    单选题
    You work as a database administrator for Supportcenter.cn. On a Monday morning， you find the database instance aborted. After inspecting the alert log file， you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true？（）
    A

    PMON coordinates media recovery.

    B

    SMON coordinates instance recovery.

    C

    PMON coordinates instance recovery.

    D

    Undo Advisor would roll back all uncommitted transactions.

    E

    SQL*PLUS reports an error with the message asking you to perform instance recovery.


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

  • 第23题：

    多选题
    You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）
    A

    guarantee undo retention

    B

    add one more redo log group

    C

    size the redo log files appropriately

    D

    size the UNDO tablespace appropriately

    E

    size the SYSTEM tablespace appropriately

    F

    configure an appropriate undo retention interval

    G

    change automatic undo management to manual


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

  • 第24题：

    单选题
    You work as a database administrator for Certkiller .com. When you tried to connect to the database， you received the following error： ERROR：  ORA-12541：TNS：no_listener  You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener.  lsnrctl>START  What statement is true？（）
    A

    It would attempt to start the default listener

    B

    It would start the most recently created listener.

    C

    It would display an error with a message asking for the listener name to be specified.

    D

    It would show you a list of listeners and prompts for the listener name that you want to start.


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

相关内容