Sail E0 Webinar

MCQs

Total Questions : 286 | Page 24 of 29 pages
Question 231. If a piece of data is stored in two places in the database, then
  1.    storage space is wasted
  2.    changing the data is one spot will cause data inconsistency
  3.    it can be more easily accessed
  4.    both (a) and (b)
  5.    None of the above
 Discuss Question
Answer: Option D. -> both (a) and (b)
Question 232. A file that is organized in uniform format is formally referred to as a _____ or a database file.
  1.    Document
  2.    Database
  3.    Record
  4.    Structured data file
  5.    None of the above
 Discuss Question
Answer: Option D. -> Structured data file
Question 233. A data dictionary is a special file that contains
  1.    the names of all fields in all files
  2.    the data types of all fields in all files
  3.    the widths of all fields in all files
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 234. A logical schema
  1.    is the entire database
  2.    is a standard way of organizing information into accessible parts
  3.    describes how data is actually stored on disk
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option B. -> is a standard way of organizing information into accessible parts
Question 235. In SQL, which command is used to select only one copy of each set of duplicable rows
  1.    SELECT DISTINCT
  2.    SELECT UNIQUE
  3.    SELECT DIFFERENT
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option A. -> SELECT DISTINCT
Question 236. The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in
  1.    a tree file
  2.    an indexed file
  3.    a hashed file
  4.    a sequential file
  5.    None of the above
 Discuss Question
Answer: Option C. -> a hashed file
Question 237. In order to use a record management system
  1.    You need to understand the low-level details of how information in stored
  2.    You need to understand the model the record management system uses.
  3.    Both (a) and (b)
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option B. -> You need to understand the model the record management system uses.
Question 238. Queries to a database
  1.    are written in English
  2.    can use aggregate functions like SUM and COUNT
  3.    both (a) and (b)
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option B. -> can use aggregate functions like SUM and COUNT
Question 239. A _____ Contains fields of data about one entity.
  1.    Record
  2.    File
  3.    Fields
  4.    Document
  5.    None of the above
 Discuss Question
Answer: Option A. -> Record
Question 240. Which of the following is a type of DBMS software?
  1.    database manipulation language
  2.    query language
  3.    utilities
  4.    report writer
  5.    All of the above
 Discuss Question
Answer: Option A. -> database manipulation language

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

DSP Combined 1 Free Revision Test SAIL JO E-0
GPOE / GPA Combined 1 Free Revision Test SAIL JO E-0
BSP Plant Specific Review Test SAIL JO E-0
BSL Combined 1 Free Revision Test SAIL JO E-0
GFM Combined 1 Free Revision Test SAIL JO E-0