CSCI 4402: Database Systems - Module 1/Quiz 1

A row of a table in relational model terminology is classified as _________

a. domain

b. relation

c. tuple

d. range

tuple

If two or more constraints are violated by using insert operation then by default the ________

a. insert is rejected

b. insert is accepted

c. insertion permanently blocked

d. insertion done for a default value

insert is rejected

In a relation schema, each key of schema having more than one key is classified as _________

a. foreign key

b. parallel key

c. simple key

d. candidate key

candidate key

In formal relational model, a set of indivisible values that could be a value for certain attribute is called ______________

a. tuple

b. relation

c. range

d. domain

domain

In relational model terminology, the table is considered as ____________

a. domain

b. relation

c. tuple

d. range

relation

In the data model schemas, the constraints that are expressed directly are classified as _________

a. parallel constraints

b. explicit constraints

c. flat constraints

d. implicit constraints

explicit constraints

In the data model, the inherent constraints are classified as ______________

a. implicit constraints

b. flat constraints

c. parallel constraints

d. explicit constraints

implicit constraints

The basic operations that can be performed on relations are _________

a. deletion

b. modification

c. all of the above

d. insertion

all of the above

The key which specifies that two different tuples cannot have the same value is classified as __________

a. simple key

b. conceptual key

c. parallel key

d. super key

super key

The number of the attributes of the relation is considered as the ___________ of the relation

a. domain

b. degree

c. cardinality

d. state

degree

The number of tuples in a relation is considered as the ____________ of a relation

a. cardinality

b. degree

c. domain

d. arity

cardinality

The operation which violates only one constraint called referential integrity when it is performed is called ______________

a. update operation

b. modify operation

c. insert operation

d. delete operation

delete operation

The state in which the database does not follow integrity constraints is classified as ___________

a. invalid state

b. candidate state

c. valid state

d. parallel state

invalid state

The state in which the database follows all the integrity constraints is classified as _______

a. parallel state

b. valid state

c. candidate state

d. invalid state

valid state

The type of constraint in which the value of each attribute (X) must be an indivisible value from domain(X) is classified as _________

a. atomic constraint

b. implicit constraint

c. domain constraint

d. explicit constraint

domain constraint

When the foreign key refers to a tuple which does not exists in subjected relation then the constraint violated is __________

a. insert integrity

b. modify integrity

c. inferential integrity

d. referential integrity

referential integrity

When the primary key is null of the new tuple then the constraint violated is __________

a. secondary integrity constraint

b. null integrity constraint

c. entity integrity constraint

d. primary integrity constraint

entity integrity constraint

Which of the following statement is not true about the attributes in a relation?

a. The relation attribute is unordered

b. The names of the attributes are unique inside a database

c. The names of the attributes are unique inside a relation

d. Attributes names are used to help interpreting the meaning of their values

The names of the attributes are unique inside a database