GATE CSE 2020 Paper 1 — page 8

Questions 22–24 of 65. Imported answers require review unless explicitly marked reviewed.

Consider the following statements about process state transitions for a system using preemptive scheduling.

I. A running process can move to ready state.

II. A ready process can move to running state.

III. A blocked process can move to running state.

IV. A blocked process can move to ready state.

Which of the above statements are TRUE?

Your answerChoose one option.

I, II, and III only

II and III only

I, II, and IV only

I, II, III, and IV

You can attempt this question now. Sign in to view the answer key, explanations and discussion.Log in to check answer

Consider a relational database containing the following schemes.

Catalogue:

Suppliers:

Parts:

The primary key of each table is indicated by underlining the constituent fields.

SELECT s.sno, s.sname FROM Suppliers s, Catalogue c WHERE s.sno = c.sno AND cost > (SELECT AVG(cost) FROM Catalogue WHERE pno = ‘P4’ GROUP BY pno);

The number of rows returned by the above SQL query is

Your answerChoose one option.

You can attempt this question now. Sign in to view the answer key, explanations and discussion.Log in to check answer

Which one of the following is used to represent the supporting many-one relationships of a weak entity set in an entity-relationship diagram?

Your answerChoose one option.

Diamonds with double/bold border

Rectangles with double/bold border

Ovals with double/bold border

Ovals that contain underlined identifiers

You can attempt this question now. Sign in to view the answer key, explanations and discussion.Log in to check answer

2020 · Paper 1