Database Management Questions & Answers: part9



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

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

1.Which normal form states that a relation has no transitive dependencies in it?

First
Second
Third
Fourth
BCNF.

2.In an SQL statement, which of the following parts states the condition for Group selection?

Select
From
Where
Group By
Having.

3.Which of the following statement is component of DBMS? #127.Which of the following statement is component of DBMS?

Data dictionary/directory subsystem
Na�ve Users
Database administrator
Users and programmers
Hardware and data.

4.Which of the following collection(s) of attributes correctly represent(s) a Lecturer relation and possible relationship(s) it might have with other relations when the E-R model is mapped into a relational model?

Name, UPFNo, Address, Phone
Name, UPFNo, Address, Phone, Subject, lecturehours
Name, UPFNo, Address, Phone, Subject
Name, UPFNo, Address, Phone, Faculty
Name, UPFNo, Address, Phone, Subject, Faculty, Dean.

5.Which type of file is easiest to update?

Sequential
Hashed
Indexed
Clustered
Heaped.

More Database Management QUESTIONS AND ANSWERS available in next pages

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