Sail E0 Webinar

MCQs

Total Questions : 30 | Page 2 of 3 pages
Question 11. A secondary key is which of the following?
  1.    Primary key
  2.    Determines the tablespace required
  3.    Useful for denormalization decisions
  4.    Nonunique key
 Discuss Question
Answer: Option D. -> Nonunique key
Question 12. The fastest read/write time and most efficient data storage of any disk array type is:
  1.    RAID-0
  2.    RAID-2
  3.    RAID-1
  4.    RAID-3
 Discuss Question
Answer: Option A. -> RAID-0
Question 13. A rule of thumb for choosing indexes for a relational database includes which of the following?
  1.    Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries.
  2.    Do not specify a unique index for the primary key of each table.
  3.    Be careful indexing attributes that have null values.
  4.    Indexes are more useful on smaller tables.
 Discuss Question
Answer: Option C. -> Be careful indexing attributes that have null values.
Question 14. A multidimensional database model is used most often in which of the following models?
  1.    Data warehouse
  2.    Relational
  3.    Network
  4.    Hierarchical
 Discuss Question
Answer: Option A. -> Data warehouse
Question 15. Sequential retrieval on a primary key for sequential file storage has which of the following features?
  1.    Impractical
  2.    Very fast
  3.    Moderately fast
  4.    Slow
 Discuss Question
Answer: Option B. -> Very fast
Question 16. Hashing algorithm converts a primary key value into a record address.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 17. A bitmap index is an index on columns from two or more tables that come from the same domain of values.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 18. Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 19. Denormalization and clustering can work well to minimize data access time for small records.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True
Question 20. The primary goal of physical database design is data processing efficiency.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True

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

GPOE / GPA Combined 1 Free Mock Test SAIL JO E-0 2024
ICA Combined 1 Free Revision Test SAIL JO E-0
RDIC Review Test SAIL JO E-0
Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI
RSP Combined 1 Free Revision Test SAIL JO E-0