GATE (Graduate Aptitude Test in Engineering) Computer Science & IT (CS): Questions 1177 - 1181 of 3196

Choose Programs:

🎓 Study Material (1190 Notes): 2024-2025 Syllabus

Rs. 1000.00 -OR-

3 Year Validity (Multiple Devices)

Topic-wise Notes & SampleDetails

🎯 302 Numeric, 2894 MCQs (& PYQs) with Full Explanations (2024-2025 Exam)

Rs. 650.00 -OR-

3 Year Validity (Multiple Devices)

CoverageDetailsSample Explanation

Help me Choose & Register (Watch Video) Already Subscribed?

Question 1177

Appeared in Year: 2014

Question MCQ▾

Which of the following is true?

I. Implementation of self-join is possible in SQL with table alias.

II. Outer-join operation is basic operation in relational algebra.

III. Natural join and outer join operations are equivalent. (December Paper II)

Choices

Choice (4)Response

a.

I and II are correct.

b.

II and III are correct.

c.

Only I is correct.

d.

Only III is correct.

Edit

Question 1178

Appeared in Year: 2014

Question MCQ▾

Suppose that the splits at every level of quicksort are in the proportion is a constant. The minimum depth of a leaf in the recursion tree is approximately given by (June paper III)

Choices

Choice (4)Response

a.

b.

c.

d.

Edit

Question 1179

Appeared in Year: 2017

Question MCQ▾

Which of the following cannot be passed to a function in C ++ ? (January paper II)

Choices

Choice (4)Response

a.

Constant

b.

Structure

c.

Array

d.

Header file

Edit

Question 1180

Appeared in Year: 2014

Question MCQ▾

Maximum possible value of reliability is (December Paper III)

Choices

Choice (4)Response

a.

0

b.

10

c.

100

d.

1

Edit

Question 1181

Appeared in Year: 2017

Question MCQ▾

Which of the following devices takes data sent from one network device and forwards it to the destination node based on MAC address? (November Paper II)

Choices

Choice (4)Response

a.

Gateway

b.

Modem

c.

Hub

d.

Switch

Edit