Sail E0 Webinar

MCQs

Total Questions : 286 | Page 7 of 29 pages
Question 61. What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?
  1.    DASD
  2.    FMS
  3.    EMMS
  4.    DBMS
  5.    None of the above
 Discuss Question
Answer: Option D. -> DBMS
Question 62. Which of the following is not an advantage of the data-base approach?
  1.    elimination of the data redundancy
  2.    ability to associate related data
  3.    increased security
  4.    program/data independence
  5.    All of the above are advantages
 Discuss Question
Answer: Option E. -> All of the above are advantages
Question 63. A data dictionary doesn't provide information about:
  1.    where data is located
  2.    the size of the disk storage device
  3.    It allows a many-to-many relationship
  4.    It is conceptually simple
  5.    It will be the dominant data base of the future
 Discuss Question
Answer: Option B. -> the size of the disk storage device
Question 64. Data encryption techniques are particularly useful for
  1.    reducing storage space requirements
  2.    improving data integrity
  3.    protecting data in data communication systems
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option C. -> protecting data in data communication systems
Question 65. It is more accurate to define a _____ as a variety of different record types that are treated as a single unit
  1.    Database
  2.    Table
  3.    Record
  4.    Flat File
  5.    None of the above
 Discuss Question
Answer: Option A. -> Database
Question 66. 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 67. 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 68. 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 69. 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 70. 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

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