Database Management Questions & Answers: part7



Software Programming : Database Management QUESTIONS AND ANSWERS :: part7 : 11 to 15

Following Software Programming language Entrance Multiple choice objective type questions and answers will help you in Software Programming 2024 examinations :

11.State the unit of storage that can store one or more records in a hash file organization

Buckets
Disk pages
Blocks
Nodes
Baskets.

12.Which of the following concept is applicable with respect to 2NF?

Full functional dependency
Partial dependency
Transitive dependency
Non-transitive dependency
Data independence.

13.Consider the following ER diagram depicting the relationship of an employee and supervisor: What is the possible relation if the above ERD is mapped into a relational model?

Employee (EmpID, BirthDate, Salary, Name(FirstName, MiddleName, LastName))
Employee (EmpID, BirthDate, Salary, Name(FirstName, MiddleName, LastName)}
Supervision (EmpID, BirthDate, Salary, Name(FirstName, MiddleName, LastName), EmpID)
Supervisor (SupervisorID, BirthDate, Salary, Name(FirstName, MiddleName, LastName),EmpID), {EmpID})
Employee (EmpID, BirthDate, Salary, Name(FirstName, MiddleName, LastName), SupervisorID).

14.If K is a foreign key in a relation R1, then

Every tuple of R1 has a distinct value for K
K cannot have a null value for tuples in R1
K is a key for some other relation
K is a Primary key for R1
K is a Composite key for R1.

More Database Management QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha
If you are not willing to risk the usual you will have to settle for the ordinary- Jim Rohn