DBMS-Relational Algebra and Calculus Questions and Answers
Relational Algebra and Relational Calculus form the theoretical foundation of DBMS programming questions and answers frequently asked in technical interviews and campus placement exams such as TCS, Infosys, and Accenture. These topics explain how queries are represented and optimized in databases. By understanding operations like selection, projection, join, and division, you can effectively translate queries into SQL. Practicing DBMS MCQs and programming interview questions with answers improves your understanding of database logic, query design, and relational schema concepts essential for technical placements.
DBMS-Relational Algebra and Calculus
Showing 10 of
81 questions
21. The father of relation database system is :
- Pascal
- C.J. Date
- Dr. Edgar F. Cord
- none of these
22. Who wrote the paper tieled " A Relational Model of Data for Large shared Data Banks"?
- F.R. McFadden
- C.J. Date
- Dr. Edgar F. Cord
- none of these
23. The first large scale implementation of Codd's relational model was IBM's:
- DB2
- system R
- ingress
- none of these
24. Which of the following is not a relational database system?
- ingress
- DB2
- IMS
- sybase.
25. What is the following is not a relational database system?
- tuple
- relation
- attribute
- domain
26. What is the cardinality of a table with 1000 rows and 10 columns?
- 10
- 100
- 1000
- none of these.
27. What is the cardinality of a table with 5000 rows and 50 columns?
- 10
- 50
- 500
- 5000
28. What is the degree of a table with 1000 rows and 10 columns?
- 10
- 100
- 1000
- none of these
29. What is the degree of a table with 5000 rows and 50 columns?
- 50
- 500
- 5000
- none of these
30. Which of the following keys in a table can uniquely identify a row in a table?
- primary key
- alternate key
- candidate key
- all of these.