GATE (Graduate Aptitude Test in Engineering) Computer Science: Questions 1046 - 1048 of 2080

Access detailed explanations (illustrated with images and videos) to 2080 questions. Access all new questions- tracking exam pattern and syllabus. View the complete topic-wise distribution of questions. Unlimited Access, Unlimited Time, on Unlimited Devices!

View Sample Explanation or View Features.

Rs. 550.00 -OR-

How to register? Already Subscribed?

Question 1046

Appeared in Year: 2014 (UGC-NET)

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 1047

Appeared in Year: 2014 (UGC-NET)

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

Question 1048

Appeared in Year: 2014 (UGC-NET)

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 .

Developed by: