Hello Friends , this particular section is well focused on the DBMS objective questions and answers for 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
1. Count function in SQL returns the number of
- values
- distinct values
- groups
- columns
A. values
2. It is possible to define a schema completely using
- VDL and DDL.
- DDL and DML.
- SDL and DDL.
- VDL and DML.
B. DDL and DML.
3. The statement in SQL which allows to change the definition of a table is
- Alter
- Update
- Create
- select
A. Alter
4. E-R model uses this symbol to represent weak entity set ?
- Dotted rectangle.
- Diamond
- Doubly outlined rectangle
- None of these
C. Doubly outlined rectangle
5. SET concept is used in :
- Network Model
- Hierarchical Model
- Relational Model
- None of these
A. Network Model
6. Relational Algebra is
- Data Definition Language .
- Meta Language
- Procedural query Language
- None of the above
C. Procedural query Language
7. The conceptual model is
- dependent on hardware.
- dependent on software.
- dependent on both hardware and software .
- independent of both hardware and software.
D. independent of both hardware and software.
8. What is a relationship called when it is maintained between two entities?
- Unary
- Binary
- Ternary
- Quaternary
B. Binary
9. Which of the following operation is used if we are interested in only certain columns of a table?
- PROJECTION
- SELECTION
- UNION
- JOIN
A. PROJECTION
10. Which of the following operations need the participating relations to be union compatible?
- UNION
- INTERSECTION
- DIFFERENCEqq
- All of the above
D. All of the above
