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.

PRACTICE IT NOW TO SHARPEN YOUR CONCEPT AND KNOWLEDGE

view hide answers

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
Share with : Share on Linkedin Share on Twitter Share on WhatsApp Share on Facebook