Sail E0 Webinar

MCQs

Total Questions : 286 | Page 27 of 29 pages
Question 261. 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 262. The highest level in the hierarchy of data organization is called
  1.    data bank
  2.    database
  3.    data file
  4.    data record
  5.    None of the above
 Discuss Question
Answer: Option B. -> database
Question 263. In SQL, GRANT command is used to
  1.    allow user to access databases
  2.    allow user to create databases
  3.    grant system privileges, roles, and object privileges to uses and roles
  4.    choose auditing for specific SQL commands
  5.    None of the above
 Discuss Question
Answer: Option C. -> grant system privileges, roles, and object privileges to uses and roles
Question 264. In SQL, which command(s) is(are) used to enable/disable all triggers on a table?
  1.    ALTER TRIGGERS
  2.    ALTER TABLE
  3.    MODIFY TRIGGERS IN TABLE
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option B. -> ALTER TABLE
Question 265. Updating a database means
  1.    revising the file structure
  2.    reorganizing the database
  3.    modifying or adding record occurrences
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option C. -> modifying or adding record occurrences
Question 266. The logical data structure with a one-to-many relationship is a :
  1.    network
  2.    tree
  3.    chain
  4.    relational
  5.    None of the above
 Discuss Question
Answer: Option B. -> tree
Question 267. A form can be used to
  1.    modify records
  2.    delete records
  3.    format printed output
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 268. Which of the following is not true of the traditional approach to information processing?
  1.    There is common sharing of data among the various applications
  2.    It is file-oriented
  3.    Programs are dependent on the files
  4.    It is inflexible
  5.    All of the above are true
 Discuss Question
Answer: Option A. -> There is common sharing of data among the various applications
Question 269. In SQL, the CREATE TABLE is used
  1.    to create a table, defining its columns, integrity constrains, and storage allocation
  2.    to add a column/integrity constraint to a table
  3.    to redefine a column
  4.    to change a table's storage characteristics
  5.    All of the above
 Discuss Question
Answer: Option A. -> to create a table, defining its columns, integrity constrains, and storage allocation
Question 270. Batch processing is appropriate if
  1.    a large computer system is available
  2.    only a small computer system is available
  3.    only a few transactions are involved
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option E. -> None of the above

Latest Videos

Latest Test Papers