Schemas Instances and Database State Quiz PDF: Questions and Answers - 43

MCQ 211: In a particular time, the data available in the database at specific moment is called

1. database time interval
2. database concept
3. database construct
4. database state

MCQ 212: The total participation constraint is also known as

1. recursive dependency
2. existence dependency
3. existence independency
4. recursive independency

MCQ 213: In the data model, the inherent constraints are classified as

1. flat constraints
2. parallel constraints
3. explicit constraints
4. implicit constraints

MCQ 214: The tuples that are represented in one of two relations and are lost if the JOIN operation is performed are called

1. functional tuples
2. dangling tuples
3. algorithm tuples
4. decomposition tuples

MCQ 215: The data type in SQL which includes various size integers and floating point numbers are classified as

1. query data type
2. numeric data types
3. binary data types
4. formatted data types