Database Management Questions & Answers: part7



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

    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