In an Append query, what happens to any records that violate the Primary key (or any other) rule?
A. The query pauses at each violating record and allows you to fix the error(s).
B. A message box appears telling you that you must fix the problematic records before the query can be run.
C. New Primary key values are added to the records
D. The records are rejected.
Answer: D
You might also like to view...
A database that contains contact information for students and movie DVD information is a good design
Indicate whether the statement is true or false
You are working on a report for a data storage firm. The report details the sales performance of the firm for the past 3 years. You decide to create a table to display the information. Describe how to delete a row or column in your table.
What will be an ideal response?
A property identifies a value required by a procedure that must be passed into the procedure when it is called.
Answer the following statement true (T) or false (F)
Which of the following protocols is MOST commonly used for the transfer of router configuration files?
A. SSL B. TFTP C. DNS D. IMAP