Entity Relationship (ER) Modeling Questions

MCQ bookmark_border

11.

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

A

Column

B

Key

C

Row

D

Entry

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

12.

The term _______ is used to refer to a row.

A

Attribute

B

Tuple

C

Field

D

Instance

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

13.

The term attribute refers to a ___________ of a table.

A

Record

B

Column

C

Tuple

D

Key

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

14.

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

A

Domain

B

Relation

C

Set

D

Schema

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

15.

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.

A

Instance, Schema

B

Relation, Schema

C

Relation, Domain

D

Schema, Instance

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

16.

Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________

A

Relations, Attribute

B

Attributes, Relation

C

Tuple, Relation

D

Tuple, Attributes

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

17.

Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.

A

Attributes of common

B

Tuple of common

C

Tuple of distinct

D

Attributes of distinct

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

18.

A domain is atomic if elements of the domain are considered to be ____________ units.

A

Different

B

Indivisbile

C

Constant

D

Divisible

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

19.

The tuples of the relations can be of ________ order.

A

Any

B

Same

C

Sorted

D

Constant

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

20.

_____________ express the number of entities to which another entity can be associated via a relationship set.

A

Mapping Cardinality

B

Relational Cardinality

C

Participation Constraints

D

None of the mentioned

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion