Database Management Questions & Answers: part11

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 2015 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?


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

    Health is the greatest gift, contentment is the greatest wealth -Buddha