Databases [GATE (Graduate Aptitude Test in Engineering) Computer Science & IT (CS)]: Questions 75 - 79 of 339
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 75
Appeared in Year: 2013
Question MCQ▾
A Network Schema (June Paper II)
Choices
Choice (4) | Response | |
---|---|---|
a. | restricts to one to many relationship | |
b. | permits many to many relationship | |
c. | stores Data in a Database | |
d. | stores Data in a Relation |
Question 76
Appeared in Year: 2013
Question MCQ▾
If are domains in a relational model, then the relation is a table, which is a subset of (June Paper II)
Choices
Choice (4) | Response | |
---|---|---|
a. | ||
b. | ||
c. | ||
d. |
Question 77
Appeared in Year: 2013
Question MCQ▾
Which of the following is not a type of Database Management System? (June Paper II)
Choices
Choice (4) | Response | |
---|---|---|
a. | Hierarchical | |
b. | Network | |
c. | Relational | |
d. | Sequential |
Question 78
Appeared in Year: 2013
Question MCQ▾
Which normal form is considered as adequate for usual database design? (June Paper II)
Choices
Choice (4) | Response | |
---|---|---|
a. | 4NF | |
b. | 3NF | |
c. | 2NF | |
d. | 5NF |
Question 79
Appeared in Year: 2013
Question MCQ▾
The SQL expression
Select distinct T, branch_name from branch T, branch S
Where T. assets S. assets and S. branch_city “Mumbai”
Finds the names of (September Paper-III)
Choices
Choice (4) | Response | |
---|---|---|
a. | All branches that have greater assets than some branch located in Mumbai. | |
b. | All branches that have greater assets than all branches in Mumbai. | |
c. | The branch that has greatest asset in Mumbai. | |
d. | Any branch that has greater assets than any branch in Mumbai. |