Sail E0 Webinar

MCQs

Total Questions : 40 | Page 4 of 4 pages
Question 31. The DBMS allows surrogate keys to be changed.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 32. When transforming an entity-relationship model into a relational database design, each entity is represented as a table.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 33. Surrogate keys have much meaning for users.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 34. Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 35. 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 36. When the parent entity is required, a new parent row can always be inserted.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 37. For every relationship, there are six possible referential integrity actions.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True
Question 38. An ideal primary key is short, numeric and seldom changing.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True
Question 39. When the parent entity is required and the parent has a surrogate key, update actions can be ignored.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 40. (STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False

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