UGC NET CS 2014 Dec - II

Question 11

What will be the output of the following ‘C’ code?

C

#include <stdio.h>

int main()
{
    int x = 128;
    printf("\n%d", 1 + x++);
    
    return 0;
}

• 128

• 129

• 130

• 131

Question 12

When an array is passed as parameter to a function, which of the following statements is correct?

• The function can change values in the original array.
• In C, parameters are passed by value, the function cannot change the original value in the array.
• It results in compilation error when the function tries to access the elements in the array.
• Results in a run time error when the function tries to access the elements in the array.

Question 13

Which of the following differentiates between overloaded functions and overridden functions?

• Overloading is a dynamic or runtime binding and overridden is a static or compile time binding.
• Overloading is a static or compile time binding and overriding is dynamic or runtime binding.
• Redefining a function in a friend class is called overloading, while redefining a function in a derived class is called as overridden function.
• Redefining a function in a derived class is called function overloading, while redefining a function in a friend class is called function overriding.

Question 14

Division operation is ideally suited to handle queries of the type:

• customers who have no account in any of the branches in Delhi.
• customers who have an account at all branches in Delhi.
• customers who have an account in atleast one branch in Delhi.
• customers who have only joint account in any one branch in Delhi

Question 15

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.

• I and II are correct.
• II and III are correct.
• Only III is correct.
• Only I is correct.

Question 16

What kind of mechanism is to be taken into account for converting a weak entity set into strong entity set in entity-relationship diagram?

• Generalization
• Aggregation
• Specialization
• Adding suitable attributes

Question 17

The best normal form of relation scheme R(A, B, C, D) along with the set of functional dependencies F = {AB → C, AB → D, C → A, D → B} is

• Boyce-Codd Normal form
• Third Normal form
• Second Normal form
• First Normal form

Question 18

Identify the minimal key for relational scheme R(A, B, C, D, E) with functional dependencies F = {A → B, B → C, AC → D}

• A
• AE
• BE
• CE

Question 19

Convert the following infix expression into its equivalent post fix expression (A + B^ D) / (E – F) + G

• ABD^ + EF – / G+
• ABD + ^EF – / G+
• ABD + ^EF / – G+
• ABD^ + EF / – G+

Question 20

You have to sort a list L, consisting of a sorted list followed by a few ‘random’ elements. Which of the following sorting method would be most suitable for such a task?

• Bubble sort
• Selection sort
• Quick sort
• Insertion sort