单选题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？（）ADrop the foreign key. Import the data by using the script. Re-create the foreign key.BCreate a CHECK constraint.CCreate a DML INSTEAD OF trigger that writes the failed records to a file or table.DCreate a DML AFTER trigger that writes the failed records to a file or table.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
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 deliverablesB.Customer-furnished equipment and facilitiesC.Long-lead procurement itemsD.Customer-imposed milestonesE.Other subcontractor interface requirements
● 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 deliverablesB Customer-furnished equipment and facilitiesC Long-lead procurement itemsD Customer-imposed milestonesE Other subcontractor interface requirements
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.
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.
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 solutionB、 analyzes the customer’s business requirements and recommends the appropriate Cisco technologies to meet business requirementsC、 finding out what end-user training a customer requiresD、 finding out a customer’s physical requirements
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.
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 outagesB、Optimizing the efficiency with which IT operatesC、An increased need for specialized IT silosD、IT systems grow fast
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.
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
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 ManualB、Announcement LetterC、Site and Hardware Planning InformationD、Adapter， Devices， and Cable Information for Multiple Bus Systems
You are designing an n-tier Java EE application. You have already decided that some of your JSPs willneed to get data from a Customer entity bean. You are trying to decide whether to use a Customer stubobject or a Transfer Object. Which two statements are true？（）A、The stub will increase network traffic.B、The Transfer Object will decrease data staleness.C、The stub will increase the logic necessary in the JSPs.D、In both cases， the JSPs can use EL expressions to get data.E、Only the Transfer Object will need to use a Business Delegate.
Which statements are true regarding the Oracle Data Pump export and import operations（）A、You cannot export data from a remote database.B、You can rename tables during an import operation.C、You can overwrite existing dump files during an export operation.D、You can compress the data during export but not the metadata because it is not supported
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.
Which two statements are true regarding the Oracle Data Pump export and import operations（）A、You cannot export data from a remote database.B、You can rename tables during an import operation.C、You can overwrite existing dump files during an export operation.D、You can compress the data during export but not the metadata because it is not supported.
You work with a SQL Server 2005 database that provides banking information for customers. You want customers to see banking reports that combine data that is retrieved from the database with real-time investment information that comes from a Web service provided by a third party. The investment information must be current when the reports are executed. You need to create the appropriate objects that support the reports. What should you do？（）A、Publish the data in the database as an XML Web service by using the FOR XML AUTO clause.B、Create a table to store the banking information for each customer. Create a trigger that fires when data is inserted into the table that joins with the data coming from the Web service.C、Create a Transact-SQL stored procedure that uses a temporary table to store the banking information for each customer. Update the table with the values from the Web service.D、Have a developer in TestKing.com create an assembly that calls the remote Web service.Create a CLR function by using the assembly. Call the CLR function and combine the results with banking information in the database.
Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）A、 Create a FOR trigger. B、 Create an INSTEAD OF trigger. C、 Create an AFTER trigger. D、 Create a DDL trigger.
单选题Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）A Create a FOR trigger. B Create an INSTEAD OF trigger. C Create an AFTER trigger. D Create a DDL trigger.
单选题Customer: I’d like to mail this box to California. Clerk: ______ Customer: Gee, I don’t know about that. What do you have? Clerk: Airmail and surface mail. Customer: I guess surface mail is fine.ADo you want to insure it?BHow do you want to mail it?CWhat can I do for you?DWhere will you mail to?
单选题You work in Dublin at the main office of TestKing.com. You are responsible for managing a SQL Server 2005 database. The sales department wants a report that compares customer activity in the previous quarter between the main office in Dublin and the branch office in Buenos Aires. They want the data sorted by surname and first name.You restore a recent backup of the Buenos Aires database onto your server. You write queries to build the report， ordering the data by the Surname and FirstName columns. You review the data and notice that the customer list from the Buenos Aires database is sorted differently. The sales department needs the revised data within 15 minutes for a presentation. You need to implement the fastest possible solution that ensures that the data from both databases is sorted identically. What should you do？（）AUse the Copy Database Wizard to copy the data in the Buenos Aires database to a new database with the same collation as the Dublin database.BUse the SQL Server Import and Export Wizard to copy the data from the Buenos Airesdatabase into new tables， specifying the same collation as the Dublin database.CModify the format file to specify the same collation as the Dublin database. Import the table again.DModify the query on the Buenos Aires database to use the COLLATE setting in the ORDER BY clause. In the query， specify the same collation as the Dublin database.
多选题You are designing an n-tier Java EE application. You have already decided that some of your JSPs willneed to get data from a Customer entity bean. You are trying to decide whether to use a Customer stubobject or a Transfer Object. Which two statements are true？（）AThe stub will increase network traffic.BThe Transfer Object will decrease data staleness.CThe stub will increase the logic necessary in the JSPs.DIn both cases， the JSPs can use EL expressions to get data.EOnly the Transfer Object will need to use a Business Delegate.
多选题TestKing.com uses a SQL Server 2005 database. This database contains a trigger named trg InsertOrders， which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal？（）AALTER TABLE OrdersDISABLE TRIGGER trg InsertOrdersBDROP TRIGGER trg InsertOrdersCDISABLE TRIGGER trg InsertOrders ON OrdersDALTER TRIGGER trg InsertOrders ON Orders NOT FOR REPLICATION
单选题You created a tabular report for the sales department to display each customer and the sales person assign to the customer. The data is sorted by customer using the order by clause in this query. This is department manager asks you to alter the report so that data is sorted by sales person rather than by customer. What is the best way to make the needed change?（）ARecreate the query and default the layout. BAlter the query, default the layout and redo the boiler plates. CQuery and manually change the layout to save the boiler plate. DAlter the query and make no further change.
单选题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
单选题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 solutionB analyzes the customer’s business requirements and recommends the appropriate Cisco technologies to meet business requirementsC finding out what end-user training a customer requiresD finding out a customer’s physical requirements
多选题The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) The CUSTOMER_ID column is the primary key for the table. Which two statements find the number of customers?（）ASELECT TOTAL(*) FROM customer;BSELECT COUNT(*) FROM customer;CSELECT TOTAL(customer_id) FROM customer;DSELECT COUNT(customer_id) FROM customer;ESELECT COUNT(customers) FROM customer;FSELECT TOTAL(customer_name) FROM customer;
单选题The pSeries sales representative has done an excellent job in educating the customer on the benefits of working with IBM. The customer is planning to implement their first ERP application. This new application will be critical to running their business. The customer has only a competitor’s UNIX systemcurrently installed. They are interested in obtaining a proposal from IBM. In addition to the AIX hardware and HACMP software， what else should be included in the IBM proposal for the new ERP solution？（）AI/T services and education to help with the implementation of the hardware and softwareBA Supportline specialist to work directly with the customer to manage any issues that ariseCThe services required to move the currently installed applications from the competitor’s systems to the IBM systemsDA slimmed down solution to ensure that the IBM solution is less expensive than the competitor’s solution
多选题You are the network consultant from passguide.com. In which situation you will advice your customer to implement data centers?（）AAn increased need for specialized IT silosBProtecting the business from information outagesCIT systems grow fastDOptimizing the efficiency with which IT operates
单选题You design a Business Intelligence （BI） solution by using SQL Server 2008. You design a SQL Server 2008 Analysis Services （SSAS） solution. Customer data is stored in the tables named CustomerDetails and CustomerContact. The solution uses the following two data sources from two different servers： ·Contoso that accesses the CustomerDetails table ·ContosoCRM that accesses the CustomerContact table You plan to create a dimension named DimCustomer to analyze customer data. You need to ensure that the DimCustomer dimension represents the tables as a snowflake schema to include attributes from the two tables. What should you do？（）A Create a data source view named DsvContoso that is associated with the two data sources and add the tables to the data source view.B Create a data source view named DsvContoso that is associated with the two data sources and create a named query in the data source view to merge the tables.C Create a data source view named DsvCustomer that is associated with the Contoso data source and add the CustomerDetails table to the data source view.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and add the CustomerContact table to the data source view.D Create a data source view named DsvCustomer that is associated with the Contoso data source and create a named query in the data source view to select data from the CustomerDetails table.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and create a named query in the data source view to select data from the CustomerContact table.