Database Management Questions & Answers: part12



Software Programming : Database Management QUESTIONS AND ANSWERS :: part12 : 11 to 15

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

11.The most important advantages of the hierarchical database model is/are

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.

12.Which of the following keyword is used with Data Control Language (DCL) statements?

SELECT
INSERT
DELETE
GRANT
UPDATE.

13.State the three basic operations used to develop useful sets of data in a relational database?

Sort, select and report
Combine, relate and sort
Select, project and join
Project, combine and report
Join, relate and sort.

14.Which of the following include guidelines for creating tables in a relational database?

Only one table in the database needs a primary key
The primary key need not be unique
Attributes may appear in several tables
Data must be atomic.
The secondary key need to be unique.

More Database Management QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha
Trust because you are willing to accept the risk, not because it’s safe or certain