Sail E0 Webinar

MCQs

Total Questions : 54 | Page 3 of 6 pages
Question 21. We can eliminate modification anomalies with proper normalization that results in tables in BCNF.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 22. Proper normalization eliminates duplicated data.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 23. The design guidelines and priorities for read-only databases are different because read-only databases are never updated.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 24. The phrase "SALE.CNumber must exist in CUSTOMER.CNumber" is a referential integrity constraint.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 25. When you are given a set of tables and asked to create a database to store their data, the first step is to create the new database.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 26. We use the SQL construct COUNT(*) to count the number of rows in a table.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 27. Multivalued dependencies create harmless anomalies that should be noted, but do not always need to be eliminated.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 28. Normalization requires programmers to write more complex SQL.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 29.  Needing to using more complicated SQL in database applications 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 B. -> disadvantage
Question 30.  Multivalued dependencies should ________ be eliminated.
  1.    always
  2.    commonly
  3.    seldom
  4.    never
 Discuss Question
Answer: Option A. -> always

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