CPCT MP TUTORIALS

📘 DBMS Fundamentals, Architecture, ER Model & Relational Model Q1. In the relational model, cardinality refers to: (A) Number of tuples (B) Number of attributes (C) Number of tables (D) Number of constraints ✔ Correct Answer: (A) Explanation: Cardinality means number of rows (tuples) in a relation. Q2. Degree of a relation refers to: (A) Number of tuples (B) Number of attributes (C) Number of constraints (D) Number of keys ✔ Correct Answer: (B) Explanation: Degree means the number of attributes (columns). Q3. Relational calculus is a: (A) Procedural language (B) Non-procedural language (C) Data definition language (D) High-level language ✔ Correct Answer: (B) Explanation: Relational calculus specifies what to retrieve, not how. Q4. Relational algebra is a: (A) Procedural query language (B) Non-procedural language (C) Data dictionary (D) Data model ✔ Correct Answer: (A) Explanation: Relational algebra specifies step-by-step procedures. Q5. The view of total database content is: (A)...