Friday, 13 March 2020

CS403-Database Management System Quiz MCQs Lecture 1-22 Midterm Objective Questions | SUPERSTARWEBTECH

CS403-DBMS Quiz  MCQS #Objective #Questions #Midterm

1. Student and Book are two entities, what is the cardinality between the two?
  • Many to One
  • One to Many
  • Many to Many
  • One to One
2. A description on a particular collection of data using the given data model
  • Database
  • Relation
  • Schema
  • None
3. Level of data at which entities or objects exist in reality is called
  • Real world data
  • Schema for real world data
  • Meta data
  •  Data about data
4. Which model operates at the lowest level of abstraction?
  • conceptual
  • internal
  • external
  • physical
5. User rights information is stored in
  • Physical database
  • Catalog
  • Logical database
  • Buffer
6. Data about data is database
  • True
  • False
  • Partially True
  • None
7. Which one of the following is NOT a characteristic of meta data?
  • Data about data
  • Describes a data dictionary
  • Self-describing
  • Includes user data
8. A relationship that involves three entities is called ___
  • Unary relationship
  • Ternary relationship
  • Binary relationship
  •  N-ary relationship
9. An entity type is
  • defined when the database is actually constructed
  • a specific type such as an integer, text, date, logical etc.
  • a coherent set of similar objects that we want to store data on (e.g. STUDENT, COURSE, CAR)
  • defined by the database designer
10. Which of the following is not a component of a DFD?
  • Dataflow
  • Datastore
  • External entities
  • Relationship between external entities