Sail E0 Webinar

MCQs

Total Questions : 40 | Page 1 of 4 pages
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.    An intrarelation constraint
  2.    A range constraint
  3.    An interrelation constraint
  4.    A domain constraint
 Discuss Question
Answer: Option D. -> A domain constraint
Question 2. A primary key should be defined as:
  1.    None of these
  2.    Either of the above can be used.
  3.    NULL.
  4.    NOT NULL.
 Discuss Question
Answer: Option D. -> NOT NULL.
Question 3. Which of the following column properties would be used to specify that cells in a column must contain a monetary value?
  1.    Default value
  2.    Data constraints
  3.    Data type
  4.    Null status
 Discuss Question
Answer: Option C. -> Data type
Question 4. Which of the following column properties specifies whether or not cells in a column must contain a data value?
  1.    Data type
  2.    Data constraints
  3.    Null status
  4.    Default value
 Discuss Question
Answer: Option C. -> Null status
Question 5. In a 1:N relationship, the foreign key is placed in:
  1.    the child table.
  2.    either the parent table or the child table.
  3.    the parent table.
  4.    either table without specifying parent and child tables.
 Discuss Question
Answer: Option A. -> the child table.
Question 6. In a 1:1 relationship, the foreign key is placed in:
  1.    either table without specifying parent and child tables.
  2.    either the parent table or the child table.
  3.    the child table.
  4.    the parent table.
 Discuss Question
Answer: Option A. -> either table without specifying parent and child tables.
Question 7. A foreign key is:
  1.    used to define data types.
  2.    All of these
  3.    a column containing the primary key of another table.
  4.    used to define null status.
 Discuss Question
Answer: Option C. -> a column containing the primary key of another table.
Question 8. Which of the following situation requires the use of ID-dependent entities?
  1.    Archetype/instance relationships only
  2.    Multivalued attributes only
  3.    All of these
  4.    Association relationships only
 Discuss Question
Answer: Option C. -> All of these
Question 9. 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.    Data type
  2.    Data constraints
  3.    Default value
  4.    Null status
 Discuss Question
Answer: Option C. -> Default value
Question 10. Which of the following columns is(are) are required in a table?
  1.    A surrogate key
  2.    An alternate key
  3.    A primary key
  4.    A foreign key
 Discuss Question
Answer: Option C. -> A primary key

Latest Videos

Latest Test Papers