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

Edit

Question 1045

Appeared in Year: 2014

Question MCQ▾

How to express that some person keeps animals as pets? (December Paper III)

Choices

Choice (4)Response

a.

In ER Diagrams: Choice A

b.

In ER Diagrams: Choice B

c.

In ER Diagrams: Choice C

d.

In ER Diagrams: Choice D

Edit

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 .

Edit

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

Edit