Question: If a Table A has a foreign key column that refers to the primary key of Table B , and every value of a primary

If a Table A has a foreign key column that refers to the primary key of Table B, and every value of a primary key in Table B is referred to by at least one row in a Table A, than no record in Table B can be
deleted, if DELETE RESTRICT option in effect.
True
False

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Q:

Observe the HOMETOWN REALESTATE database: SELLER Sellers S111 S222 S333 S444 S555 C666 .C777 SellerName Paul Carly Ana Charlotte Aidan Eric Christina Realtorld R1 R1 R2 R2 R3 R1 R1 REALTOR RealtorID...

Q:

COMPUTER BUSINESS In computer business basically we are trying to sell computer products. So for that we have several tables to make our system more dynamic. The basic tables needed are, login table...

Q:

Which of the following is correct when joining two tables using an inner join ( equijoin ) ? Group of answer choices You can join using any two columns as long as one column is from one table and the...

Q:

Dropping a table fails when a foreign key constraint refers to the table's primary key. Before dropping the table, either the foreign key constraint or the foreign key table must be dropped.

Q:

If the "restrict" option is chosen when enforcing the Referential Integrity rule, what happens when a user tries to delete a primary key value that is NOT referenced in the foreign key column? DBMS...

Q:

Which of the following is NOT one of the characteristics of a relational table? each table column is called a field. each row is called a record. each table must have a foreign key. each table must...

Q:

multiple choice 13. Which of the following statement is correct regarding internal control ? A) A well-designed and operated internal control environment should detect collusion perpetrated by two...

Q:

You are given a task to create a Database for Holiday Inn. Here is some of the information you have. HOTEL hNum: It is a unique id assigned to each hotel hNoOfRooms: Number of rooms in a hotel...

Q:

SQL -- Classic Models Database NetBeans: Select the latest version of NetBeans and start it. Open the Services window (available from the window menu in NetBeans) Right-click Java DB and start the...

Q:

SQl language Lab Exercises First: - Create the following tables: 1.CREATE TABLE access_control group access control_group_id number (10) primary key NOT NULL, access control groupname varchar2 (255)...

Q:

Explain what is meant by the following quote: Organizations must either globalize or they will die.

Q:

Thad acquires a machine at a cost of $502,000 for use in his business and places it in service on April 1, 2010. The machine is depreciated under MACRS, with a 7-year recovery period. This machine...

Q:

If the Sailor is onboard and also listed in the EXPIRED section of the Prospective Gain report, and the gain event has NOT been submitted, what should you do ?

Q:

Given the functions f x 2x g x 3x 1 h x 4x 5x 2 evaluate h 5 h 5 digite sua resposta