Hello Friends,this particular section is well focused on the Frequently asked Database Management System Fundamentals MCQs in the various competitive exam.The set of questions are very basic and easily understandable by reader.we have kept the question hardness level to very basic.

 

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

 
 
You may be interested in:
Database Management System Basics MCQs
Database Management System Online Tests
Database Management System Short Questions With Answers
Database Management System Tutorials