Database Management Questions and Answers

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 2024 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