Question

True or False questions:

1. A data type mismatch error would occur when the primary key data data type is auto number and the foreign key in the related table is number.

2. The data type long integer is the same as integer.

3. When using SQL, the SELECT clause isolates tables in the database.

4. A Referential Integrity violation occur when the primary key is null.

5. When an REA model has 7 entities ,2 linking tables, 3 Resource tables, and a total of 5 Master tables - the number of Agent tables is 3

Answer 1

Dear Student ,

As per the requirement submitted above , kindly find the below solution.

Question 1:

Answer :False

Explanation :

• When primary key is having data type as auto number then foreign key in the related table will not be auto number
• Because for a one table only one column can be autonumber.
• and hence need to use data type as number for foreign key in related table
• It will not result in type mismatch error.

********************************

Question 2:

Answer :True

Explanation :

• long integer is same as integer this means which can hold the hole numbers.
• Only difference is in the size and rang of the data types.

********************************

Question 3:

Answer :False

Explanation :

• SQL select clause only get the required information from the database table.
• It will not isolate database table.

********************************

Question 4:

Answer :False

Explanation :

• A Referential Integrity violation occur when the value of foreign key is not present in the primary key column.
• When primary key column is null then will get the error as name of the primary key column can not be null.

********************************

NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.