GATE (Graduate Aptitude Test in Engineering) Computer Science & IT (CS): Questions 430 - 432 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 430

Appeared in Year: 2016

Question MCQ▾

Given the following statements:

(1) To implement Abstract Data Type, a programming language require a syntactic unit to encapsulate type definition.

(2) To implement ADT, a programming language requires some primitive operations that are built in the language processor.

(3) C ++ , Ada, Java 5.0, C#2005 provide support for parameterised ADT.

Which one of the following options is correct?

Choices

Choice (4)Response

a.

(1) , (2) and (3) are false.

b.

(1) is true; (2) and (3) are false.

c.

(1) , (2) and (3) are true.

d.

(1) and (2) are true; (3) are false.

Edit

Question 431

Appeared in Year: 2016

Question Match List-Ⅰ List-Ⅱ▾

Match the following:

List-Ⅰ (Group I)List-Ⅱ (Group II)
(A)

Controlled Inverter

(i)

A circuit that can add 3 bits

(B)

Full adder

(ii)

A circuit that can add two binary numbers

(C)

Binary adder

(iii)

A logic circuit that adds 2 bits

(D)

Half adder

(iv)

A circuit that transmits a binary word or its1՚s complement

Choices

Choice (4)Response
  • (A)
  • (B)
  • (C)
  • (D)

a.

  • (ii)
  • (iii)
  • (i)
  • (iv)

b.

  • (i)
  • (iv)
  • (iii)
  • (ii)

c.

  • (i)
  • (iii)
  • (iv)
  • (ii)

d.

  • (iv)
  • (i)
  • (ii)
  • (iii)

Edit

Question 432

Appeared in Year: 2016

Question MCQ▾

Consider the following ORACLE relations:

Consider the following two SQL queries and :

  1. SQ1:SELECT R.B, AVG(S.B)
  2. FROM R, S
  3. WHERE R.A =S.C AND S.D <7
  4. GROUP BY R.B;
  5. SQ2:SELECT DISTINCT S.B, MIN (S.C)
  6. FROM S
  7. GROUP BY S.B
  8. HAVING COUNT (DISTINCT S.D) >1;

If M is the number of tuples returned by SQ1 and N is the number of tuples returned by SQ2 then

Choices

Choice (4)Response

a.

b.

c.

d.

Edit