网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

You plan to execute the following command to perform a Flashback Database operation in your database:   SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24);   Which two statements are true about this?()

  • A、 The database must have multiplexed redo log files
  • B、 The database must be in the MOUNT state to execute the command
  • C、 The database must be in the NOMOUNT state to execute the command
  • D、 The database must be opened in RESTRICTED mode before this operation
  • E、 The database must be opened with the RESETLOGS option after the flashback operation

参考答案

更多 “ You plan to execute the following command to perform a Flashback Database operation in your database:   SQL FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24);   Which two statements are true about this?()A、 The database must have multiplexed redo log filesB、 The database must be in the MOUNT state to execute the commandC、 The database must be in the NOMOUNT state to execute the commandD、 The database must be opened in RESTRICTED mode before this operationE、 The database must be opened with the RESETLOGS option after the flashback operation” 相关考题
考题 Regarding the extended ping command; which of the statements below are true?(Select all valid answer choices)A.The extended ping command is supported from user EXEC mode.B.The extended ping command is available from privileged EXEC mode.C.With the extended ping command you can specify the TCP and UDP port to be pinged.D.With the extended ping command you can specify the timeout value.E.With the extended ping command you can specify the datagram size.

考题 What do you plan_________(be) in the future?

考题 It will enable you to plan your activities so that you have adequate time for both work and play.

考题 You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?()A. The tuned plan is not added to the SQL plan baseline.B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.

考题 Why do you plan to change your job?

考题 ______you carry out this plan, you will benefit from it.A. If onlyB. Only ifC. WereD. Unless

考题 Building a house costs quite a lot of money. Suppose you plan to build a house. Your first step will be to find a right piece of land. Your choice will depend on many different things. You will probably try to find a sunny place, with pleasant surroundings near shops and bus stops, not too far from your friends and the place where you work. Next you will find a good builder, and together with the builder you will work out a plan. The builder will draw the plan. It will show the number of rooms, their position and size, and other parts, which must be noticed, such as windows, doors, and electric outlets. The builder will work out how much money is needed to build your house. He will work out the cost of the wood, bricks, the glass, and everything else that must be used in building the house. Later on, when he starts to build, this estimate must be corrected and revised. His estimate is based on existing prices, but prices of such things may change, and many other things may happen between the time when he makes the estimate and the time when he builds the house. When the builder gives his estimate, you may wish to change your plan. (You may also wish to change your builder, if his estimate is too high! ) You may find that the house you wanted at first costs too much, or that you can spend a little more and add something to your plan. The builder's estimate depends on the plan, but the final plan depends on the builder's estimate. What is the relationship between the estimate and the plan?A.The plan depends on the estimate B.The estimate depends on the plan C.The plan has nothing to do with the estimate D.The estimate and the plan depend on each other

考题 Do you have any plan this year?()AHow about you?BI plan to go to the United States for further studies.CYes, I will.DI'm certainly not going to do that kind of thing.

考题 The Database Resource Manager is not currently active in your database that is up and running. You created a resource plan named DAY_PLAN that contains two sub-plans named MANAGERS_PLAN and CLERKS_PLAN. You decided to activate DAY_PLAN by executing the following statement:       SQLALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ’managers_plan’;  What will be the outcome of this statement?()  A、 The statement will deactivate DAY_PLAN.B、 The statement will activate DAY_PLAN as the top plan.C、 The statement will activate MANAGERS_PLAN as the top plan.D、 The statement will return an error because MANAGERS_PLAN is not the top plan.

考题 Using Oracle Scheduler you have scheduled two jobs, JOB_A and JOB_B, to run at 9:00 p.m. every Friday. You want both the jobs to use a single resource plan, WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective?()A、 A window must have been created with the WEEKEND_PLAN resource plan.B、 A program must have been created with the WEEKEND_PLAN resource plan.C、 A job class must have been created with the WEEKEND_PLAN resource plan.D、 A windows group must have been created with the WEEKEND_PLAN resource plan.

考题 You have a virtual machine named VM1. You install Windows Server 2012 R2 on VM1. You plan to use VM1 as an image that will be distributed to sales users to demonstrate the features of a customapplication. The custom application only requires the Web Server (IIS) server role to be installed.You need to ensure that the VHD file for VM1 only contains the required Windows Server 2012 R2 source files. Which tool should you use?()A、dism.exeB、ocsetup.exeC、Imagex.exeD、servermanagercmd.exe

考题 You plan to deploy Windows 7 images. You need ensure that you can deploy images by using the WindowsPreinstallation Environment (Windows PE).  What should you do add to the Windows PE image?()A、Imagex.exeB、Loadstate.exeC、Mighost.exeD、Usmtutils.exe

考题 Your virtual environment includes Windows Server 2008 R2 Hyper-V servers. You plan to deploy Microsoft Virtual Desktop Infrastructure. You plan to scale both static and dynamic deployments across several servers. You need to design a plan that supports static and dynamic deployments and that allows for capacity growth without outages. What should you include in your plan?()A、Use the Remote Desktop Connection Broker and failover clusteringB、Use the Remote Desktop Gateway and network load balancingC、Use network load balancing and failover clusteringD、Use DNS round-robin and network load balancing

考题 You need to configure the power settings of your portable computer so that the display turns off when it is inactive and running on battery power. You also need to ensure that the power settings of the hard disk remain unaffected.  What should you do?()A、Change the advanced power settings of the Balanced power plan.B、Configure the portable computer to use the Power saver power plan.C、Configure the portable computer to use the High performance power plan.D、Restore the Power Saver power plan to the default settings.

考题 You have a server named Server1 that runs Windows Server 2012 R2. You plan to create an image of Server1. You need to remove the source files for all server roles that are not installed on Server1. Which tool should you use?()A、servermanagercmd.exeB、imagex.exeC、dism.exeD、ocsetup.exe

考题 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which contains a database. Now your company CIO assigns a task to you. You have to check the performance of the SQL Server 2008 instance. You have to find out which common language runtime (CLR) queries takes the longest-running time.  So in the options below, which dynamic management view should you choose to use?()  A、sys.dm_os_wait_stats B、sys.dm_exec_requests C、sys.dm_exec_sessions D、sys.dm_exec_query_stats

考题 You work in a company which 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 DB1 in the instance. You put forward a database maintenance plan. The maintenance plan rebuilds indexes, checks database integrity, writes a report to a text file. Now the company requires that when the maintenance plan executes abnormally, the operators can be notified by an e-mail message. You've been assigned this task. So you have to make modifications on the SQL Server instance. What should you do?()A、For the SQL Server Agent, you should enable a fail-safe operator B、You should modify the database maintenance plan, making it send an e-mail to the appropriate operators C、You should modify the database maintenance plan, making it include a Notify Operator task that e-mails the appropriate operators. D、You should modify the SQL Server Agent job. The job executes the database maintenance plan to notify the appropriate operators.

考题 单选题The Database Resource Manager is not currently active in your database that is up and running. You created a resource plan named DAY_PLAN that contains two sub-plans named MANAGERS_PLAN and CLERKS_PLAN. You decided to activate DAY_PLAN by executing the following statement:       SQLALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ’managers_plan’;  What will be the outcome of this statement?()A  The statement will deactivate DAY_PLAN.B  The statement will activate DAY_PLAN as the top plan.C  The statement will activate MANAGERS_PLAN as the top plan.D  The statement will return an error because MANAGERS_PLAN is not the top plan.

考题 单选题What you’ve told me of your plan sounds most interesting; would you care to _____ on it?A elaborateB explainC stressD interrupt

考题 单选题You execute the following block of code:   SQLBEGIN   DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN   ( SIMPLE_PLAN = ’DEPARTMENTS’,   CONSUMER_GROUP1 = ’PAYROLLL’,   GROUP1_CPU = 50,   CONSUMER_GROUP2 = ’SALES’,   GROUP2_CPU = 25,   CONSUMER_GROUP3 = ’MARKETING’,   GROUP3_CPU = 25);   END;   SQL/   What is a prerequisite for using the simple resource plan created by executing the above code?()A  You must assign users to consumer groups.B  You must grant the switch privilege to the users.C  You must create a resource plan directive.D  You must specify the complex resource plan.

考题 单选题You are planning a new VLAN-based network solution.  What is one item you should consider when creating your implementation plan as it concerns VLANs?()A generic router and switch configuration parametersB end-to-end test plan after all components have been installed and  configuredC administrator assignmentsD rollback plan

考题 单选题What do you want the original plan()?A forB onC toD with

考题 单选题Do you have any plan this year?()A How about you?B I plan to go to the United States for further studies.C Yes, I will.D I'm certainly not going to do that kind of thing.

考题 单选题Using Oracle Scheduler you have scheduled two jobs, JOB_A and JOB_B, to run at 9:00 p.m. every Friday. You want both the jobs to use a single resource plan, WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective?()A  A window must have been created with the WEEKEND_PLAN resource plan.B  A program must have been created with the WEEKEND_PLAN resource plan.C  A job class must have been created with the WEEKEND_PLAN resource plan.D  A windows group must have been created with the WEEKEND_PLAN resource plan.

考题 单选题You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?()A The tuned plan is not added to the SQL plan baseline.B The tuned plan is added to the fixed SQL plan baseline as a fixed plan.C The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.D The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.

考题 单选题You have created a resource plan, DB_PLAN, using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan?()A  assign users to consumer groupsB  set the resource plan for the instanceC  configure a simple resource plan and specify plan directivesD  configure a complex resource plan and specify plan directives

考题 单选题You work in a company which 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 DB1 in the instance. You put forward a database maintenance plan. The maintenance plan rebuilds indexes, checks database integrity, writes a report to a text file. Now the company requires that when the maintenance plan executes abnormally, the operators can be notified by an e-mail message. You've been assigned this task. So you have to make modifications on the SQL Server instance. What should you do?()A For the SQL Server Agent, you should enable a fail-safe operator B You should modify the database maintenance plan, making it send an e-mail to the appropriate operators C You should modify the database maintenance plan, making it include a Notify Operator task that e-mails the appropriate operators. D You should modify the SQL Server Agent job. The job executes the database maintenance plan to notify the appropriate operators.

考题 单选题You have created a resource plan, DB_PLAN, using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users.   Which step must be performed before you can start using the resource plan?()A assign users to consumer groupsB set the resource plan for the instanceC configure a simple resource plan and specify plan directivesD configure a complex resource plan and specify plan directives