GATE (Graduate Aptitude Test in Engineering) Computer Science & IT (CS): Questions 1044 - 1047 of 3196
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 1044
Appeared in Year: 2014
Question MCQ▾
Which of the following is correct?
I. Two phase locking is an optimistic protocol.
II. Two phase locking is pessimistic protocol
III. Time stamping is an optimistic protocol.
IV. Time stamping is pessimistic protocol. (December Paper III)
Choices
Choice (4) | Response | |
---|---|---|
a. | I and IV | |
b. | II and IV | |
c. | I and III | |
d. | II and III |
Question 1046
Appeared in Year: 2014
Question MCQ▾
Consider the following relational schemas for a library database: Book (Title, Author, Catalog no, Publisher, Year, Price) Collection (Title, Author, Catalog_no) with the following functional dependencies:
I:
II:
III:
Assume (Author, Title) is the key for both schemas. Which one of the following is true? (June paper III)
Choices
Choice (4) | Response | |
---|---|---|
a. | Book and Collection are in BCNF. | |
b. | Book and Collection are in . | |
c. | Book is in and Collection in . | |
d. | Book and Collection are in . |
Question 1047
Appeared in Year: 2014
Question MCQ▾
KPA in CMM stands for (June paper II)
Choices
Choice (4) | Response | |
---|---|---|
a. | Key Product Area | |
b. | Key Process Area | |
c. | Key Performance Area | |
d. | Key Principal Area |