护理学章节练习

单选题You are planning to import customer data from the Customer table and the Country table in your SQL Server 2000 database into a SQL Server 2005 database. You want to ensure that during the import process,each value in the CountryCode column of the Custo

题目
单选题
You are planning to import customer data from the Customer table and the Country table in your SQL Server 2000 database into a SQL Server 2005 database. You want to ensure that during the import process,each value in the CountryCode column of the Customer table has a corresponding record in the CountryCode column in the Country table of the SQL Server 2005 database. You define a foreign key between these two tables. Thus,referential integrity will guarantee that the import routine fails if there are any records where a CountryCode value does not exist in the Country table but does exist in the Customer table. You need to ensure that the import process does not fail if records are encountered that do not exist in the Country table. What should you do?()
A

Drop the foreign key. Import the data by using the script. Re-create the foreign key.

B

Create a CHECK constraint.

C

Create a DML INSTEAD OF trigger that writes the failed records to a file or table.

D

Create a DML AFTER trigger that writes the failed records to a file or table.

如果没有搜索结果,请直接 联系老师 获取答案。
如果没有搜索结果,请直接 联系老师 获取答案。
相似问题和答案

第1题:

As you start writing, new ideas will naturally emerge, but always keep them focused on your targeted customer, so you won't go off the track of what your customer wants.


正确答案:在你开始写作的时候,会自然地产生新的想法,但是一定要使这些想法集中在你的目标顾客之上,这样你才不会偏离顾客的需求。

第2题:

You are Cisco Channel Partner Account Manager. Which service component within the preparephase recommends the appropriate technology strategy to address a business requirement of the customer?()

  • A、 finding out what a customer requires from a proposed solution
  • B、 analyzes the customer’s business requirements and recommends the appropriate Cisco technologies to meet business requirements
  • C、 finding out what end-user training a customer requires
  • D、 finding out a customer’s physical requirements

正确答案:B

第3题:

You have been assigned as a project leader and must first review the statement of work provided by the customer. Which of the following is most often overlooked?

A.Data item deliverables

B.Customer-furnished equipment and facilities

C.Long-lead procurement items

D.Customer-imposed milestones

E.Other subcontractor interface requirements


正确答案:A

第4题:

A customer has 5 older POWER5 systems and they want to consolidate them onto a POWER6 system. What information is important to analyze when deciding how to design the new machine using the System Planning Tool?()

  • A、 vmstat and iostat data from the older machines 
  • B、 The number of CPUs that were installed in the original machines 
  • C、 Data from Workload Estimator (WLE) and IBM Performance Management (PM) 
  • D、 Performance data that is collected from the new system after it has been put into production

正确答案:C

第5题:

You are the network consultant from passguide.com. In which situation you will advice your customer to implement data centers?()

  • A、Protecting the business from information outages
  • B、Optimizing the efficiency with which IT operates
  • C、An increased need for specialized IT silos
  • D、IT systems grow fast

正确答案:A,B,D

第6题:

Which three statements are true about Oracle Data Pump export and import operations?()

A. You can detach from a data pump export job and reattach later.

B. Data pump uses parallel execution server processes to implement parallel import.

C. Data pump import requires the import file to be in a directory owned by the oracle owner.

D. The master table is the last object to be exported by the data pump.

E. You can detach from a data pump import job and reattach later.


参考答案:A, B, D

第7题:

You are planning to import customer data from the Customer table and the Country table in your SQL Server 2000 database into a SQL Server 2005 database. You want to ensure that during the import process,each value in the CountryCode column of the Customer table has a corresponding record in the CountryCode column in the Country table of the SQL Server 2005 database. You define a foreign key between these two tables. Thus,referential integrity will guarantee that the import routine fails if there are any records where a CountryCode value does not exist in the Country table but does exist in the Customer table. You need to ensure that the import process does not fail if records are encountered that do not exist in the Country table. What should you do?()

  • A、Drop the foreign key. Import the data by using the script. Re-create the foreign key.
  • B、Create a CHECK constraint.
  • C、Create a DML INSTEAD OF trigger that writes the failed records to a file or table.
  • D、Create a DML AFTER trigger that writes the failed records to a file or table.

正确答案:C

第8题:

● You have been assigned as a project leader and must first review the statement of work provided by the customer. Which of the following is most often overlooked?

A Data item deliverables

B Customer-furnished equipment and facilities

C Long-lead procurement items

D Customer-imposed milestones

E Other subcontractor interface requirements


正确答案:A

第9题:

A customer is planning to migrate a financial application to a 12-way p5-570 system with 96GB of memory.  The application data is stored on an ESS Model 800 attached to a p670 server with AIX 5.2.  They will have a short outage window to perform the data migration.  What is the quickest way to move all the data stored on the attached ESS from the p670 to the new p5-570?()

  • A、Use rsync to synchronize the data across servers.
  • B、Use exportvg and importvg to move the data to the target system.
  • C、Use NFS to copy the data from the source system to the target system.
  • D、Backup the data from the source system and restore to the target system.

正确答案:B

第10题:

A customer is getting ready to install a new pSeries system into their data center.  They are concerned about providing the appropriate clearance around their 7014-T42 to allow for maintenance.  What reference material should the pSeries technical specialist provide to the customer?()

  • A、Sales Manual
  • B、Announcement Letter
  • C、Site and Hardware Planning Information
  • D、Adapter, Devices, and Cable Information for Multiple Bus Systems

正确答案:C

更多相关问题