Functional-Dependency
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 677 |
Consider the relation Emp_Dept with SSn as key
Following operations are performed:
a.Insert a record of department with no employee
b.Delete the last employee of the department
c.Update the department name for department #5
Which of the following will lead to complete loss of information about a department?
Following operations are performed:
a.Insert a record of department with no employee
b.Delete the last employee of the department
c.Update the department name for department #5
Which of the following will lead to complete loss of information about a department?
| Only b | |
| Only c | |
| a and b | |
| b and c |
Question 677 Explanation:
→If we delete one employee details means the department details of particular employee is not available. So statement b is correct.
→With inserting and updating operations there is no loss of department information
→With inserting and updating operations there is no loss of department information
Correct Answer: A
Question 677 Explanation:
→If we delete one employee details means the department details of particular employee is not available. So statement b is correct.
→With inserting and updating operations there is no loss of department information
→With inserting and updating operations there is no loss of department information
Subscribe
Login
0 Comments