Data Models Into Database Designs(Computer Science > Database ) Questions and Answers

Question 1. 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 2. 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 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. Which of the following situation requires the use of ID-dependent entities?
  1.    Association relationships only
  2.    Multivalued attributes only
  3.    Archetype/instance relationships only
  4.    All of the above use ID dependent entities
Explanation:-
Answer: Option D. -> All of the above use ID dependent entities
Question 5. A foreign key is:
  1.    a column containing the primary key of another table.
  2.    used to define data types.
  3.    used to define null status.
  4.    all of the above are above correct.
Explanation:-
Answer: Option A. -> a column containing the primary key of another table.
Question 6. In a 1:1 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 A. -> either table without specifying parent and child tables.
Question 7. Which of the following columns is(are) are required in a table?
  1.    A foreign key
  2.    An alternate key
  3.    A primary key
  4.    A surrogate key
Explanation:-
Answer: Option C. -> A primary key
Question 8. Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000?
  1.    Null status
  2.    Data type
  3.    Default value
  4.    Data constraints
Explanation:-
Answer: Option C. -> Default value
Question 9. 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 10. 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
© Lakshya_Education.com, All Right Reserved.
Contact Us services