Drop the foreign key. Import the data by using the script. Re-create the foreign key.
Create a CHECK constraint.
Create a DML INSTEAD OF trigger that writes the failed records to a file or table.
Create a DML AFTER trigger that writes the failed records to a file or table.
第1题:
第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?()
第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
第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?()
第5题:
You are the network consultant from passguide.com. In which situation you will advice your customer to implement data centers?()
第6题:
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.
第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?()
第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
第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?()
第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?()