GATE (Graduate Aptitude Test in Engineering) Computer Science: Questions 2052 - 2053 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 2052

Question

MCQ▾

Two concurrent executing transactions T1 and T2 can update same stock item says ‘A’ in an uncontrolled manner. In such scenario, following problems may occur:

Which of the following option is correct if database system has no concurrency module and allows concurrent execution of the above two transactions? (December)

Choices

Choice (4)Response

a.

Dirty read problem

b.

Lost update problem

c.

Transaction failure

d.

Inconsistent database state

Question 2053

Appeared in Year: 2020

Question

MCQ▾

An organization requires a range of IP address to assign one to each of its 1500 computers. The organization has approached an Internet Service Provider (ISP) for this task. The ISP uses CIDR and serves the requests from the available IP address space 202.61.0.0 ⁄ 17. The ISP wants to assign an address space to the organization which will minimize the number of routing entries in the ISP՚s router using route aggregation. Which of the following address spaces are potential candidates from which the ISP can allot any one of the organizations?

Choices

Choice (4)Response

a.

202.61.64.0 ⁄ 21

b.

202.61.144.0 ⁄ 21

c.

202.61.104.0 ⁄ 21

d.

Both c. and a. are correct

Developed by: