Sail E0 Webinar

MCQs

Total Questions : 286 | Page 28 of 29 pages
Question 271. Which language has recently become the de-facto standard for interfacing application programs with relational database system?
  1.    Oracle
  2.    SQL
  3.    dBASE
  4.    4GL
  5.    None of the above
 Discuss Question
Answer: Option B. -> SQL
Question 272. 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 273. 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 274. 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 275. 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 276. 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 277. Two files may be joined into a third file if
  1.    they have a row in common
  2.    they have a field in common
  3.    they have no records with the same value in the common field
  4.    both (b) and (c)
  5.    None of the above
 Discuss Question
Answer: Option B. -> they have a field in common
Question 278. The way a particular application views the data from the data base that the application uses is a :
  1.    module
  2.    relational model
  3.    schema
  4.    subschema
  5.    None of the above
 Discuss Question
Answer: Option D. -> subschema
Question 279. Characteristic(s) of a distributed MIS structure is
  1.    interactive sharing of the workload
  2.    a multiprocessing environment
  3.    computers supporting local DP operations
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 280. The data-base environment has all of the following components except:
  1.    users
  2.    separate files
  3.    data base
  4.    data-base administrator
  5.    None of the above
 Discuss Question
Answer: Option B. -> separate files

Latest Videos

Latest Test Papers