Menu

Question Discussion & Solution

MCQ

Q.

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

Community Discussion

No discussions yet. Be the first to start!

You must be logged in to participate in the discussion.

Login to Discuss

Similar Questions

MCQ

1.

Consider the employee work-team example, and assume that certain employees participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is _____________

A

Overlapping

B

Disjointness

C

Uniqueness

D

Relational

Discussion

MCQ

2.

In E-R diagram generalization is represented by

A

Ellipse

B

Dashed ellipse

C

Rectangle

D

Triangle

Discussion

MCQ

3.

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

Discussion

MCQ

4.

level entity set.

A

Disjointness

B

Uniqueness

C

Special

D

Relational

Discussion

MCQ

5.

Key to represent relationship between tables is called

A

Primary key

B

Secondary Key

C

Foreign Key

D

None of the mentioned

Discussion

More Database Management System Topics

Miscellaneous or General

71 MCQs

Relational Algebra

3 MCQs

Database Systems

49 MCQs

Data Models

16 MCQs

The Relational Database Model

58 MCQs

Entity Relationship (ER) Modeling

59 MCQs

Advanced Data Modeling

1 MCQs

Normalization

58 MCQs

Structured Query Language (SQL)

7 MCQs

Advanced SQL

90 MCQs

Database Design

2 MCQs

Transaction and Concurrency

10 MCQs

Data Warehouses

10 MCQs

Database Administration

1 MCQs

Mixed

10 MCQs