dbms keys

mcqspedia.com has 5 Question/Answers about Topic dbms keys

Minimal superkeys are called

Minimal superkeys are called
  • A. Unique key
  • B. Superset key
  • C. Candidate key
  • D. Primary key
  • Correct Answer: Option C

We are often interested in superkeys for which no proper subset is a

We are often interested in superkeys for which no proper subset is a
  • A. Superset key
  • B. Superkey
  • C. Primary key
  • D. Unique key
  • Correct Answer: Option B

Primary key should be chosen such that its attribute values are

Primary key should be chosen such that its attribute values are
  • A. Updated
  • B. Dependent
  • C. Changed
  • D. Never changed
  • Correct Answer: Option D

Address field of a person should not be part of primary key, since it is likely to

Address field of a person should not be part of primary key, since it is likely to
  • A. Dependent
  • B. Changed
  • C. Not changed
  • D. Too long
  • Correct Answer: Option B

A property of entire relation, rather than of individual tuples, is known as

A property of entire relation, rather than of individual tuples, is known as
  • A. Attribute
  • B. Constant
  • C. Variable
  • D. Key
  • Correct Answer: Option D