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