Database Management System MCQs Set-9

  1. 1. The language which has recently become the defacto standard for interfacing application programs with relational database system is
    • Oracle
    • SQL
    • DBase
    • 4GL
  2. 2. The way a particular application views the data from the database that the application uses is a
    • module
    • relational model.
    • schema
    • sub schema
  3. 3. In an E-R diagram an entity set is represent by a
    • rectangle
    • ellipse
    • diamond box.
    • circle
  4. 4. A report generator is used to
    • update files.
    • print files on paper
    • data entry
    • delete files
  5. 5. 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.
  6. 6. 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
  7. 7. A relational database developer refers to a record as
    • a criteria
    • a relation
    • a tuple
    • an attribute
  8. 8. 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.
  9. 9. 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.
  10. 10. 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

Practice Now – Database Management System Online tests