There is no elevator to success. You have to take the stairs. Take your first steps with SSWT!

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

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