Database Management System MCQs Set-1
Hello Friends,this particular section is well focused on the Frequently asked; DBMS Multiple Choice Questions with Answers 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. DBMS Stand for
- Data base marginal system
- Directory Based Memory Standard
- Data Base Management System
- Dual Bus Mask Storage
✅ Correct Answer: C. Data Base Management System
2. In the relational modes, cardinality is termed as:
- Number of tuples.
- Number of attributes.
- Number of tables.
- Number of constraints.
✅ Correct Answer: A. Number of tuples.
3. Relational calculus is a
- Procedural language.
- Non- Procedural language.
- Data definition language.
- High level language.
✅ Correct Answer: B. Non- Procedural language.
4. The view of total database content is
- Conceptual view.
- Internal view.
- External view.
- Physical View.
✅ Correct Answer: A. Conceptual view.
5. Cartesian product in relational algebra is
- a Unary operator.
- a Binary operator.
- a Ternary operator.
- not defined.
✅ Correct Answer: B. a Binary operator.
6. DML is provided for
- Description of logical structure of database.
- Addition of new structures in the database system.
- Manipulation & processing of database.
- Definition of physical structure of database system.
✅ Correct Answer: C. Manipulation & processing of database.
7. ‘AS’ clause is used in SQL for
- Selection operation.
- Rename operation.
- Join operation.
- Projection operation.
✅ Correct Answer: B. Rename operation.
8. Architecture of the database can be viewed as
- two levels.
- four levels.
- three levels.
- one level.
✅ Correct Answer: C. three levels.
9. In a relational model, relations are termed as
- Tuples
- Attributes
- Tables
- Rows
✅ Correct Answer: C. Tables
10. The database schema is written in
- HLL
- DML
- DDL
- DCL
✅ Correct Answer: C. DDL