Database Management Questions and Answers

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

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

1.The extent of the database resource that is included with each lock is called

Level of impact

Granularity

Management

DBMS control

Recovery.

2.Select the correct statement from the following on proper naming of schema constructs:

Entity type name applies to all the entities belonging to that entity type and therefore a plural name is selected for entity type

In the narrative description of the database requirements, verbs tend to indicate the names of

ionship types

The nouns arising from a database requirement description can be considered as names of attributes

Additional nouns which are appearing in the narrative description of the database requirements

3.The file organization which allows to read records that would satisfy the join condition by using one block read is

Heap file organization

Sequential file organization

Clustering file organization

Hash file organization

Index file organization.

4.Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of #92.Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of

Physical data independence

Concurrency Control

Logical data independence

Functional dependency

Integrity Control.

5.When implementing security in a DBMS, which of the following is not supported by the GRANT command?

Providing DELETE privileges

Supporting the devolution of access control to non-DBAs

Removing privileges of other people

Providing SELECT privileges

Changing passwords.

More Database Management QUESTIONS AND ANSWERS available in next pages