Data Models Into Database Designs(Database ) Questions and Answers

Question 1. Which of the following column properties specifies whether or not cells in a column must contain a data value?
  1.    Null status
  2.    Data type
  3.    Default value
  4.    Data constraints
Explanation:-
Answer: Option A. -> Null status
Question 2. Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?
  1.    A domain constraint
  2.    A range constraint
  3.    An intrarelation constraint
  4.    An interrelation constraint
Explanation:-
Answer: Option A. -> A domain constraint
Question 3. A primary key should be defined as:
  1.    NULL.
  2.    NOT NULL.
  3.    Either of the above can be used.
  4.    None of the above are correct.
Explanation:-
Answer: Option B. -> NOT NULL.
Question 4. In a 1:N relationship, the foreign key is placed in:
  1.    either table without specifying parent and child tables.
  2.    the parent table.
  3.    the child table.
  4.    either the parent table or the child table.
Explanation:-
Answer: Option C. -> the child table.
Question 5. Which of the following column properties would be used to specify that cells in a column must contain a monetary value?
  1.    Null status
  2.    Data type
  3.    Default value
  4.    Data constraints
Explanation:-
Answer: Option B. -> Data type
Question 6. The identifier of an entity will become the ________ of the new table.
  1.    foreign key
  2.    main attribute
  3.    primary key
  4.    identity key
Explanation:-
Answer: Option C. -> primary key
Question 7. For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
  1.    Two
  2.    Three
  3.    Four
  4.    Six
Explanation:-
Answer: Option D. -> Six
Question 8. Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?
  1.    A domain constraint
  2.    A range constraint
  3.    An intrarelation constraint
  4.    An interrelation constraint
Explanation:-
Answer: Option C. -> An intrarelation constraint
Question 9. A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
  1.    primary key.
  2.    foreign key.
  3.    composite key.
  4.    surrogate key.
Explanation:-
Answer: Option D. -> surrogate key.
Question 10. Which is not true about surrogate keys?
  1.    They are short.
  2.    They are fixed.
  3.    They have meaning to the user.
  4.    They are numeric.
Explanation:-
Answer: Option C. -> They have meaning to the user.
© Lakshya_Education.com, All Right Reserved.
Contact Us services