DBMS Interview Questions-2

1. What are different DBMS languages?
Ans:
1. DDL (Data definition language)
2. SDL (Storage definition language)
3. VDL (View definition language)
4. DML (Data manipulation language)

2. What are different types of DBMS?
Ans:
1. DBMS
2. RDBMS (Relational)
3. ORDBMS (Object Relational)
4. DDBMS (Distributed)
5. FDBMS (Federated)
6. HDDBMS (Homogeneous)
7. HDBMS (Hierarchical)
8. NDBMS (Networked)

3. What is an entity?
Ans: An entity is a thing in the real world with an independent existence.

4. What are attributes?
Ans: These are the particular properties that describe an entity.

5. What are diff. types of attributes?
Ans:
1. Composite Vs simple attributes.
2. Single valued Vs multi-valued attributes.
3. Stored Vs derived attribute.
4. Null valued attributes.
5. Complex attributes.

6. What is domain value or value set of an attribute?
Ans: It is the set of values that may be assigned to that attribute for each individual entities .

7. What is degree of a relationship?
Ans: The no of entities participating in that relation .

8. What is recursive relationship?
Ans: It is the relationship where both the participating entities belong to same entity type .

9. What are relationship constraints?
Ans:
1. Cardinality ratio.
2. Participation constraints.

10. What is Cardinality ratio?
Ans: The cardinality ratio for a binary relationship specifies the number of relationship instances that an entity can participate in.