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.
PRACTICE IT NOW TO SHARPEN YOUR CONCEPT AND KNOWLEDGE
1. DBMS Stand for
- Data base marginal system
- Directory Based Memory Standard
- Data Base Management System
- Dual Bus Mask Storage
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.
A. Number of tuples.
3. Relational calculus is a
- Procedural language.
- Non- Procedural language.
- Data definition language.
- High level language.
B. Non- Procedural language.
4. The view of total database content is
- Conceptual view.
- Internal view.
- External view.
- Physical View.
A. Conceptual view.
5. Cartesian product in relational algebra is
- a Unary operator.
- a Binary operator.
- a Ternary operator.
- not defined.
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.
C. Manipulation & processing of database.
7. ‘AS’ clause is used in SQL for
- Selection operation.
- Rename operation.
- Join operation.
- Projection operation.
B. Rename operation.
8. Architecture of the database can be viewed as
- two levels.
- four levels.
- three levels.
- one level.
C. three levels.
9. In a relational model, relations are termed as
- Tuples
- Attributes
- Tables
- Rows
C. Tables
10. The database schema is written in
- HLL
- DML
- DDL
- DCL
C. DDL
