INTERVIEW QUESTIONS

    Wipro Technical Interview Questions & HR Questions For Freshers 2023

    DeepikaBy Updated:No Comments11 Mins Read

    Wipro Technical Interview Questions 2022 – Wipro Technical Interview Questions and answer & HR interview Questions For Freshers 2022

    What the use of IP address

    An Internet Protocol address (IP address) is a numerical label assigned to each device (e.g., computer, printer) participating in a computer network that uses the Internet Protocol for communication.An IP address serves two principal functions: host or network interface identification and location addressing

    <img decoding=

    What is difference between UNIQUE and PRIMARY KEY constraints?

    A UNIQUE constraint is similar to PRIMARY key, but you can have more than one UNIQUE constraint per table. Contrary to PRIMARY key UNIQUE constraints can accept NULL but just once. If the constraint is defined in a combination of fields, then every field can accept NULL and can have some values on them, as long as the combination values is unique.

    What are the steps involved in designing?

    Project plan, Requirements, Design, Coding, Testing, Re-coding and design, Development, Maintenance.

    what is the difference between interface and multiple interface?

    Both an abstract class and an interface are specific types of computer objects that allow a programmer to loosely define one type of object as if it were another type, while retaining all of the object’s original properties. While multiple different computer languages use one or both of these concepts, Java is the most well-known. Abstract classes and interfaces have a variety of similarities, but also incorporate significant differences in structure, syntax, and usage.

    How can we delete Duplicate row in table?

    SQL> delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name);

    When do you use SQL Profiler?


    SQL Profiler utility allows us to basically track connections to the SQL Server and also determine activities such as which SQL Scripts are running, failed jobs etc..

    What do you meant by active and passive objects?

    Active objects are one which instigate an interaction which owns a thread and they are responsible for handling control to other objects. In simple words it can be referred as client.
    Passive objects are one, which passively waits for the message to be processed. It waits for another object that requires its services. In simple words it can be referred as server.

    What do you meant by static and dynamic modeling?

    Static modeling is used to specify structure of the objects that exist in the problem domain. These are expressed using class, object and USECASE diagrams.
    But Dynamic modeling refers representing the object interactions during runtime. It is represented by sequence, activity, collaboration and statechart diagrams.

    What is Program counter?

    Program counter holds the address of either the first byte of the next instruction to be fetched for execution or the address of the next byte of a multi byte instruction, which has not been completely fetched. In both the cases it gets incremented automatically one by one as the instruction bytes get fetched. Also Program register keeps the address of the next instruction.

    Can you give an example of Stored Procedure?

    CREATE procedure – is a stored procedure, which is a saved collection of Transact-SQL statements that can take and return user-supplied parameters.

    Benefits of Stored Procedures?

    Reduced client/server traffic
    Efficient reuse of code and programming abstraction
    Enhanced security controls

    Is XML case-sensitive?

    XML is case sensitive when uppercase and lowercase characters are treated differently.
    Element type names, Attribute names, Attribute values, All general and parameter entity names, and data content (text),are case-sensitive.

    What is a Null object?

    It is an object of some class whose purpose is to indicate that a real object of that class does not exist. One common use for a null object is a return value from a member function that is supposed to return an object with some specified properties but cannot find such an object.

    What is the property of class?


    A property is a member that provides access to an attribute of an object or a class. Examples of properties include the length of a string, the size of a font, the caption of a window, the name of a customer, and so on.
    Does a class inherit the constructors of its super class?

    A class does not inherit constructors from any of its super classes.

    If a class is declared without any access modifiers, where may the class be accessed?

    A class that is declared without any access modifiers is said to have package access. This means that the class can only be accessed by other classes andinterfaces that are defined within the same package

    What do you mean by Stack unwinding?

    It is a process during exception handling when the destructor is called for all local objects between the place where the exception was thrown and where it is caught.

    Define precondition and post-condition to a member function.

    Precondition: A condition that should return true when a member function is invoked. In order to use a function correctly a precondition should return true. If a precondition fails to hold, an operation will not take responsibility to perform any action of sensibility. For example, the interface invariants of stack class respond nothing about pushing even though the stack is already full. In this scenario, sinful () is a precondition for push operation.

    Post-Condition: A condition that should return true before returning from an invoked function. In order to use a function correctly a post condition should return true. Taking a stack as an example, is empty () must necessarily be true after pushing the element into the stack when an element is pushed. The function is empty () is a post condition.

    How can you sort the elements of the array in descending order?

    Syntax

    B = sort(A)
    B = sort(A,dim)
    B = sort(…,mode)
    [B,IX] = sort(A,…)


    Description

    B = sort(A) sorts the elements along different dimensions of an array, and arranges those elements in ascending order.

    If A is a … sort(A) …

    Vector Sorts the elements of A.

    Matrix Sorts each column of A.

    Multidimensional array Sorts A along the first non-singleton dimension, and returns an array of sorted vectors.

    Cell array of strings Sorts the strings in ascending ASCII dictionary order, and returns a vector cell array of strings. The sort is case-sensitive; uppercase letters appear in the output before lowercase. You cannot use the dim or mode options with a cell array.

    Sort – Sort array elements in ascending or descending order

    Integer, floating-point, logical, and character arrays are permitted. Floating-point arrays can be complex. For elements of A with identical values, the order of these elements is preserved in the sorted list. When A is complex, the elements are sorted by magnitude, i.e., abs(A),and where magnitudes are equal, further sorted by phase angle, i.e., angle(A),on the interval [??, ?]. If A includes any NaN elements, sort places these at the high end.

    B = sort(A,dim) sorts the elements along the dimension of A specified by a scalar dim.
    B = sort(…,mode) sorts the elements in the specified direction, depending on the value of mode.
    ‘ascend’
    Ascending order (default)
    ‘descend’
    Descending order
    [B,IX] = sort(A,…) also returns an array of indices IX, where size(IX) == size(A). If A is a vector, B = A(IX). If A is an m-by-n matrix, then each column of IX is a permutation vector of the corresponding column of A, such that
    for j = 1:n
    B(:,j) = A(IX(:,j),j);
    end
    If A has repeated elements of equal value, the returned indices preserve the original ordering.

    Example:Sort horizontal vector A:

    A = [78 23 10 100 45 5 6];

    sort(A)
    ans =5 6 10 23 45 78 100

    What is DOM?

    The Document Object Model (DOM) is a cross-platform and language-independent convention for representing and interacting with objects in HTML, XHTML and XML documents.[1] Objects in the DOM tree may be addressed and manipulated by using methods on the objects. The public interface of a DOM is specified in its application programming interface (API).

    How macro execution is faster than function ?

    Difference between overloading and overriding in programming language is:

    a) In overloading, there is a relationship between methods available in the same class whereas in overriding, there is relationship between a superclass method and subclass method.

    b) Overloading does not block inheritance from the superclass whereas overriding blocks inheritance from the superclass.

    c) In overloading, separate methods share the same name whereas in overriding, subclass method replaces the superclass.

    d) Overloading must have different method signatures whereas overriding must have same signature.

    what do you mean by realization in oops, what is persistent, transient object.

    Name the operators that cannot be overloaded.?

    There are 5 operators which cannot be overloaded. They are:

    .* – class member access operator

    :: – scope resolution operator

    . – dot operator

    ?:: – conditional operator

    Sizeof() – operator

    Note:- This is possible only in C++.

    What is polymorphism?

    In programming languages, polymorphism means that some code or operations or objects behave differently in different contexts.

    For example, the + (plus) operator in C++:

    4 + 5 <– integer addition
    3.14 + 2.0 <– floating point addition
    s1 + “bar” <– string concatenation!

    In C++, that type of polymorphism is called overloading.

    Typically, when the term polymorphism is used with C++, however, it refers to using virtual methods, which we’ll discuss shortly.

    What are the differences between a C++ struct and C++ class?

    The default member and base class access specifiers are different.

    The C++ struct has all the features of the class. The only differences are that a struct defaults to public member access and public base class inheritance, and a class defaults to the private access specifier and private base class inheritance.

    Before interview Please Refer this following programming Questions

    Write a Program for :

    1.palindrome for string and number

    2.String Reverse

    3.Sum,Average of all the number

    4.Prime no

    5.Armstrong no

    6.fibonacci

    7.factorial

    8.prime number,

    1. Palindrome for string

    include

    main()
    {
    char a[100], b[100];

    printf(“Enter the string to check if it is a palindrome\n”);
    gets(a);

    strcpy(b,a);
    strrev(b);

    if( strcmp(a,b) == 0 )
    printf(“Entered string is a palindrome.\n”);
    else
    printf(“Entered string is not a palindrome.\n”);

    return 0;
    }

    Palindrome number in c

    include

    main()
    {
    int n, reverse = 0, temp;

    printf(“Enter a number to check if it is a palindrome or not\n”);
    scanf(“%d”,&n);

    temp = n;

    while( temp != 0 )
    {
    reverse = reverse * 10;
    reverse = reverse + temp%10;
    temp = temp/10;
    }

    if ( n == reverse )
    printf(“%d is a palindrome number.\n”, n);
    else
    printf(“%d is not a palindrome number.\n”, n);

    return 0;
    }

    Reverse a string using C programming

    include

    include

    main()
    {
    char arr[100];

    printf(“Enter a string to reverse\n”);
    gets(arr);

    strrev(arr);

    printf(“Reverse of entered string is \n%s\n”,arr);

    return 0;
    }

    /* Fibonacci Series c language */

    include

    main()
    {
    int n, first = 0, second = 1, next, c;

    printf(“Enter the number of terms\n”);
    scanf(“%d”,&n);

    printf(“First %d terms of Fibonacci series are :-\n”,n);

    for ( c = 0 ; c < n ; c++ )
    {
    if ( c <= 1 )
    next = c;
    else
    {
    next = first + second;
    first = second;
    second = next;
    }
    printf(“%d\n”,next);
    }

    return 0;
    }

    Fibonacci series program in c using recursion

    include

    int Fibonacci(int);

    main()
    {
    int n, i = 0, c;

    scanf(“%d”,&n);

    printf(“Fibonacci series\n”);

    for ( c = 1 ; c <= n ; c++ )
    {
    printf(“%d\n”, Fibonacci(i));
    i++;
    }

    return 0;
    }

    int Fibonacci(int n)
    {
    if ( n == 0 )
    return 0;
    else if ( n == 1 )
    return 1;
    else
    return ( Fibonacci(n-1) + Fibonacci(n-2) );
    }

    Adding numbers in c using function

    include

    long addition(long, long);

    main()
    {
    long first, second, sum;

    scanf(“%ld%ld”, &first, &second);

    sum = addition(first, second);

    printf(“%ld\n”, sum);

    return 0;
    }

    long addition(long a, long b)
    {
    long result;

    result = a + b;

    return result;
    }

    HR Questions For Freshers 2022

    1. Tell me something about yourself.
    2. Do you recall the topic you wrote the essay on?
    3. Which is your dream company?
    4. Do you plan to do a master’s degree in future?
    5. Does any CEO or Chairperson’s life inspire you? How?
    6. Why do you want to join Wipro?
    7. Are you fine with relocation?
    8. Are you comfortable with the 15-month agreement with Wipro?
    9. Where do you see yourself in next 5 years?
    10. Tell me about your internships/projects?
    11. Any preferred location?
    12. Is there any gap in your studies, or any backlogs?
    13. What do you know about Wipro?
    14. If you get in conflict with one of your colleagues, how would you deescalate the situation?
    15. Why do you want to work in the IT sector when you are from a non-CS branch?

    Additional Reading

    READ MORE

    If you found this post useful, don’t forget to share this with your friends, and if you have any query feel free to comment it in the comment section.

    Thank you 🙂 Keep Learning !

    Share.

    Related Posts

    Leave A Reply