DBMS-Database System Architecture Questions and Answers

Practice Mode
Showing 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.
  • A TRUE
  • B FALSE
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.
  • A TRUE
  • B FALSE
Answer: Option A
Q13
The plan (or formulation of scheme) of the database is known as schema.
  • A TRUE
  • B FALSE
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
  • A TRUE
  • B FALSE
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.
  • A TRUE
  • B FALSE
Answer: Option A
Q16
Subschemas act as a unit for enforcing controlled access to the database.
  • A TRUE
  • B FALSE
Answer: Option A
Q17
The process of transforming requests and results between three levels are called mappings.
  • A TRUE
  • B FALSE
Answer: Option A
Q18
The conceptual/internal mapping defines the correspondence between the conceptual view and the stored database.
  • A TRUE
  • B FALSE
Answer: Option A
Q19
The external/conceptual mapping defines the correspondence between a particular external view and organisation
  • A TRUE
  • B FALSE
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.
  • A TRUE
  • B FALSE
Answer: Option A
Database
Back to Database
Questions and Answers for Competitive Exams Various Entrance Test