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
C. Doubly outlined rectangle
2. SET concept is used in :
- Network Model
- Hierarchical Model
- Relational Model
- None of these
A. Network Model
3. Relational Algebra is
- Data Definition Language
- Meta Language
- Procedural query Language
- None of the above
C. Procedural query Language
4. Key to represent relationship between tables is called
- Primary key
- Secondary Key
- Foreign Key
- None of these
C. Foreign Key
5. _______ produces the relation that has attributes of R1 and R2
- Cartesian product
- Difference
- Intersection
- Product
A. Cartesian 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
C. Hashed file
7. DBMS helps achieve
- Data independence
- Centralized control of data
- Neither (A) nor (B)
- both (A) and (B)
D. both (A) and (B)
8. Which of the following are the properties of entities?
- Groups
- Table
- Attributes
- Switchboards
C. Attributes
9. In a relation
- Ordering of rows is immaterial
- No two rows are identical
- (A) and (B) both are true
- None of these.
C. (A) and (B) both are true
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
D. None of these