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
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
相关考题：
--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
It's high time you _____.A. start to workB. would start to workC. started to workD. had started to work
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
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
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.
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 ManagerB. Listener Control utilityC. Database Configuration AssistantD. Oracle Net Configuration Assistant
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. 1978B. 1984C. 1991D. 1996E.Massachusetts Institute of TechnologyF.California Polytechnic InstituteG.HarvardH.Stanford
If you had started loading earlier，you ______ loading now．A.would finishB.will have finishedC.would have finishedD.will be finished
Before CPR is started，you should ______．A.Establish an open airwayB.Treat any bleeding woundsC.Insure the victim is consciousD.Make the victim comfortable
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.
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、1978B、1984C、1991D、1996E、Massachusetts Institute of TechnologyF、California Polytechnic InstituteG、HarvardH、Stanford
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.
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.
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.
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
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
单选题You are late! The discussion started minutes ago.（）AWell, I don't care.BDon't blame me.CI am really sorry.DThat's great.
单选题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? （）AYou should use the EXTENDED_LOGICAL_CHECKS option to execute a DBCC CHECKDB statement on the AdventureWorks database by. BYou should identify whether the SQL Server Agent is started on the primary server. CYou should identify whether the AdventureWorks database uses the Simple recovery model. DYou should identify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server
单选题If you had started loading earlier，you（）loading now.Awould finishBwill have finishedCwould have finishedDwill be finished
单选题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？（）ARun the iisreset /enable command on the server.BConfigure the Helpdesk Web site to use a host header.CRun the appcmd add site /name： HelpDesk /id：2 /physicalPath： c：/HelpDesk /binding：http/*：80：helpdesk command on the server.DRun 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.
单选题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 ManagerB Listener Control utilityC Database Configuration AssistantD Oracle Net Configuration Assistant
单选题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?（）AOracle Net ManagerBListener Control utilityCDatabase Configuration AssistantDOracle Net Configuration Assistant
单选题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？（）AYou must have started the database instance in restricted mode.BYou must have started the database instance inNORMALmode.CYou must have started the database instance with server parameter file.DYou must have started the database instance but must not have mounted.EYou must have started the database instance but must not have opened.
多选题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？（）AThe batch operation started by the user， SCOTT， terminates with an error.BThe batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.CThe batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.DThe user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.EThe user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.
单选题You issue these LSNRCTL commands： LSNRCTL SET CURRENT_LISTENER listener01 LSNRCTL START listener02 What is the result of issuing these commands？（）AA listener named LISTENER is started.BA listener named LISTENER01 is started.CA listener named LISTENER02 is started.DThe START command fails and no listener is started.
多选题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？（）AApplication Server ControlBOracle Management ServiceCOracle Enterprise Manager RepositoryDOracle Enterprise Manager Database Control
多选题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？（）Aguarantee undo retentionBadd one more redo log groupCsize the redo log files appropriatelyDsize the UNDO tablespace appropriatelyEsize the SYSTEM tablespace appropriatelyFconfigure an appropriate undo retention intervalGchange automatic undo management to manual
多选题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? （）A1978B1984C1991D1996EMassachusetts Institute of TechnologyFCalifornia Polytechnic InstituteGHarvardHStanford