Sail E0 Webinar

MCQs

Total Questions : 60 | Page 4 of 6 pages
Question 31. When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 32. (STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 33. For every relationship, there are six possible referential integrity actions.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 34. An ideal primary key is short, numeric and seldom changing.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 35.  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
 Discuss Question
Answer: Option A. -> A domain constraint
Question 36.  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.
 Discuss Question
Answer: Option C. -> the child table.
Question 37.  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
 Discuss Question
Answer: Option A. -> Null status
Question 38.  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
 Discuss Question
Answer: Option B. -> Data type
Question 39.  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
 Discuss Question
Answer: Option D. -> All of the above use ID dependent entities
Question 40.  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.
 Discuss Question
Answer: Option B. -> NOT NULL.

Latest Videos
Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)
Direction Sense Test Part 1 Reasoning (Hindi)
Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE
Cube & Cuboid Part 1 Reasoning (Hindi)
Data Interpretation (DI) Basic Concept Reasoning (Hindi)
Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)
Sail E0 free webinar Webinars
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI
Tabulation - Test Paper 2 Data Interpretation Reasoning & DI
Test Paper 1 Direction Sense Test Reasoning & DI
ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0
GFM Combined 1 Free Revision Test SAIL JO E-0