Sail E0 Webinar

MCQs

Total Questions : 286 | Page 2 of 29 pages
Question 11. In SQL, which command(s) is(are) used to redefine an index's future storage allocation
  1.    ALTER INDEX
  2.    REDEFINE INDEX
  3.    MODIFY INDEX
  4.    DO INDEX
  5.    None of the above
 Discuss Question
Answer: Option A. -> ALTER INDEX
Question 12. Which of the following is a serious problem of file management systems?
  1.    difficult to update
  2.    lack of data independence
  3.    data redundancy
  4.    program dependence
  5.    All of the above
 Discuss Question
Answer: Option E. -> All of the above
Question 13. The model for a _____ resembles the hierarchical model in many respects.
  1.    Network database
  2.    Relational database
  3.    Distributed database
  4.    Hierarchical database
  5.    None of the above
 Discuss Question
Answer: Option A. -> Network database
Question 14. With respect to data input, the most accurate description of batch control is
  1.    dividing documents to be entered into batches
  2.    controlling the input of each input clerk
  3.    comparing to a pre-calculated figure the total of a data item summed across a batch records put into the system
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option C. -> comparing to a pre-calculated figure the total of a data item summed across a batch records put into the system
Question 15. A set of programs that handle a firm's data base responsibilities is called a
  1.    Data Base Management System (DBMS)
  2.    Data Base Processing System (DBPS)
  3.    Data Management System (DMS)
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 16. In any hierarchy of data organization, the smallest entity to be processed as a single unit is called
  1.    data field
  2.    data record
  3.    data file
  4.    database
  5.    None of the above
 Discuss Question
Answer: Option A. -> data field
Question 17. Long-range planning report produced in an MIS are primarily designed for
  1.    top management
  2.    middle management
  3.    lower management
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option A. -> top management
Question 18. The model for a record management system might be
  1.    handwritten list
  2.    a Rolodex card file
  3.    a business form
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 19. Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?
  1.    report writer
  2.    query language
  3.    data manipulation language
  4.    transaction log
  5.    None of the above
 Discuss Question
Answer: Option D. -> transaction log
Question 20. The designer of a form includes
  1.    filed designators
  2.    prompts
  3.    data
  4.    both (a) and (b)
  5.    None of the above
 Discuss Question
Answer: Option D. -> both (a) and (b)

Latest Videos

Latest Test Papers