Entity Relationship (ER) Modeling Questions

MCQ bookmark_border

21.

An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A.This is called as

A

One-to-many

B

One-to-one

C

Many-to-many

D

Many-to-one

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

22.

An entity in A is associated with at most one entity in B. An entity in B, however, can be associated with any number (zero or more) of entities in A.

A

One-to-many

B

One-to-one

C

Many-to-many

D

Many-to-one

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

23.

Data integrity constraints are used to:

A

Control who is allowed access to the data

B

Ensure that duplicate records are not entered into the table

C

Improve the quality of data entered for a specific property

D

Prevent users from changing the values stored in the table

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

24.

Establishing limits on allowable property values, and specifying a set of acceptable, predefined options that can be assigned to a property are examples of:

A

Attributes

B

Data integrity constraints

C

Method constraints

D

Referential integrity constraints

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

25.

Which of the following can be addressed by enforcing a referential integrity constraint?

A

All phone numbers must include the area code

B

Certain fields are required (such as the email address, or phone number) before the record is accepted

C

Information on the customer must be known before anything can be sold to that customer

D

Then entering an order quantity, the user must input a number and not some text (i.e., 12 rather than

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

26.

______ is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

A

Entity Integrity Constraints

B

Referential Integrity Constraints

C

Domain Integrity Constraints

D

Domain Constraints

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

27.

Which one of the following uniquely identifies the elements in the relation?

A

Secondary Key

B

Primary key

C

Foreign key

D

Composite key

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

28.

Drop Table cannot be used to drop a table referenced by a _________ constraint.

A

Local Key

B

Primary Key

C

Composite Key

D

Foreign Key

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

29.

____________ is preferred method for enforcing data integrity

A

Constraints

B

Stored Procedure

C

Triggers

D

Cursors

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

30.

Which of the following gives a logical structure of the database graphically?

A

Entity-relationship diagram

B

Entity diagram

C

Database diagram

D

Architectural representation

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion