Database Management Questions and Answers

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