21CSC205P- Database Management Systems

Which one of the following refers to the "data about data"?

• Directory

• Sub Data

• Warehouse

• Meta Data

Which of the following refers to the level of data abstraction that describes exactly how the data actually stored?

• Conceptual Level

• Physical Level

• File Level

• Logical Level

Which of the following refers to the number of tuples in a relation?

• Entity

• Column

• Cardinality

• Key

In the relation model, the relation are generally termed as ________

• Tuples

• Attributes

• Rows

• Tables

Which of the following is a top-down approach in which the entity's higher level can be divided into two lower sub-entities?

• 1. Aggregation

• 1. Generalization

• 1. Specialization

• 1. All of the above

What do you mean by one to many relationships?

• One class may have many teachers

• One teacher can have many classes

• Many classes may have many teachers

• Many teachers may have many classes

A ………………. does not have a distinguishing attribute if its own and most are dependent entities, which are part of some another entity.

• Weak entity
  

• Strong entity
  

• Non-attributes entity
  

• Dependent entity

The way a particular application views the data from the database that the application uses is a

• module
  

• relational model
  

• schema
  

• subschema

Which are the two ways in which entities can participate in a relationship?

• Passive and active
  

• Total and partial
  

• Simple and Complex
  

• All of the above

……………….. contains information that defines valid values that are stored in a column or data type.

• View
  

• Rule
  

• Index
  

• Default