Database Management System MCQs Set-3

  1. 1. The way a particular application views the data from the database that the application uses is a
    • module
    • relational model.
    • schema
    • sub schema.
  2. 2. In an E-R diagram an entity set is represent by a
    • rectangle
    • ellipse
    • diamond box.
    • circle
  3. 3. A report generator is used to
    • update files.
    • print files on paper.
    • data entry.
    • delete files.
  4. 4. The property / properties of a database is / are :
    • It is an integrated collection of logically related records.
    • It consolidates separate files into a common pool of data records.
    • Data stored in a database is independent of the application programs using it.
    • All of the above.
  5. 5. The DBMS language component which can be embedded in a program is
    • The data definition language (DDL).
    • The data manipulation language (DML).
    • The database administrator (DBA).
    • A query language.
  6. 6. A relational database developer refers to a record as
    • a criteria.
    • a relation.
    • a tuple.
    • an attribute.
  7. 7. The relational model feature is that there
    • is no need for primary key data.
    • is much more data independence than some other database models.
    • are explicit relationships among records.
    • are tables with many dimensions.
  8. 8. Conceptual design
    • is a documentation technique.
    • needs data volume and processing frequencies to determine the size of the database.
    • involves modelling independent of the DBMS.
    • is designing the relational model.
  9. 9. The method in which records are physically stored in a specified order according to a key field in each record is
    • hash
    • direct
    • sequential
    • all of the above.
  10. 10. A subschema expresses
    • the logical view.
    • the physical view.
    • the external view.
    • all of the above.

Practice Now – Database Management System Online tests