网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader directpath load method to perform this task. The table in which you plan to load data is an important tablehaving various integrity constraints defined on it. Which constraints will remain enabled by default during this operation（）
- A、CHECK
- B、UNIQUE
- C、NOT NULL
- D、PRIMARY KEY
- E、FOREIGN KEY
参考答案
更多 “ You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader directpath load method to perform this task. The table in which you plan to load data is an important tablehaving various integrity constraints defined on it. Which constraints will remain enabled by default during this operation（）A、CHECKB、UNIQUEC、NOT NULLD、PRIMARY KEYE、FOREIGN KEY” 相关考题
考题
Some of you may have finished unitone, _______, you can move onto unit two.
A、if you mayB、if you doC、if notD、if so
考题
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.
考题
Your Windows 2000 Professional computer contains a single hard disk configured as a single partition.You want to move a folder named Sales under a folder named Corp on your computer.You want the files in the Sales folder to remain compressed after moving the folder. You want the files in the Corp folder to remain uncompressed. You want to ensure that the files are recoverable in case of any disk problems. You also want to move the files with the least amount of administrative effort.What should you do?A．Copy the Sales folder to the Corp folder. Do nothing further.B．Backup the Sales folder. Move the Sales folder to the Corp folder.C．Compress the Corp folder. Then copy the Sales folder to the Corp folder.D．Move the Sales folder to a second computer. Then move the Sales folder to the Corp folder.
考题
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.
考题
不要随意地移动稳索。（）A、Don’t shift the guy as you like.B、Don’t shift the stay as you like.C、Don’t move the derrick as you like.D、Don’t move the crane as you like.
考题
You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation. Which method would you use to load data into the Oracle database（）A、Use the external table population.B、Use the Oracle Data Pump export and import utility.C、Use the conventional path data load of the SQL*Loader utility.D、Use the INSERT INTO...SELECT command to load the data
考题
Which service components develops a plan that identifies the necessary steps to move from an existing system to the Cisco Unified Communications system（）A、Migration Plan DevelopmentB、Detailed Design DevelopmentC、Staging Plan DevelopmentD、Implementation Plan Development
考题
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 an Exchange Server 2010 server that has a single mailbox database named DB1.You need to move the transaction log files of DB1.Which cmdlet should you run？（）A、Move-DatabasePathB、Move-MailboxC、Set-ExchangeServerD、Set-MailboxDatabase
考题
You have an Exchange Server 2010 Service Pack 1 （SP1） server that hosts a public folder database named PUBLIC.You need to move the transaction log files of PUBLIC. Which cmdlet should you run？（）A、Move-DatabasePathB、Move-StorageGroupPathC、Set-PublicFolderDatabaseD、Set-MailPublicFolder
考题
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.
考题
单选题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.
考题
单选题Move Plan are experts at organizing both large and small moves.A
Right.B
Wrong.C
Doesn’t say.
考题
多选题You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on it. Which constraints will remain enabled by default during this operation（）ACHECKBUNIQUECNOT NULLDPRIMARY KEYEFOREIGN KEY
考题
单选题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 create a virtual machine （VM） on a Windows Server 2008 R2 Hyper-V server. You plan to use this VM as the base image for new VMs. You need to ensure that you can import the base image multiple times on the original host server. In the Import Virtual Machine Wizard，which settings should you configure during each import process？（）A
Select the Copy the virtual machine option and the Duplicate all files check box.B
Select the Copy the virtual machine option. Clear the Duplicate all files check box.C
Select the Move or restore the virtual machine option and the Duplicate all files check box. D
Select the Move or restore the virtual machine option. Clear the Duplicate all files check box.
考题
单选题The servers on your network run Windows Server 2008 R2. You are planning a two-node Hyper-V failover cluster with SAN storage， and 16 virtual machines （VMs）. You plan to use quick migration. You need to place the maximum number of VMs on each logical unit number （LUN）. You need to ensure that you can move individual VMs between cluster nodes without affecting other VMs. How many VMs should you place on each LUN？（）A
oneB
twoC
fourD
eight
考题
单选题You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）A
use the external table populationB
use the Oracle Data Pump export and import utilityC
use the conventional path data load of SQL*Loader utilityD
use the direct path data load of Oracle export and import utility
考题
单选题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
考题
单选题Thank you for the______ you did me to move the sofa upstairs.A
favorB
goodC
offerD
aid
热门标签
最新试卷
