GATE DA topic:computing PYQs & Answers — Page 6

Questions 51–60 of 195. Imported answers require independent review unless marked reviewed.

Consider a table Employee(EmpID, TeamID), where the column EmpID (ID of an employee) is the primary key. The column TeamID denotes the team ID of the team of which the employee is a member. TeamID is a NOT NULL column.

We want to display the size of the team (denoted as TeamSize) in which each employee is a member by using SQL. As an example, the desired output for the given Employee table is also shown in tabular form.

Employee

EmpID	TeamID
1	8
2	8
3	8
4	7
5	7
6	9

Output

EmpID	TeamSize
1	3
2	3
3	3
4	2
5	2
6	1

Which of the following is/are correct?

Your answerSelect all correct options. You can choose more than one.

SELECT E.EmpID, B.TeamSize

FROM Employee AS E, (SELECT TeamID, COUNT(TeamID) AS TeamSize FROM Employee GROUP BY TeamID) AS B

WHERE E.TeamID = B.TeamID

SELECT A.EmpID, COUNT(B.TeamID) AS TeamSize

FROM Employee AS A, Employee AS B

WHERE A.TeamID = B.TeamID AND A.EmpID = B.EmpID

GROUP BY A.EmpID

SELECT B.EmpID, B.TeamSize

FROM (SELECT EmpID, COUNT(TeamID) AS TeamSize

FROM Employee GROUP BY EmpID) AS B

SELECT A.EmpID, B.TeamSize

FROM Employee AS A, (SELECT COUNT(TeamID) AS TeamSize FROM Employee GROUP BY TeamID) AS B

WHERE A.TeamID = B.TeamID

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

Let

be a matrix, where

and

is the identity matrix of order

. Which of the following options is/are correct?

Your answerSelect all correct options. You can choose more than one.

is a projection matrix

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

Let

independent random variables. Each of the random variables follows

distribution. Define

. Which of the following statements is/are correct?

Your answerSelect all correct options. You can choose more than one.

follows Chi-square distribution with

degrees of freedom.

follows Chi-square distribution with

degrees of freedom.

follows exponential distribution with mean 2.

follows Chi-square distribution with 2 degrees of freedom.

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

Let

be a discrete valued random variable with cumulative distribution function

. Which of the following statements is/are correct?

Your answerSelect all correct options. You can choose more than one.

is always a positive function.

is a non-decreasing function.

has jump discontinuity.

is a left continuous function.

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

Consider that Linear Ridge Regression is being used to learn a prediction function

, where

and Mean Absolute Error (MAE) is used to measure the prediction error. A weight of 0.20 is associated with the regularizer.

At an intermediate step of the training process, assume that the parameter

. In the next step, for the input

, the predicted value of

is noted. Let the relation between

and the true value of

The value of the overall regularized loss function for this instance is _____. (Rounded off to two decimal places)

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

Consider a fully-connected feed-forward multi-layer perceptron. It has 30 neurons in the input layer, followed by two hidden layers and an output layer. The first hidden layer has 4 neurons and the second hidden layer has 3 neurons. The output layer has only one neuron. Assume that no bias parameters are used.

The number of learnable parameters in the multi-layer perceptron is __________ . (Answer in integer)

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

A clinic specializes in testing for a disease D. The result of the test can be either positive or negative.

A study revealed that if a person suffers from the disease D, the test result in that clinic comes out positive 80% of the time, and negative 20% of the time. If a person is not suffering from the disease D, the test comes out positive 10% of the time and negative 90% of the time. It is also known that among the general population, the disease D occurs in 30% of the individuals.

If a person tests positive for D in that clinic, the probability that he/she actually suffers from the disease D is ________ . (Rounded off to two decimal places)

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

Consider the given Python program.

def fun(L, i=0):

if i >= len(L)-1:

return 0

if L[i] > L[i+1]:

L[i+1], L[i] = L[i], L[i+1]

return 1+fun(L, i+1)

else:

return fun(L, i+1)

data = [5, 3, 4, 1, 2]

count = 0

for _ in range(len(data)):

count += fun(data)

print(count)

The output of the program is __________. (Answer in integer)

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

Let there be two relations

and

as shown.

has three columns

and

has two columns

and


P1	Q1	R1
P2	Q2	R2
P3	Q3	R2


P1	10
P1	15
P2	20
P3	1

Consider that the following tuple relational calculus expression is evaluated.

The number of tuples that will be returned is ________ . (Answer in integer)

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

Let Account be a relation as shown.

AccNo	Balance
A1	5000
A2	5000
A3	1000
A4	1500
A5	1800

Consider the given SQL query.

SELECT AccNo FROM Account AS A

WHERE (SELECT COUNT(*) FROM Account AS B

WHERE A.Balance < B.Balance) >= (SELECT COUNT(*)

FROM Account AS C WHERE A.Balance > C.Balance)

The number of rows returned by the SQL query is ________ . (Answer in integer)

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

GATE DA topic:computing PYQs

Question 51

Question 52

Question 53

Question 54

Question 55

Question 56

Question 57

Question 58

Question 59

Question 60