Database Management Questions & Answers: part11



Software Programming : Database Management QUESTIONS AND ANSWERS :: part11 : 6 to 10

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

6.State the effective way of using a relational data model.

Three-dimensional models must be created
There must be a minimum of four relationships
Flat files must be eliminated
Complex groupings of data must be streamlined
All of the above.

7.What is the specific set of data from the database that is required by each user or application program called?

Data definition language
Data dictionary
Physical schema
Conceptual schema
Subschema.

8.What is data integrity?

The inability to view a database because of system problems
Data being unavailable because it is being used by another user
Maintaining consistency of the data in a database
Preventing disclosure of information that causes harm
All of the above.

9.Guidelines for creating tables in a relational database include which of the following?

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
All of the above.

10.What is the result of the following query? SELECT FLOOR(3.6) FROM DUAL?

3.5
3.0
4.0
3.7
3.4.

More Database Management QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha
Opportunity is missed by most people because it is dressed in overalls and looks like work.- Thomas Edison