Sail E0 Webinar

MCQs

Total Questions : 54 | Page 2 of 6 pages
Question 11. Read-only databases are ________ updated.
  1.    always
  2.    commonly
  3.    seldom
  4.    never
 Discuss Question
Answer: Option D. -> never
Question 12. Needing to assess the validity of assumed referential integrity constraints on foreign keys is a(n) ________ of normalization.
  1.    advantage
  2.    disadvantage
  3.    either an advantage or disadvantage
  4.    neither an advantage nor disadvantage
 Discuss Question
Answer: Option D. -> neither an advantage nor disadvantage
Question 13. Normalization ________ data duplication.
  1.    eliminates
  2.    reduces
  3.    increases
  4.    maximizes
 Discuss Question
Answer: Option A. -> eliminates
Question 14. When building a database from an existing set of tables, we may safely assume that referential integrity constraints have been enforced on the data we are given.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 15. Most of the time, modification anomalies cause problems that are severe enough that a table should be normalized into BCNF.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 16. We have normalized a table into BCNF if all candidate keys are determinants.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 17. We use the SQL construct COLUMNS(*) to determine the number and type of columns in a table.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 18. One common design problem when designing a database from existing data is the use of a single cell in one column to store multiple values of an attribute.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 19. In all cases, normalization into BCNF is desirable.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 20. Denormalized tables are in BCNF.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> 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