In Oracle, if you have two tables related by connecting a primary key in table B and a foreign key in table A, how does the database behave during the insertion of a new record into table A? Question 45 options: 1) It creates a new primary key attribute that is automatically numbered as a sequence of numeric values. 2) It prevents foreign key values from being duplicated in table A. 3) It prevents any records from being deleted from either Table A or Table B. 4) It prevents a row from being inserted into table A if the data in the foreign key column of table A doesn't match any of the values in the primary key column of the table B.

In Oracle, if you have two tables related by connecting a primary key in table B and a foreign key in table A, how does the database behave during the insertion of a new record into table A? Question...

In Oracle, if you have two tables related by connecting a primary key in table B and a foreign key in table A, how does the database behave during the insertion of a new record into table A?

Question 45 options:

1)	It creates a new primary key attribute that is automatically numbered as a sequence of numeric values.

2)	It prevents foreign key values from being duplicated in table A.

3)	It prevents any records from being deleted from either Table A or Table B.

4)	It prevents a row from being inserted into table A if the data in the foreign key column of table A doesn't match any of the values in the primary key column of the table B.

Jun 06, 2022

SOLUTION.PDF

In Oracle, if you have two tables related by connecting a primary key in table B and a foreign key in table A, how does the database behave during the insertion of a new record into table A? Question...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment