Database Management Questions and Answers

Software Programming : Database Management QUESTIONS AND ANSWERS :: part11 : 1 to 5

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

1.Consider the following ER diagram dipicting the ralationship of an employee and supervisor: Which is the possible relation if the above ERD is mapped into a relational model?

Employee(EmpID, BirthDate, 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).

2.What are the most important advantages of the hirerchical database model?

Conceptual simplicity, integrity, diversity and security

Security, efficiency, diversity, simplicity and integrity

Integrity, efficiency, diversity, independence and simplicity

Conceptual simplicity, security, hierarchy

Conceptual simplicity, security, independence, integrity and efficiency.

3.Which database structure consists of a set of two or more related tables with a minimum of one shared field between them?

Hierarchical

Network

Object-oriented

Relational

ER.

4.If k is a Primary key in a relation R1, then

Every tuple of R1 has a distinct value for K

K can have a null value for tuples in R1

K must be a key for some other relation

K is a foreign key for R1

K is a Composite key for R1.

5.The following are the three language components of a database management system (DBMS). I. Data Definition Language (DDL). II. Sub-schema DDL. III. Data Manipulation Language. Two different types of people (users and practioners) are concerned with them. Which of them do users of a DBMS usually deal with?

Only (I) above

Only (III) above

Both (I) and (II) above

Both (II) and (III) above

All (I), (II) and (III) above.

More Database Management QUESTIONS AND ANSWERS available in next pages