MCQ 1

Question: What is the transmission efficiency of the Slotted ALOHA protocol?

Options:

• 36.8%
• 18.4%
• 22.4%
• 26.8%

---

MCQ 2

Question: Bob has a dataset stored in Parquet format in a Cloud Storage bucket and he wants to load it into BigQuery. While loading data into BigQuery from a Cloud Storage bucket, he wants to know about the limitation. Help him to find which of the following is correct about the mentioned context.

Options:

• Changes to the underlying data while a job is running can result in unexpected behavior
• BigQuery guarantees data consistency for external data sources
• Cloud Storage
• He can use a wildcard in the storage URI even if the files have different schemas

---

MCQ 3

Question: Which is the right articulation for the length of a UDP datagram?

Options:

• UDP length = IP length - IP headers length
• UDP length = IP length - UDP headers length
• UDP length = IP length + IP headers length
• UDP length = UDP length - UDP headers length

---

MCQ 4

Question: What is the format of an Ethernet network?

Options:

• IEEE 802.11
• IEEE 802.3
• IEEE 802.5
• IEEE 802.2

---

MCQ 5

Question: While working on a Linux project you have created different files and programs. Now, you have to display all network interfaces on the system to your colleague. Hence, which command will you use for the same?

Options:

• $ ip link show
• $ traceroute network
• $ ip route show
• $ netstat files

---

MCQ 6

Question: In networking, which of the following statements about the TCP ZeroWindow probes is correct?

Statements:

1. The window probes are transferred until space is free in the input window of the remote host.
2. A window probe drives the remote host to return a packet with its updated input window size.

Options:

• 1
• 2
• Both of these
• None of these

---

MCQ 7

Question: John is working on Networking. While working on an application, he got the network address 156.45.0.0/22. He wants to find the subnet mask, the number of subnets that can be created, and the number of hosts in each network but he is unfamiliar with subnetting. Help him to find which of the following will suit the above mentioned context.

Options:

• 255.255.240.0, 32, and 1022
• 255.255.255.0, 64 and 1024
• 255.255.252.0, 64 and 1022
• 255.255.252.0, 32 and 1024

---

MCQ 8

Question: John, a programmer exploring Microsoft SQL Server Database Administration, is eager to learn about the Checkpoint Process in SQL Server. What is the purpose of the Checkpoint Process in the SQL Server?

Options:

• To execute user-specified target recovery time
• To perform syntactical checking of queries
• To reduce recovery time in the event of unexpected shutdown

---

MCQ 9

Question: Consider a non-trivial function dependency A -> B. Which of the following conditions about the dependency will be useful to justify that the given relation is in 3NF?

Conditions:

1. A is a super key
2. B is a prime attribute
3. B is a non-prime attribute

Options:

• 1 and 2
• 2 and 3
• 1 and 3
• None of these

---

MCQ 10

Question: What is the output of the following Java code?

public class Main {
    public static void main(String[] args) {
        IntegerBox<Integer> intBox = new IntegerBox<>(7);
        IntegerBox<Integer> anotherIntBox = new IntegerBox<>(3);
        System.out.println(intBox.getIncrementedValue() + " " + anotherIntBox.getIncrementedValue());
    }
}
class Box<T> {
    T content;
    Box(T item) { content = item; }
    T getContent() { return content; }
}
class IntegerBox<I extends Integer> extends Box<I> {
    IntegerBox(I item) { super(item); }
    int getIncrementedValue() { return getContent() + 1; }
}

Options:

• (Options missing from the provided text snippet. The correct output is 8 4)

---

MCQ 11

Question: What is the output of the following Python code:

def adder1(*args):
    print('adder1', end='')
    if type(args[0])==type(0):
        sum = 0
    else:
        sum=args[0][:0]
    for arg in args:
        sum=sum+arg
    return sum

def adder2(*args):
    print('adder2', end='')
    sum=args[0]
    for next in args[1:]:
        sum += next
    return sum

for func in (adder1, adder2):
    print(func('5', '4', '3'))

Options:

• (Options missing from the provided text snippet)

---

MCQ 12

Question: What is the output of the following Python code:

class Person:
    def __init__(self,name, job=None, pay=0):
        self.name = name
        self.job = job
        self.pay = pay
    def lastName(self):
        return self.name.split()[-1]
    def giveRaise(self,percent):
        self.pay = int(self.pay * (1+percent))
        return self.pay
    def __repr__(self):
        return '[Person: %s, %s]' % (self.name,self.pay)

class Manager:
    def __init__(self,name,pay):
        self.person = Person(name, 'mgr', pay)
    def giveRaise(self, percent, bonus=.10):
        return self.person.giveRaise(percent+bonus)
    def __getattr__(self,attr):
        return getattr(self.person,attr)
    def __repr__(self):
        return str(self.person)

if __name__ == '__main__':
    sue = Person('Sue Jones',job='dev',pay=100000)
    print(sue.lastName())
    print(sue.giveRaise(.10))
    tom=Manager('Tom Jones', pay=50000)
    print(tom.giveRaise(.10))

Options:

• (Options missing from the provided text snippet)

---

MCQ 13

Question: What is the output of the given Python code?

class Parent:
    def __init__(self):
        self._num = 56
    def show(self):
        print("Parent:", self._num)

class Child(Parent):
    def __init__(self):
        super().__init__()
        self._var = 89
    def show(self):
        print("Child:", self._var)

parent=Parent()
parent.show()
child=Child()
child.show()

Options:

• (Options missing from the provided text snippet)

---

MCQ 14

Question: In C++, which of the following statements about the copy constructor is correct?

Options:

• A copy constructor is a member function which initializes an object using another object of the same class
• A copy constructor can be made private
• Both of these
• None of these

---

MCQ 15

Question: What is the output of the following C++ code?

#include <bits/stdc++.h>
using namespace std;
class hacker1{
public:
    int id1;
};
class hacker2: public hacker1{
public:
    int id2;
};
int main(){
    hacker2 obj1;
    obj1.id1 = 7;
    obj1.id2 = 91;
    obj1.id2 = 100;
    obj1.id1 = 110;
    cout << obj1.id2 << endl;
    cout << obj1.id1 << endl;
    return 0;
}

Options:

• (Options missing from the provided text snippet)

---

MCQ 16

Question: A team recently adopted the Agile methodology of product development. Which of the following statements should not be addressed in the team's first Sprint Review meeting after a two week long sprint?

Statements:

1. Things that did not go well and the problems that were faced
2. Relationship of the team members with each other during the sprint
3. Communication barriers between the team and the Product Owner
4. Conflicts over tasks between team members

Options:

• 1 and 2
• 2 and 4
• 3 and 4
• 1 and 3

---

MCQ 17

Question: Anita is the product owner for a software development team using the scrum framework. She wants to make sure the team is well prepared for sprint planning. Which of the following should she make sure the team has in place?

Options:

• A budget for QA and non-feature work
• A large amount of unknown or risk work
• A well-groomed backlog with priorities and dependencies
• A fuzzy view of what's in the scope

---

MCQ 18

Question: John's project manager uses the Agile methodology for his software development project. He is planning for the upcoming sprint with his team using sprint planning, what does the team do with the product backlog?

Options:

• The team does not use the product backlog during sprint planning
• The team refines the product backlog
• The team chooses items from the product backlog for the upcoming sprint
• The team ignores the product backlog and starts working on new features

---

MCQ 19

Question: John is working on a JavaScript codebase that uses class inheritance. He is trying to create a subclass Rectangle that extends the base class Shape. The Shape class has a color property that should be inherited by Rectangle, but the Rectangle class needs to have its own width and height properties. Which of the following options correctly implements this?

Options:

• class Rectangle extends Shape { constructor(color, width, height) { super(color); this.width = width; this.height = height; } }
• class Rectangle extends Shape { constructor(width, height) { super(color); this.width = width; this.height = height; } }
• class Rectangle extends Shape { constructor(width, height) { this.width = width; this.height = height; } }
• class Rectangle extends Shape { constructor(color, width, height) { super(); this.color = color; this.width = width; this.height = height; } }

---

MCQ 20

Question: What is the output of the following Python code:

class Deco:
    def __init__(self):
        self.n = "Python Testing"
    @property
    def prog(self):
        return self.n
    @prog.setter
    def prog(self, val):
        self.n = val
data = Deco()
data.prog = "HackerEarth"
print(data.prog)

Options:

• Python Testing
• HackerEarth
• Python Testing HackerEarth
• Runtime error

---

MCQ 21

Question: Consider the following Python 3 code. Determine the value of wrapper_count.num_calls after the code is run?

import functools
def count(f):
    @functools.wraps(f)
    def wrapper_count(*args, **kwargs):
        wrapper_count.num_calls += 1
        return f(*args, **kwargs)
    wrapper_count.num_calls = 0
    return wrapper_count

@count
def PythonProg():
    print("Python")

PythonProg()
PythonProg()

Options:

• (Options missing from the provided text snippet)

---

MCQ 22

Question: What is the output of the following C++ code?

#include<iostream>
using namespace std;
class Test
{
private:
    int x;
public:
    void setx (int x) { this->x = x; }
    void print() { cout << x << endl; }
};
int main() {
    Test obj;
    int x = 20;
    obj.setx(x);
    obj.print();
    return 0;
}

Options:

• (Options missing from the provided text snippet)

---

MCQ 23

Question: In Python 3, which of the following represent types of infinite iterators?

Statements:

1. count(start, step)
2. cycle(iterable)
3. repeat(val, num)

Options:

• 1 and 2
• 2 and 3
• 1 and 3
• All of these

---

MCQ 24

Question: In Python, which of the following statements about the isalpha() function is correct?

Statements:

1. Indicates whether a character is a letter or not
2. Returns True if the character is a letter, else returns False
3. Indicates whether a character is a number
4. Can be used on string operations only

Options:

• 1, 2, and 3
• 2, 3, and 4
• 1, 2, and 4
• All of these

---

MCQ 25

Question: Bob is working on Data visualization in a company... he wants to know more about annotations. Help him by understanding the correct statement related to annotation from the following according to the above scenario:

Options:

• They take up a lot of space in the plot
• They can be used for feature engineering in the modeling process
• They provide context and make the plot more readable
• They are where the specifications of the coordinates are fixed

---

MCQ 26

Question: What is the output of the following Python code:

class Commuter_new:
    def __init__(self,val):
        self.val=val
    def __add__(self,obj):
        if isinstance(obj, Commuter_new):
            obj = obj.val
        return Commuter_new(self.val+obj)
    def __radd__(self,obj):
        return Commuter_new(obj+self.val)
    def __str__(self):
        return '<Commuter_new:%s>' % self.val

x=Commuter_new(15)
print(x)

Options:

• (Options missing from the provided text snippet)

---

MCQ 27

Question: What is the output of the following Java code:

enum Currency {
    USD(1.18), EUR(1.0), JPY(132.17);
    private double rate;
    Currency(double rate) { this.rate = rate; }
    double convertToUSD(double amount) { return amount * rate; }
}
public class Main {
    public static void main(String[] args) {
        Currency currency = Currency.EUR;
        System.out.println(currency.convertToUSD(50));
    }
}

Options:

• (Options missing from the provided text snippet)

---

MCQ 28

Question: In digital electronics, while manufacturing embedded capacitors, which of the following is an advantage of replacing two-phase composites with three-phase composites?

Options:

• Broad smearing region
• Good lunch
• All of these

---

MCQ 29

Question: What is the output of the following Python code?

import pandas as pd
data=pd.read_csv('Employee_Data.csv')
data['Total']=data['Age']+data['Experience']
print(data)

Options:

• (Options missing from the provided text snippet)

---

MCQ 30

Question: What is the output of the following Python code

import asyncio
async def coroutine(n):
    print(f"{n} is running")
    await asyncio.sleep(1)
    print(f"{n} is done")

async def main():
    await asyncio.gather(
        coroutine(1),
        asyncio.sleep(0.7),
        coroutine(2),
    )
asyncio.run(main())

Options:

• 1 is running, 2 is running, 1 is done, 2 is done
• 1 is running, 1 is done, 2 is running, 2 is done
• 1 is running, 2 is running, 2 is done, 1 is done
• 1 is running, 1 is done, 2 is done, 2 is running

---

MCQ 31

Question: In C++, which of the following statements defines an orthogonal base class?

Options:

• If two base classes have no overlapping methods or data, then they are said to be independent of or orthogonal to each other.
• If two base classes have one or more overlapping methods or data, then they are said to be dependent on each other.
• If two classes operate in the same dimension, then they are said to be orthogonal to each other.
• None of these

---

MCQ 32

Question: In R, which of the following is not an atomic datatype?

Options:

• Character
• Integer
• Data frame
• Logical

---

MCQ 33

Question: In C++, which of the following statements about an anonymous class is true?

Options:

• It cannot have a destructor
• It cannot have a constructor
• It cannot be created
• All of these

---

MCQ 34

Question: What is the output of the following SQL query?

SELECT Item.PName, Item.Price, Brand.BName
FROM Item
INNER JOIN Brand
ON Item.CID = Brand.BID;

Options:

• (Options depict tabulated outputs matching Price, PName, and BName for corresponding IDs)

---

MCQ 35

Question: What is the output of following Python code:

import nltk
from nltk.tokenize import sent_tokenize
text = "I love natural language toolkit. It's fascinating!"
sentences = sent_tokenize(text.lower())
print(sentences)

Options:

• ['i love natural language toolkit.', "it's fascinating!"]
• ["i love natural language toolkit", "it's fascinating"]
• ['i love natural language toolkit', "it's fascinating!"]
• ["i love natural language toolkit.", "it's fascinating!"]