adplus-dvertising
frame-decoration

Question

If a piece of data is stored in two places in the database, then

a.

storage space is wasted

b.

changing the data is one spot will cause data inconsistency

c.

it can be more easily accessed

d.

both (a) and (b)

Posted under Relational Databases DBMS

Answer: (d).both (a) and (b)

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. If a piece of data is stored in two places in the database, then

Similar Questions

Discover Related MCQs

Q. A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As

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

Q. In formal relational model, the set of indivisible values is called

Q. In relational model terminology, the table is considered as

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

Q. The format or data type must be specified for

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

Q. In the data model schemas, the constraints that are can not be expressed directly are classified as

Q. The cardinality in relational data model is considered as

Q. The constraint violated when the given value of attribute is not included in the corresponding domain is

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

Q. In the data model, the inherent constraints are classified as

Q. The multi-valued dependencies and functional dependencies are classified as category of

Q. The model in which the multi-valued and composite attributes is considered as

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

Q. The constraints which deals with the changes in the database are classified as

Q. The multivalued dependencies used to develop relational design theory of database is classified as

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

Q. In relational database schemas, the transition constraints are also known as

Q. A row of table in relational model terminology is classified as