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