Databases-Relational Model [GATE (Graduate Aptitude Test in Engineering) Computer Science & IT (CS)]: Questions 1 - 6 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 1
Question MCQ▾
Candidate key has only one ________in a table but there can be multiple candidate keys.
Choices
Choice (4) | Response | |
---|---|---|
a. | Primary Key | |
b. | Alternative Key | |
c. | Candidate Key | |
d. | Question does not provide sufficient data or is vague |
Question 2
Question MCQ▾
A domain is atomic if elements of the domain are considered to be indivisible units and relation schema R is in ________ if the domains of all attributes of R are atomic.
Choices
Choice (4) | Response | |
---|---|---|
a. | second normal form | |
b. | first normal form | |
c. | third normal form | |
d. | All of the above |
Question 3
Question MCQ▾
________ are the most elementary form of integrity constraint.
Choices
Choice (4) | Response | |
---|---|---|
a. | Consistency | |
b. | Domain constraints | |
c. | Keys | |
d. | Referential integrity |
Question 4
Question MCQ▾
A functional dependency is a relationship between or among:
Choices
Choice (4) | Response | |
---|---|---|
a. | Tables | |
b. | Rows | |
c. | Attributes | |
d. | Relations |
Question 5
Appeared in Year: 2015
Question MCQ▾
A relation R = {A, B, C, D, E, F, G} is given with following set of functional dependencies:
Which of the following is a candidate key? (December)
Choices
Choice (4) | Response | |
---|---|---|
a. | A | |
b. | ABD | |
c. | ABC | |
d. | AB |
Question 6
Appeared in Year: 2015
Question Match List-Ⅰ List-Ⅱ▾
Match the following database terms to their functions: (December)
List-Ⅰ | List-Ⅱ |
(A) External Schema | (i) Define view (s) of the database for particular user (s) |
(B) Referential Integrity | (ii) Enforces match of primary key to foreign key |
(C) Normalization | (iii) Reduces data redundancy in a database |
(D) Data Dictionary | (iv) Contains metadata describing database structure. |
Choices
Choice (4) | Response | |
---|---|---|
| ||
a. |
| |
b. |
| |
c. |
| |
d. |
|