ICICI Bank Online Assessment MCQS SDE Role

Problem Preview

" ### 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? ```java 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: ```python 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: ```python 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? ```python 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? ```cpp #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: ```python 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? ```python 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? ```cpp #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: ```python 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: ```java 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? ```python 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 ```python 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? ```sql 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: ```python 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!"]`"