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

Appeared in Year: 2016 (UGC-NET)

Question

MCQ▾

Consider the following two commands C1 and C2 on the relation R from an SQL database:

C1: drop table R;

C2: delete from R;

Which of the following statements is TRUE?

I. Both C1 and C2 delete the schema for R.

II. C2 retains relation R, but deletes all tuples in R.

III. C1 deletes not only all tuples of R, but also the schema for R.

Choices

Choice (4)Response

a.

I, II and III

b.

I only

c.

I and II only

d.

II and III only

Question 396

Appeared in Year: 2016 (UGC-NET)

Question

MCQ▾

An attacker sits between customer and Banker, and captures the information from the customer and retransmits to the banker by altering the information. This attack is called as …

Choices

Choice (4)Response

a.

Replay Attack

b.

Passive Attack

c.

Masquerade Attack

d.

Denial of Service Attack

Question 397

Appeared in Year: 2016 (UGC-NET)

Question

MCQ▾

Consider the following game tree in which root is a maximizing node and children are visited left to right. What nodes will be pruned by the alpha-beta pruning?

The Alpha-Beta Pruning

Choices

Choice (4)Response

a.

GHI

b.

I

c.

HI

d.

CHI

Question 398

Appeared in Year: 2016 (UGC-NET)

Question

MCQ▾

Which of the following statements is TRUE?

The decomposition of the schema into and is always lossless.

: The decomposition of the schema having into and is lossless.

Choices

Choice (4)Response

a.

Only

b.

Neither and

c.

and

d.

Only

Developed by: