Database Management System MCQs Set-2

PropellerAds
  1. 1. In case of entity integrity, the primary key may be
    • not Null
    • Null
    • both Null & not Null.
    • any value.
  2. 2. The language used in application programs to request data from the DBMS is referred to as the
    • DML
    • DDL
    • VDL
    • SDL
  3. 3. A logical schema
    • is the entire database.
    • is a standard way of organizing information into accessible parts.
    • describes how data is actually stored on disk.
    • both (A) and (C)
  4. 4. Related fields in a database are grouped to form a
    • data file.
    • data record.
    • menu
    • bank
  5. 5. The database environment has all of the following components except:
    • users
    • separate files.
    • database
    • database administrator.
  6. 6. The language which has recently become the defacto standard for interfacing application programs with relational database system is
    • Oracle
    • SQL
    • DBase
    • 4GL
  7. 7. In the architecture of a database system external level is the
    • physical level.
    • logical level.
    •  conceptual level
    • view level.
  8. 8. An entity set that does not have sufficient attributes to form a primary key is a
    • strong entity set.
    • weak entity set.
    • simple entity set.
    • primary entity set.
  9. 9. In a Hierarchical model records are organized as
    • Graph
    • List
    • Links
    • Tree
  10. 10. In an E-R diagram attributes are represented by
    • rectangle
    • square
    • ellipse
    • triangle

Practice Now – Database Management System Online tests