Sail E0 Webinar

MCQs

Total Questions : 286 | Page 9 of 29 pages
Question 81. Sort/report generators
  1.    are faster than index/report generators
  2.    require more disk space than index/report generators
  3.    do not need to sort before generating a report
  4.    both (a) and (b)
  5.    None of the above
 Discuss Question
Answer: Option B. -> require more disk space than index/report generators
Question 82. The data dictionary tells the DBMS
  1.    what files are in the database
  2.    what attribute are possessed by the data
  3.    what these files contain
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 83. In SQL, which command(s) is(are) used to enable/disable a database trigger?
  1.    MODIFY USER
  2.    CHANGE USER
  3.    ALTER TRIGGER
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option C. -> ALTER TRIGGER
Question 84. If the record management system allows you to edit values before they are recorded on disk, you can
  1.    correct spelling changes before they are recorded
  2.    change the name of a field
  3.    change the width of a field
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option A. -> correct spelling changes before they are recorded
Question 85. The relational model uses some unfamiliar terminology. A tuple is equivalent to a:
  1.    record
  2.    field
  3.    file
  4.    data base
  5.    data item
 Discuss Question
Answer: Option A. -> record
Question 86. The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?
  1.    Bits
  2.    Characters
  3.    Data field
  4.    Schema
  5.    None of the above
 Discuss Question
Answer: Option C. -> Data field
Question 87. Which command is used to remove an index from the database in SQL?
  1.    DELETE INDEX
  2.    DROP INDEX
  3.    REMOVE INDEX
  4.    ROLL BACK INDEX
  5.    None of the above
 Discuss Question
Answer: Option B. -> DROP INDEX
Question 88. What is the name given to the database management system which is able to handle full text data, image data, audio and video?
  1.    Full media
  2.    Graphics media
  3.    Multimedia
  4.    Hypertext
  5.    None of the above
 Discuss Question
Answer: Option C. -> Multimedia
Question 89. An-owner-member set in the CODASYL specifications may have
  1.    only one owner but many owner occurrences
  2.    only one member but many member occurrence
  3.    more than one member but only one occurrence per member
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option A. -> only one owner but many owner occurrences
Question 90. A top-to-bottom relationship among the items in a database is established by a
  1.    Hierarchical schema
  2.    Network schema
  3.    Relational schema
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option A. -> Hierarchical schema

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