Sail E0 Webinar

MCQs

Total Questions : 286 | Page 5 of 29 pages
Question 41. A _____ Contains fields of data about one entity.
  1.    Record
  2.    File
  3.    Fields
  4.    Document
  5.    None of the above
 Discuss Question
Answer: Option A. -> Record
Question 42. A condition that led to the development of databases was
  1.    a demand for more data to support information needs
  2.    an increase in the amount of data handled by organizations
  3.    the proliferation of data files
  4.    All of the above
  5.    None of the above.
 Discuss Question
Answer: Option D. -> All of the above
Question 43. Embedded pointer provide
  1.    a secondary access path
  2.    a physical record key
  3.    an inverted index
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option A. -> a secondary access path
Question 44. The _____ command is used to allocates an extent for the table in SQL
  1.    MODIFY ALLOCATES
  2.    MODIFY TABLE
  3.    ALTER TABLE
  4.    REDEFINE TABLE
  5.    None of the above
 Discuss Question
Answer: Option A. -> MODIFY ALLOCATES
Question 45. Which of the following is a type of DBMS software?
  1.    database manipulation language
  2.    query language
  3.    utilities
  4.    report writer
  5.    All of the above
 Discuss Question
Answer: Option A. -> database manipulation language
Question 46. Data items grouped together for storage purposes are called a
  1.    record
  2.    title
  3.    list
  4.    string
  5.    None of the above
 Discuss Question
Answer: Option A. -> record
Question 47. The activity of a file
  1.    is a low percentages of number of records added or deleted from a file
  2.    if high, reduces processing efficiency for sequential and nonsequential files
  3.    is a measure of the percentage of existing records updated during a run
  4.    refers to how closely the files fits into the allocated
  5.    None of the above.
 Discuss Question
Answer: Option A. -> is a low percentages of number of records added or deleted from a file
Question 48. Versatile report generators can provide
  1.    Columnar totals
  2.    Subtotals
  3.    Calculations
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 49. Related fields in a data base are grouped to form
  1.    data file
  2.    data record
  3.    menu
  4.    bank
  5.    None of the above
 Discuss Question
Answer: Option B. -> data record
Question 50. A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa.
  1.    One-to-one relationship
  2.    One-to-many relationship
  3.    Many-to-one relationship
  4.    Many-to-many relationship
  5.    None of the above
 Discuss Question
Answer: Option D. -> Many-to-many relationship

Latest Videos

Latest Test Papers