On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on FIle Structure and Organization Set 2

Q1 | Which of the following schemas does define a view or views of the database forparticular users?
  • Internal schema
  • Conceptual schema
  • Physical schema
  • External schema
Q2 | Which of the following are the process of selecting the data storage and data accesscharacteristics of the database?
  • Logical database design
  • Physical database design
  • Testing and performance tuning
  • Evaluation and selecting
Q3 | Which of the following terms does refer to the correctness and completeness of the datain a database?
  • Data security
  • Data constraint
  • Data independence
  • Data integrity
Q4 | A table can be logically connected to another table by defining a
  • Super key
  • Candidate key
  • Primary key
  • Unique key
Q5 | If the state of the database no longer reflects a real state of the world that the databaseis supposed to capture, then such a state is called
  • Consistent state
  • Parallel state
  • Durable state
  • Inconsistent state
Q6 | Ensuring isolation property is the responsibility of the
  • Recovery-management component of the DBMS
  • Concurrency-control component of the DBMS
  • Transaction-management component of the DBMS
  • Buffer management component in DBMS
Q7 | A collection of related data.
  • Information
  • Valuable information
  • Database
  • Metadata
Q8 | DBMS is software.
  • True
  • False
  • none
  • all
Q9 | DBMS manages the interaction between __________ and database.
  • Users
  • Clients
  • End Users
  • Stake Holders
Q10 | Which of the following is not involved in DBMS?
  • End Users
  • Data
  • Application Request
  • HTML
Q11 | Database is generally __________
  • System-centered
  • User-centered
  • Company-centered
  • Data-centered
Q12 | A characteristic of an entity.
  • Relation
  • Attribute
  • Parameter
  • Constraint
Q13 | The restrictions placed on the data.
  • Relation
  • Attribute
  • Parameter
  • Constraint
Q14 | IMS stands for?
  • Information Mastering System
  • Instruction Management System
  • Instruction Manipulating System
  • Information Management System
Q15 | A model developed by Hammer and Mc Leod in 1981.
  • SDM
  • OODBM
  • DDM
  • RDM
Q16 | Object=_________+relationships.
  • data
  • attributes
  • entity
  • constraints
Q17 | Duplication of data at several places is called as _______________.
  • Data Inconsistency
  • Data Isolation
  • Atomicity Problem
  • Data Redundance
Q18 | Data Redundancy increases the cost of storing and retrieving data.
  • False
  • True
  • none
  • all
Q19 | Which of the information is not redundant.
  • name
  • mobile
  • account-no
  • address
Q20 | If in redundant file common fields are not matching then it results in _____________.
  • Data Inconsistency
  • Data Integrity Problem
  • Data Isolation
  • Data Redundancy
Q21 | It is difficult to access conventional file system than Database System.
  • True
  • False
  • none
  • all
Q22 | An ________ is a set of entities of the same type that share the same properties, orattributes.
  • Entity set
  • Attribute set
  • Relation set
  • Entity model
Q23 | Entity is a _________
  • Object of relation
  • Present working model
  • Thing in real world
  • Model of relation
Q24 | The descriptive property possessed by each entity set is _________
  • Entity
  • Attribute
  • Relation
  • Model
Q25 | The function that an entity plays in a relationship is called that entity’s _____________
  • Participation
  • Position
  • Role
  • Instance