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 reten

题目

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
相似考题

1.--What do you usually do at weekends?--- ____A. I play football with a group of friendsB. It's lovely. Thank youC. I started learning tennis when I was 6

2.When did you start to feel terrible?-I started to feel terrible when I( ) in the garden.A. was workingB. had workedC. would workD. had been working

3.A Windows Communication Foundation (WCF) service sends notifications when the service is started and stopped.You need to implement a client that logs these notifications. Which class should you use?()A. AnnouncementServiceB. AnnouncementClientC. DiscoveryClientD. HttpListener

4.It's high time you _____.A. start to workB. would start to workC. started to workD. had started to work

更多“You started a ”相关问题

  • 第1题：

    You have an existing Windows Communication Foundation (WCF) service. You need to ensure that other services are notified when the service is started.What should you do?()

    A.

    B.

    C.

    D.


    参考答案：D

  • 第2题：

    As a Pass Guide instructor you are giving a lecture on the historical context of Cisco. You point out that a computer scientist started the Cisco Corporation. One of the attendants asks you when and where Cisco was founded. What should you respond? （）

    A. 1978

    B. 1984

    C. 1991

    D. 1996

    E.Massachusetts Institute of Technology

    F.California Polytechnic Institute

    G.Harvard

    H.Stanford


    参考答案：B, H

  • 第3题：

    Before CPR is started，you should ______．

    A.Establish an open airway

    B.Treat any bleeding wounds

    C.Insure the victim is conscious

    D.Make the victim comfortable


    正确答案：A

  • 第4题：

    As a Pass Guide instructor you are giving a lecture on the historical context of Cisco. You point out that a computer scientist started the Cisco Corporation. One of the attendants asks you when and where Cisco was founded. What should you respond? （）

    • A、1978
    • B、1984
    • C、1991
    • D、1996
    • E、Massachusetts Institute of Technology
    • F、California Polytechnic Institute
    • G、Harvard
    • H、Stanford

    正确答案:B,H

  • 第5题：

    You issue these LSNRCTL commands：  LSNRCTL> SET CURRENT_LISTENER listener01 LSNRCTL> START listener02  What is the result of issuing these commands？（）

    • A、A listener named LISTENER is started.
    • B、A listener named LISTENER01 is started.
    • C、A listener named LISTENER02 is started.
    • D、The START command fails and no listener is started.

    正确答案:C

  • 第6题：

    A Windows Communication Foundation (WCF) service sends notifications when the service is started and stopped.You need to implement a client that logs these notifications. Which class should you use?（）

    • A、AnnouncementService
    • B、AnnouncementClient
    • C、DiscoveryClient
    • D、HttpListener

    正确答案:A

  • 第7题：

    单选题
    You are late! The discussion started minutes ago.（）
    A

    Well, I don't care.

    B

    Don't blame me.

    C

    I am really sorry.

    D

    That's great.


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

  • 第8题：

    单选题
    If you had started loading earlier，you（）loading now.
    A

    would finish

    B

    will have finished

    C

    would have finished

    D

    will be finished


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

  • 第9题：

    单选题
    Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.  Which tool or utility would you use to start the listener？（）
    A

     Oracle Net Manager

    B

     Listener Control utility

    C

     Database Configuration Assistant

    D

     Oracle Net Configuration Assistant


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

  • 第10题：

    单选题
    You work as a database administrator for Supportcenter.cn. In your production database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task？（）
    A

    You must have started the database instance in restricted mode.

    B

    You must have started the database instance inNORMALmode.

    C

    You must have started the database instance with server parameter file.

    D

    You must have started the database instance but must not have mounted.

    E

    You must have started the database instance but must not have opened.


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

  • 第11题：

    单选题
    You issue these LSNRCTL commands：  LSNRCTL> SET CURRENT_LISTENER listener01 LSNRCTL> START listener02  What is the result of issuing these commands？（）
    A

    A listener named LISTENER is started.

    B

    A listener named LISTENER01 is started.

    C

    A listener named LISTENER02 is started.

    D

    The START command fails and no listener is started.


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

  • 第12题：

    多选题
    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


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

  • 第13题：

    Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?()

    A. Oracle Net Manager

    B. Listener Control utility

    C. Database Configuration Assistant

    D. Oracle Net Configuration Assistant


    参考答案：B

  • 第14题：

    If you had started loading earlier，you ______ loading now．

    A.would finish

    B.will have finished

    C.would have finished

    D.will be finished


    正确答案：C

  • 第15题：

    You are late! The discussion started minutes ago.（）

    • A、Well, I don't care.
    • B、Don't blame me.
    • C、I am really sorry.
    • D、That's great.

    正确答案:C

  • 第16题：

    You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）

    • A、 The batch operation started by the user， SCOTT， terminates with an error.
    • B、 The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.
    • C、 The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.
    • D、 The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.
    • E、 The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.

    正确答案:A,D

  • 第17题：

    You work as a database administrator for Supportcenter.cn. In your production database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task？（）

    • A、You must have started the database instance in restricted mode.
    • B、You must have started the database instance inNORMALmode.
    • C、You must have started the database instance with server parameter file.
    • D、You must have started the database instance but must not have mounted.
    • E、You must have started the database instance but must not have opened.

    正确答案:C

  • 第18题：

    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 Dworks in the instance. You are log shipping the Adventureworks database to a remote SQL Server 2008 instance. The primary SQL Server instance required a restart during the weekend. But you notice that log shipping has stopped working after the weekend. You have to check log shipping of the Adventureworks database and find out the problem. What should you do? （） 

    • A、You should use the EXTENDED_LOGICAL_CHECKS option to execute a DBCC CHECKDB statement on the AdventureWorks database by. 
    • B、You should identify whether the SQL Server Agent is started on the primary server. 
    • C、You should identify whether the AdventureWorks database uses the Simple recovery model. 
    • D、You should identify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server

    正确答案:B

  • 第19题：

    单选题
    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 Dworks in the instance. You are log shipping the Adventureworks database to a remote SQL Server 2008 instance. The primary SQL Server instance required a restart during the weekend. But you notice that log shipping has stopped working after the weekend. You have to check log shipping of the Adventureworks database and find out the problem. What should you do? （）
    A

    You should use the EXTENDED_LOGICAL_CHECKS option to execute a DBCC CHECKDB statement on the AdventureWorks database by. 

    B

    You should identify whether the SQL Server Agent is started on the primary server. 

    C

    You should identify whether the AdventureWorks database uses the Simple recovery model. 

    D

    You should identify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server


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

  • 第20题：

    单选题
    You install the Web Server （IIS） role on a server that runs Windows Server 2008. Your companys default Web site has an IP address of 10.10.0.1.  You add a Web site named HelpDesk. The HelpDesk Web site cannot be started.You need to configure the Helpdesk Web site so that it can be started. What should you do？（）
    A

    Run the iisreset /enable command on the server.

    B

    Configure the Helpdesk Web site to use a host header.

    C

    Run the appcmd add site /name： HelpDesk /id：2 /physicalPath： c：/HelpDesk /binding：http/*：80：helpdesk command on the server.

    D

    Run the set-location Cliteralpath d：/HelpDesk_content HelpDesk ID://2 location port：80 domain：helpdesk command in the Microsoft Windows PowerShell tool on the server.


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

  • 第21题：

    单选题
    Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）
    A

    Oracle Net Manager

    B

    Listener Control utility

    C

    Database Configuration Assistant

    D

    Oracle Net Configuration Assistant


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

  • 第22题：

    多选题
    You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）
    A

    The batch operation started by the user， SCOTT， terminates with an error.

    B

    The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.

    C

    The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.

    D

    The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.

    E

    The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.


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

  • 第23题：

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

  • 第24题：

    多选题
    As a Pass Guide instructor you are giving a lecture on the historical context of Cisco. You point out that a computer scientist started the Cisco Corporation. One of the attendants asks you when and where Cisco was founded. What should you respond? （）
    A

    1978

    B

    1984

    C

    1991

    D

    1996

    E

    Massachusetts Institute of Technology

    F

    California Polytechnic Institute

    G

    Harvard

    H

    Stanford


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

相关内容