Sail E0 Webinar

MCQs

Total Questions : 286 | Page 3 of 29 pages
Question 21. 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 22. 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 23. 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 24. 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
Question 25. A compound key
  1.    is made up a several pieces of information
  2.    uniquely identifies an item in a list
  3.    both (a) and (b)
  4.    is a combination of each unique key
  5.    None of the above
 Discuss Question
Answer: Option C. -> both (a) and (b)
Question 26. The distinguishable parts of a record are called
  1.    files
  2.    data
  3.    fields
  4.    database
  5.    None of the above
 Discuss Question
Answer: Option C. -> fields
Question 27. The index consists of
  1.    a list of keys
  2.    pointers to the master list
  3.    both (a) and (b)
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option C. -> both (a) and (b)
Question 28. Large collections of files are called
  1.    fields
  2.    records
  3.    databases
  4.    file system
  5.    None of the above
 Discuss Question
Answer: Option C. -> databases
Question 29. In SQL, which command is used to select data in rows and column from one or more tables?
  1.    CHOOSE
  2.    SELECT
  3.    LIST
  4.    BROWSE
  5.    None of the above
 Discuss Question
Answer: Option B. -> SELECT
Question 30. A scheme describes
  1.    data elements
  2.    records and files
  3.    record relationships
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option D. -> All of the above

Latest Videos

Latest Test Papers