Hello Friends , this particular section is well focused on the Frequently asked Database Management System (DBMS ) Multiple Choice Questions and Answers – 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
. E-R model uses this symbol to represent weak entity set ?
  • Dotted rectangle.
  • Diamond
  • Doubly outlined rectangle
  • None of these
2
. SET concept is used in :
  • Network Model
  • Hierarchical Model
  • Relational Model
  • None of these
3
. Relational Algebra is
  • Data Definition Language
  • Meta Language
  • Procedural query Language
  • None of the above
4
. Key to represent relationship between tables is called
  • Primary key
  • Secondary Key
  • Foreign Key
  • None of these
5
. _______ produces the relation that has attributes of R1 and R2
  • Cartesian product
  • Difference
  • Intersection
  • Product
6
. The file organization that provides very fast access to any arbitrary record of a file is
  • Ordered file
  • Unordered file
  • Hashed file
  • B-tree
7
. DBMS helps achieve
  • Data independence
  • Centralized control of data
  • Neither (A) nor (B)
  • both (A) and (B)
8
. Which of the following are the properties of entities?
  • Groups
  • Table
  • Attributes
  • Switchboards
9
. In a relation
  • Ordering of rows is immaterial
  • No two rows are identical
  • (A) and (B) both are true
  • None of these.
10
. Which of the following is correct:
  • a SQL query automatically eliminates duplicates.
  • SQL permits attribute names to be repeated in the same relation.
  • a SQL query will not work if there are no indexes on the relations
  • None of these

 
 
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