Databases-Relational Model [GATE (Graduate Aptitude Test in Engineering) Computer Science & IT (CS)]: Questions 30 - 33 of 127
Choose Programs:
🎓 Study Material (1190 Notes): 2024-2025 Syllabus
Rs. 1000.00 -OR-
3 Year Validity (Multiple Devices)
Topic-wise Notes & SampleDetails
🎯 302 Numeric, 2894 MCQs (& PYQs) with Full Explanations (2024-2025 Exam)
Rs. 650.00 -OR-
3 Year Validity (Multiple Devices)
CoverageDetailsSample Explanation
Help me Choose & Register (Watch Video) Already Subscribed?
Question 30
Appeared in Year: 2013
Question MCQ▾
Based on the cardinality ratio and participation ________ associated with a relationship type, choose either the Foreign Key Design, the Cross Referencing Design or Mutual Referencing Design. (December Paper-II)
Choices
Choice (4) | Response | |
---|---|---|
a. | Rules | |
b. | Constraints | |
c. | Keys | |
d. | Entity |
Question 31
Appeared in Year: 2013
Question MCQ▾
The student marks should not be greater than 100. This is (December Paper-II)
Choices
Choice (4) | Response | |
---|---|---|
a. | Integrity constraint | |
b. | Referential constraint | |
c. | Over-defined constraint | |
d. | Feasible constraint |
Question 32
Appeared in Year: 2013
Question MCQ▾
For a database relation where the domains of include only the atomic values. The functional dependency holds in the following relation (June Paper III)
Choices
Choice (4) | Response | |
---|---|---|
a. | In not in | |
b. | In not in | |
c. | In | |
d. | In |
Question 33
Appeared in Year: 2013
Question MCQ▾
The “PROJECT” operator of a relational algebra creates a new table that has always (June Paper III)
Choices
Choice (4) | Response | |
---|---|---|
a. | More columns than columns in original table | |
b. | More rows than original table | |
c. | Same number of rows as the original table | |
d. | Same number of columns as the original table |