Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 668
|
Consider the database state for the two tables given below:
SQL query- INSERT INTO DEPT(Dname,Dnum,Mgr_SSn) VALUES (Dept2,3,Mgr3)
Is rejected because of
SQL query- INSERT INTO DEPT(Dname,Dnum,Mgr_SSn) VALUES (Dept2,3,Mgr3)
Is rejected because of
|
Duplication of department name
|
|
|
Incorrect Mgr_SSN
|
|
|
Violation of referential Integrity
|
|
|
Violation of entity integrity
|
Question 668 Explanation:
→Dnum is common field of two tables which may be foreign key.
→Inserting new row in the first table gives some null entries in the second table which is violation of referential integrity
→Inserting new row in the first table gives some null entries in the second table which is violation of referential integrity
Correct Answer: C
Question 668 Explanation:
→Dnum is common field of two tables which may be foreign key.
→Inserting new row in the first table gives some null entries in the second table which is violation of referential integrity
→Inserting new row in the first table gives some null entries in the second table which is violation of referential integrity