Sail E0 Webinar

MCQs

Total Questions : 229 | Page 22 of 23 pages
Question 211. Which of the following terms does not describe a database structure used by a DBMS to link data from several files?
  1.    Relational
  2.    Structural
  3.    Network
  4.    All of the above
 Discuss Question
Answer: Option B. -> Structural
Answer: (b)
Question 212. What did the first Table Analyzer do?
  1.    Analyze the data in a set of flat files and automatically create a relational database system from that information
  2.    Provide a graphic way to design relational databases
  3.    Automate process of connecting tables to SQL Server
  4.    None
 Discuss Question
Answer: Option A. -> Analyze the data in a set of flat files and automatically create a relational database system from that information
Answer: (a)
Question 213. What is the abbreviation used for a software package that permits the user to create, retrieve and maintain records in a database?
  1.    DASD
  2.    FMS
  3.    EMMS
  4.    DBMS
 Discuss Question
Answer: Option D. -> DBMS
Answer: (d)
Question 214. Different levels of access are assigned to personnel records in the health and fitness gym. Only the system manager is able to create delete or edit records. Certain other personnel are allowed to view all the records, whereas others are not permitted to view complete records. The levels of access are controlled by
  1.    Password
  2.    User id’s
  3.    Status
  4.    None of the above
 Discuss Question
Answer: Option A. -> Password
Answer: (a)
Question 215. A computer language for informing the DBMS regarding the data structure used is
  1.    PASCAL
  2.    DDL
  3.    PROLOG
  4.    FORTRAN
 Discuss Question
Answer: Option B. -> DDL
Answer: (b)
Question 216. Pack command is used to
  1.    Remove records permanently
  2.    Remove records temporarily
  3.    Restore records permanently
  4.    Restore records temporarily
 Discuss Question
Answer: Option A. -> Remove records permanently
Answer: (a)
Question 217. Which of the following is not a relational database?
  1.    dBase IV
  2.    4th Dimension
  3.    FoxPro
  4.    Reflex
 Discuss Question
Answer: Option D. -> Reflex
Answer: (d)
Question 218. A report form
  1.    Appears on the computer monitor during data entry
  2.    Is used during report generation to format data
  3.    Both (A) and (B)
  4.    All of above
 Discuss Question
Answer: Option B. -> Is used during report generation to format data
Answer: (b)
Question 219. Facilities offered by databases are
  1.    The ability to store a large amount of data in a structured format, easy update, sort, query, production of reports
  2.    Easy editing, spell check, perform calculations, library of mathematical functions, replication
  3.    The ability to rotate images, copy and paste, fill scale
  4.    None of above
 Discuss Question
Answer: Option A. -> The ability to store a large amount of data in a structured format, easy update, sort, query, production of reports
Answer: (a)
Question 220. Checks that are added to databases to detect unsuitable data on input are called
  1.    validation
  2.    verification
  3.    vegetation
  4.    none of above
 Discuss Question
Answer: Option A. -> validation
Answer: (a)

Latest Videos

Latest Test Papers