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

Edit

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

Edit

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

Edit

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

Edit