Sail E0 Webinar

MCQs

Total Questions : 46 | Page 3 of 5 pages
Question 21. When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 22. Some advantages of partitioning include: efficiency, security, and load balancing.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 23. A pointer is a detailed coding scheme recognized by system software for representing organizational data.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 24. A field represents each component of a composite attribute.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 25. Distributing the columns of a table into several separate physical records is known as horizontal partitioning.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 26. An extent is a contiguous section of disk storage space.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 27. The three newest database architectures in use today are relational, multidimensional and hierarchical.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 28. Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 29. It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 30. In general, larger block sizes are used for online transaction processing applications and smaller block sizes are used for databases with a decision support or data warehousing system.
  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