DBMS QUIZ 1

Which of the following is not an integrity constraint ?

• Not Null
• Unique
• Check
• Null

A ________ in a table represents a relationship among a set of values.

• Column
• Key
• Row
• Entry

A relational database consists of a collection of

• Tables
• Records
• Fields
• Keys

Domain constraints, functional dependency and referential integrity are special forms of

• Foreign Key
• Assertion
• Referential key
• None of the above

For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.

Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.

• Instance,Schema
• Relation,Schema
• Relation,Domain
• Schema,Instance

Aggregate functions are functions that take a ___________ as input and return a single value.

• Collection of values
• Single value
• Aggregate value
• Both Collection of values & Single value

All aggregate functions except _____ ignore null values in their input collection

• Count(attribute)
• Count(*)
• Avg
• Sum

We can test for the nonexistence of tuples in a subquery by using the _____ construct.

• Exist
• Not Exists
• Exists
• Not Exist

Define Normalization