GATE DA topic:computing PYQs & Answers — Page 9

Questions 81–90 of 195. Imported answers require independent review unless marked reviewed.

If a relational decomposition is not dependency-preserving, which one of the following relational operators will be executed more frequently in order to maintain the dependencies?

Your answerChoose one option.

Selection

Projection

Join

Set union

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

Consider the following three relations:

Car (model, year, serial, color)

Make (maker, model)

Own (owner, serial)

A tuple in Car represents a specific car of a given model, made in a given year, with a serial number and a color. A tuple in Make specifies that a maker company makes cars of a certain model. A tuple in Own specifies that an owner owns the car with a given serial number. Keys are underlined; (owner, serial) together form key for Own. (

denotes natural join)

Which one of the following options describes what the above expression computes?

Your answerChoose one option.

All owners of a red car, a car made by ABC, or a red car made by ABC

All owners of more than one car, where at least one car is red and made by ABC

All owners of a red car made by ABC

All red cars made by ABC

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

Consider a hash table of size 10 with indices

, with the hash function

where linear probing is used to handle collisions. The hash table is initially empty and the following sequence of keys is inserted into the hash table: 1, 4, 5, 6, 14, 15. The indices where the keys 14 and 15 are stored are, respectively

Your answerChoose one option.

2 and 5

2 and 6

4 and 5

4 and 6

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

Let

be a continuous random variable whose cumulative distribution function (CDF)

, for some

, is given as follows:

If the median of

is 3, then what is the value of

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

Let

, where

is a standard normal random variable, and

are two unknown constants. It is given that

where

denotes the expectation of random variable

. The values of

are:

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

It is given that

for an exponentially distributed random variable

with

, where

denotes the expectation of

. What is the value of

(ln denotes natural logarithm)

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

Consider designing a linear classifier

on a dataset

. Recall that the sign function outputs +1 if the argument is positive, and −1 if the argument is non-positive. The parameters

and

are updated as per the following training algorithm:

whenever

. In other words, whenever the classifier wrongly predicts a sample

from the dataset,

gets updated to

, and likewise

gets updated to

. Consider the case

. Then

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

Consider the following Python declarations of two lists.

A=[1,2,3]

B=[4,5,6]

Which one of the following statements results in A=[1,2,3,4,5,6]?

Your answerChoose one option.

A.extend(B)

A.append(B)

A.update(B)

A.insert(B)

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

Consider two functions

and

. Both functions are differentiable at a point

. Which of the following functions is/are ALWAYS differentiable at

? The symbol

denotes product and the symbol

denotes composition of functions.

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

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

Which of the following statements is/are correct?

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

has a unique set of orthonormal basis vectors

does not have a unique set of orthonormal basis vectors

Linearly independent vectors in

are orthogonal

Orthonormal vectors

are linearly independent

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 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25