If you would like to view All All DBMS interview questions only, at one place, visit below link
All DBMS Interview Questions
21. 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)
22. 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)
23. What is an entity?
Ans: An entity is a thing in the real world with an independent existence.
24. What are attributes?
Ans: These are the particular properties that describe an entity.
25. 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.
26. What is difference between entity set and entity type?
27. 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 .
28. What is degree of a relationship?
Ans: The no of entities participating in that relation .
29. What is recursive relationship?
Ans: It is the relationship where both the participating entities belong to same entity type .
30. What are relationship constraints?
Ans:
1. Cardinality ratio.
2. Participation constraints.
Related Fresher Interview Questions
1. C Language Interview Questions
2. C++ Language Interview Questions
3. Data Structures Interview Questions
4. DBMS Interview Questions
5. Operating System Interview Questions
6. UNIX Interview Questions