GATE CSE topic:computing PYQs & Answers — Page 89

Home
GATE
Computer Science and Information Technology
Topics
topic:computing

Questions 881–890 of 975. Imported answers require independent review unless marked reviewed.

Topic practice 975 questionsPage 89 of 98

Consider socket API on a Linux machine that supports connected UDP sockets. A connected UDP socket is a UDP socket on which connect function has already been called. Which of the following statements is/are CORRECT?

I. A connected UDP socket can be used to communicate with multiple peers simultaneously. II. A process can successfully call connect function again for an already connected UDP socket.

Your answerChoose one option.

I only

II only

Both I and II

Neither I nor II

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

Let X be a Gaussian random variable with mean 0 and variance σ². Let Y = max(X, 0) where max(a, b) is the maximum of a and b. The median of Y is __________.

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

Consider the following tables T1 and T2.

T1:

P	Q
2	2
3	8
7	3
5	8
6	9
8	5
9	8

T2:

R	S
2	2
8	3
3	2
9	7
5	7
7	2

In table T1, P is the primary key and Q is the foreign key referencing R in table T2 with on-delete cascade and on-update cascade. In table T2, R is the primary key and S is the foreign key referencing P in table T1 with on-delete set NULL and on-update cascade. In order to delete record (3, 8) from table T1, the number of additional records that need to be deleted from table T1 is __________.

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

Let T be a tree with 10 vertices. The sum of the degrees of all the vertices in T is __________.

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

The maximum number of IPv4 router addresses that can be listed in the record route (RR) option field of an IPv4 header is __________.

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

Consider the Karnaugh map given below, where X represents “don’t care” and blank represents 0.

Karnaugh map columns labelled

: 00, 01, 11, 10; rows labelled

: 00, 01, 11, 10. Cell values: row 00: blank, X, X, blank; row 01: 1, blank, blank, X; row 11: 1, blank, blank, 1; row 10: blank, X, X, blank.

Diagram for Computer Science and Information Technology question 21

Assume for all inputs

, the respective complements

are also available. The above logic is implemented using 2-input NOR gates only. The minimum number of gates required is ____________.

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

Consider the set

under the partial ordering

. The Hasse diagram of the partial order

is shown below.

The minimum number of ordered pairs that need to be added to

to make

a lattice is __________.

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

Consider the language

given by the regular expression

over the alphabet

. The smallest number of states needed in a deterministic finite-state automaton (DFA) accepting

is ____________.

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

Let

and

be two matrices. Then the rank of

is __________.

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

Consider a database that has the relation schema EMP (EmpId, EmpName, and DeptName). An instance of the schema EMP and a SQL query on it are given below.

EMP:

EmpId	EmpName	DeptName
1	XYA	AA
2	XYB	AA
3	XYC	AA
4	XYD	AA
5	XYE	AB
6	XYF	AB
7	XYG	AB
8	XYH	AC
9	XYI	AC
10	XYJ	AC
11	XYK	AD
12	XYL	AD
13	XYM	AE

SQL:

SELECT AVG(EC.Num)

FROM EC

WHERE (DeptName, Num) IN

(SELECT DeptName, COUNT(EmpId) AS

EC(DeptName, Num)

FROM EMP

GROUP BY DeptName)

The output of executing the SQL query is ____________.

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

GATE CSE topic:computing PYQs

Question 18

Question 19

Question 19

Question 20

Question 20

Question 21

Question 21

Question 22

Question 22

Question 23

EmpId	EmpName	DeptName
1	XYA	AA
2	XYB	AA
3	XYC	AA
4	XYD	AA
5	XYE	AB
6	XYF	AB
7	XYG	AB
8	XYH	AC
9	XYI	AC
10	XYJ	AC
11	XYK	AD
12	XYL	AD
13	XYM	AE

EmpId	EmpName	DeptName
1	XYA	AA
2	XYB	AA
3	XYC	AA
4	XYD	AA
5	XYE	AB
6	XYF	AB
7	XYG	AB
8	XYH	AC
9	XYI	AC
10	XYJ	AC
11	XYK	AD
12	XYL	AD
13	XYM	AE

EmpId	EmpName	DeptName
1	XYA	AA
2	XYB	AA
3	XYC	AA
4	XYD	AA
5	XYE	AB
6	XYF	AB
7	XYG	AB
8	XYH	AC
9	XYI	AC
10	XYJ	AC
11	XYK	AD
12	XYL	AD
13	XYM	AE