DBMS-Database System Architecture Questions and Answers
Practice ModeShowing 10 of 41 questions
Q11
The primary difference between the different data models lies in the methods of expressing relationships and constraints among the data elements.
Answer: Option A
Q12
In a database, the data are stored in such a fashion that they are independent of the program of users using the data.
Answer: Option A
Q13
The plan (or formulation of scheme) of the database is known as schema.
Answer: Option A
Q14
The physical schema is concerned with exploiting the data structure offered by a DBMS in order to make the scheme understandable to the computer
Answer: Option A
Q15
The logical schema, deals with the manner in which the conceptual database shall get represented in the computer as a stored database.
Answer: Option A
Q16
Subschemas act as a unit for enforcing controlled access to the database.
Answer: Option A
Q17
The process of transforming requests and results between three levels are called mappings.
Answer: Option A
Q18
The conceptual/internal mapping defines the correspondence between the conceptual view and the stored database.
Answer: Option A
Q19
The external/conceptual mapping defines the correspondence between a particular external view and organisation
Answer: Option A
Q20
A data model is an abstraction process that concentrates essential and inherent aspects of the organization's application while ignores supefluous or accidental details.
Answer: Option A