Sail E0 Webinar

MCQs

Total Questions : 286 | Page 26 of 29 pages
Question 251. If a calculation is embedded in a form
  1.    the result of the calculations are stored with the form
  2.    the calculations are stored with the form
  3.    the result of the calculations are printed in report
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option B. -> the calculations are stored with the form
Question 252. Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?
  1.    DEFINE TABLE
  2.    MODIFY TABLE
  3.    ALTER TABLE
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option C. -> ALTER TABLE
Question 253. An audit trail
  1.    is used to make back-up copies
  2.    is the recorded history of operations performed on a file
  3.    can be used to restore lost information
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option B. -> is the recorded history of operations performed on a file
Question 254. The language used in application programs to request data from the DBMS is referred to as the
  1.    DML
  2.    DDL
  3.    query language
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option A. -> DML
Question 255. A database management system might consist of application programs and a software package called
  1.    FORTRAN
  2.    AUTOFLOW
  3.    BPL
  4.    TOTAL
  5.    None of the above
 Discuss Question
Answer: Option C. -> BPL
Question 256. In SQL, the ALTER TABLESPACE command is used
  1.    to add/rename data files
  2.    to change storage characteristics
  3.    to take a tablespace online/offline
  4.    to begin/end a backup
  5.    All of the above
 Discuss Question
Answer: Option E. -> All of the above
Question 257. The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?
  1.    Bits
  2.    Characters
  3.    Data field
  4.    Schema
  5.    None of the above
 Discuss Question
Answer: Option C. -> Data field
Question 258. Which command is used to remove an index from the database in SQL?
  1.    DELETE INDEX
  2.    DROP INDEX
  3.    REMOVE INDEX
  4.    ROLL BACK INDEX
  5.    None of the above
 Discuss Question
Answer: Option B. -> DROP INDEX
Question 259. What is the name given to the database management system which is able to handle full text data, image data, audio and video?
  1.    Full media
  2.    Graphics media
  3.    Multimedia
  4.    Hypertext
  5.    None of the above
 Discuss Question
Answer: Option C. -> Multimedia
Question 260. A top-to-bottom relationship among the items in a database is established by a
  1.    Hierarchical schema
  2.    Network schema
  3.    Relational schema
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option A. -> Hierarchical schema

Latest Videos

Latest Test Papers