Which of the following statements about the FOREIGN KEY constraint is incorrect?
a. The constraint exists between two tables, called the parent table and the child table
b. When the constraint exists, by default a record cannot be deleted from the parent table if matching entries exist in the child table.
c. The constraint can reference any column in another table, even a column that has not been designated as the primary key for the referenced table.
d. When the keywords ON DELETE CASCADE are included in the constraint definition, a corresponding child record will automatically be deleted when the parent record is deleted.
c
You might also like to view...
With regression analysis used in location analysis, predictor variables are selected. Which of the following predictor variables would be more useful for a retailer who is contemplating opening a day care center than for a retailer of used books?
A. Average age of homes in trade area B. Average age of head of household C. Educational level of households D. Average number of cars in each household E. Number of households with children not attending school
A meta-analysis examined the degree to which positive leader-member exchanges encouraged subordinates to perform more organizational citizenship behaviors. This found that
a. paradoxically, positive leader-member exchanges were negatively related to organizational citizenship behaviors b. positive leader-member exchanges were unrelated to organizational citizenship behaviors (i.e., the correlation was basically zero) c. positive leader-member exchanges were positively related to organizational citizenship behaviors d. positive leader-member exchanges were curvilenearly related to organizational citizenship behaviors
Which of the following statements is true about net worth??
A. ?A firm's net worth should be higher than the stockholders' equity. B. ?A firm's net worth should be equal to 50 percent of the value of the total assets of the firm. C. ?A firm's net worth is equal to total assets minus total liabilities. D. ?On liquidation of a firm, the common stockholders' will receive the exact amount shown in the equity section of the balance sheet. E. ?The net worth of a firm is the amount to be paid by the shareholders to the firm on liquidation of the firm.
At issue in Verizon v. Federal Communications Commission was the Open Internet Order and the treatment of ISPs as common carriers
Indicate whether the statement is true or false