Ind Agiv Commerce Interview Questions and Answers

Q1. Spark code optimization
Add your answer
Q2. Data formats in big Data, why each format.
Ans. 
Different data formats in big data are used for various purposes like storage efficiency, data processing speed, and compatibility with different systems.
• JSON: Lightweight, human-readable, and widely supported for web applications.

• Parquet: Columnar storage format for efficient querying and processing of large datasets.

• Avro: Schema-based serialization format with support for complex data types.

• ORC: Optimized Row Columna...read more
Answered by AI
Add your answer
Q3. Leet code - Most freq elem in a list
Ans. 
Find the most frequent element in a list of strings.
• Iterate through the list and count the frequency of each element using a dictionary.

• Track the element with the highest frequency as you iterate.

• Return the element with the highest frequency.
Answered by AI
Add your answer

Q1. Na not applicable
Add your answer
Q2. Na not applicable right now
Add your answer

Q1. Based on Projects on Resume
Add your answer
Q2. Frequency Divider code
Add your answer

Q1. Question related to AWS cloud
Add your answer
Q2. Questions related to DevOps and System Administration
Add your answer
Q3. Question related to Linux and networking
Add your answer
Q4. Question related to monitoring
Add your answer

Q1. They asked technical question related to .NEt and angular , easy and simple interview
Add your answer

Q1. What are the network operator in india
Ans. 
Some of the major network operators in India are Airtel, Vodafone Idea, Reliance Jio, and BSNL.
• Airtel is one of the largest telecom operators in India, offering services like mobile, broadband, and digital TV.

• Vodafone Idea is a merger of Vodafone India and Idea Cellular, providing mobile services across the country.

• Reliance Jio is known for its 4G network and affordable data plans, disrupting the telecom market in Indi...read more
Answered by AI
Add your answer
Q2. What is 2G,3G and 4G
Ans. 
2G, 3G, and 4G are generations of mobile network technology, each offering faster data speeds and improved capabilities.
• 2G refers to second-generation mobile networks, providing basic voice and text services.

• 3G is the third generation, offering faster data speeds for internet browsing and multimedia applications.

• 4G is the fourth generation, delivering even faster data speeds, lower latency, and support for advanced ser...read more
Answered by AI
Add your answer
Q3. What are the type of tower structure ,GBT,RTTANDRTP
Ans. 
GBT stands for Guyed Tower, RTT stands for Roof Top Tower, and RTP stands for Roof Top Pole.
• GBT (Guyed Tower) is a type of tower structure supported by guy wires.

• RTT (Roof Top Tower) is a tower structure installed on the roof of a building.

• RTP (Roof Top Pole) is a pole structure installed on the roof of a building.
Answered by AI
Add your answer
Q4. Type of sim card
Ans. 
The type of SIM card refers to the physical size and shape of the SIM card, such as standard, micro, or nano.
• Types of SIM cards include standard, micro, and nano sizes

• Standard SIM cards are the largest, micro SIM cards are smaller, and nano SIM cards are the smallest

• Different devices may require different types of SIM cards
Answered by AI
Add your answer
Q5. What is alpha, beta and gamma sector
Ans. 
Alpha, beta, and gamma sectors are divisions used in various industries to categorize different areas or components.
• Alpha sector typically refers to the first or primary sector in a system or project

• Beta sector usually represents the secondary or intermediate sector

• Gamma sector often denotes the tertiary or final sector

• These divisions can be used in project management, software development, manufacturing, etc.
Answered by AI
Add your answer

Q1. Parsnal details
Add your answer
Q2. Knowledge of marke8
Add your answer
Q3. Family backgrounds
Add your answer

Q1. Given two codes to identify there output, the code includes the concept of 'this' keyword and its behavior with arrow functions and normal functions.
Ans. 
The code demonstrates the behavior of 'this' keyword with arrow functions and normal functions.
• Arrow functions do not bind their own 'this' value, it inherits 'this' from the surrounding scope.

• Normal functions have their own 'this' value, which is determined by how the function is called.

• Arrow functions are useful when you want to preserve the value of 'this' from the surrounding context.
Answered by AI
Add your answer
Q2. Given a coding question to get even numbers in a different array from the original array of numbers.
Add your answer
Q3. Given SQL database structure and questions to which was asked to form SQL queries, it includes knowledge of 'joins' and use of subquery.
Add your answer
Q4. Given a question to take the input from a user and print the sum of those input and return the output (javascript).
Add your answer
Q5. What are streams and its type, write a code using the any of the stream.
Ans. 
Streams are objects that allow reading or writing data continuously. There are four types of streams: Readable, Writable, Duplex, and Transform.
• Streams are used to handle large amounts of data efficiently.

• They can be used for reading data from a source or writing data to a destination.

• Streams can be piped together to create a data flow.

• Example: Reading a file using a Readable stream and writing it to another file using
Answered by AI
Add your answer

This was a Machine Coding round, i was asked to come to office for this round. I was given to make a nodejs project from scratch using , any framework of my choice (expressjs, nestjs,etc), using sql database (any ORM of your choice).

Entities - User, Task

User -
1. user should have an email , first name, last name and password
2. user can login using email and password

Task -
1. CRUD for the task
2. Each task should be associated with a user

Extra (if time)-
1. User can assign task to different user

Note :- Time given was 2 Hours, i could not do the extras , but i was asked the question regarding my thought process on how will i approach the extras, because extras required a change in the already made entity models as well as in relations between them if any.

The 1st round was a combination of aptitude tests, technical MCQs, and cybersecurity-based MCQ questions. This round was moderate level.

My topic was "chatgpt- pros and cons ". gd round was about 15-20 mins with 8-10 students in each group. This round was comparatively easy.

Q1. Questions in the HR round include: -> Self Introduction -> Skills/strengths supporting examples. -> Family background -> Where do you see yourself after 5 years? -> What do you know about the company? -> M...read more
Add your answer

Q1. -> Self Introduction -> Projects -> Coding Question to be executed in onlineGDB: " Write a program to check if the user input matches with your name. If yes, then remove "I" characters in the string and th...read more
Add your answer