Determine a strategy for how you would correct records after running a find unmatched query.

What will be an ideal response?


In the case of locating an order for a customer in a related table that does exist in a primary table, check the customer table and the order table for a possible data entry error. Alternatively, add the missing customer to the customer table, if necessary, and attempt to enforce referential integrity between the tables.

Computer Science & Information Technology

You might also like to view...

Windows Server 2008 includes the concept of a delta CRL, which is a list of certificates that have been revoked since the last publication of a full CRL. By using delta CRLs, you can publish CRL information more frequently with less replication traffic. Delta CRLs are published on a(n) ______________ basis

a. Full b. Differential c. Incremental d. None of the above.

Computer Science & Information Technology

Screen elements that are part of the worksheet are modified only in that worksheet and not in other worksheets and workbooks.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

In a high-level language, the programmer's only responsibilities for managing data items are to declare (or in the case of Python, create) all constants and variables the program will use.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

In what type of document might a mirror margin be used?

A. Letter B. Business card C. Magazine D. Web page

Computer Science & Information Technology