Poojara Telecom Interview Questions and Answers

Assignments in marketing and sales involve processes related to product development, technology, and service taxation, as well as the enhancement of listening skills and other developmental processes beyond the same assignments.

Q1. What is the marketing What is the tax What are good and service tax
Add your answer
Q2. What are good and service tax
Add your answer
Q3. What is theDeveploment skills
Add your answer
Q4. How is skills and service
Add your answer
Q5. What istha markating skills
Add your answer

Q1. Asked about Dotnet Core Questions about Program.cs file use case, DI, Services, Architectural patterns, and jumped to Linq complex queries and SQL queries. Before that Deep analysis of background work
Add your answer
Q2. Use of Program.cs
Add your answer
Q3. Middleware and Services
Add your answer
Q4. Dependency Injection
Add your answer
Q5. Authentication & Authorization
Add your answer

Q1. Basic techno managerial questions on tech you worked on work, interests, challenges you faced. Was fairly short.
Add your answer

Initially had a string based coding problem. Then was asked technical questions and then had a small break before doing system design with same interviewer for building book my show system and db schema.

Q1. Had a discussion with hiring manager on expectations, salary and growth.
Add your answer

It was basic coding to test the Python skills like reading data from local and uploading in cloud then some basic dag related questions

Q1. Clustering and partition difference in data warehousing solutions
Ans. 
Clustering involves grouping similar data together, while partitioning involves dividing data into smaller, manageable sections.
• Clustering is used to group similar data points together based on certain criteria, such as customer segments or product categories.

• Partitioning involves dividing a large dataset into smaller, more manageable sections for easier data retrieval and processing.

• Clustering is often used for data a...read more
Answered by AI
Add your answer
Q2. What are the different approaches to Optimising SQL
Ans. 
Different approaches to optimizing SQL include indexing, query optimization, and database design.
• Use indexing to improve query performance

• Optimize queries by avoiding unnecessary joins and using appropriate functions

• Design the database schema efficiently to reduce redundancy and improve data retrieval speed
Answered by AI
Add your answer
Q3. Spark and it’s architecture
Add your answer
Q4. Finding the count of Item bought by an customer from Flipkart during a year excluding February
Ans. 
To find the count of items bought by a customer from Flipkart during a year excluding February, you need to aggregate the data and filter out February transactions.
• Aggregate the data by customer and item purchased

• Filter out transactions from February

• Count the number of items bought by each customer
Answered by AI
Add your answer

Q1. What is Object-Oriented Programming (OOP), and can you explain its fundamental concepts?
Ans. 
OOP is a programming paradigm based on the concept of objects, which can contain data in the form of fields and code in the form of procedures.
• OOP focuses on creating objects that interact with each other to solve complex problems.

• Fundamental concepts include classes, objects, inheritance, encapsulation, and polymorphism.

• Classes are blueprints for creating objects, while objects are instances of classes.

• Inheritance all...read more
Answered by AI
Add your answer
Q2. What is the definition of an array, and what are the different types of arrays?
Ans. 
An array is a data structure that stores a collection of elements of the same type. There are different types of arrays such as one-dimensional, multi-dimensional, and associative arrays.
• One-dimensional array: Stores elements in a single row or column.

• Multi-dimensional array: Stores elements in multiple rows and columns.

• Associative array: Uses key-value pairs to store elements.

• Example: ['apple', 'banana', 'orange']
Answered by AI
Add your answer
Q3. What is the clr
Ans. 
CLR stands for Common Language Runtime, a virtual machine component of the .NET framework responsible for managing code execution.
• CLR provides services such as memory management, exception handling, and security.

• It compiles code into Intermediate Language (IL) and then translates it into machine code at runtime.

• CLR allows for language interoperability within the .NET framework, enabling different languages to work toge
Answered by AI
Add your answer

The content is based on HTML, Windows, and ADO.NET.

Q1. What motivates you to pursue this job?
Ans. 
I am motivated to pursue a career as a Customer Care Executive because I enjoy helping others and providing excellent service.
• I have a passion for assisting customers and resolving their issues

• I thrive in a fast-paced environment where I can use my communication skills effectively

• I find satisfaction in ensuring customer satisfaction and building positive relationships

• I believe in the importance of delivering exceptiona...read more
Answered by AI
Add your answer
Q2. What is your expected salary?
Ans. 
My expected salary is based on my experience, skills, and the market rate for web developers.
• I have researched the average salary for web developers in this location.

• I am open to negotiation based on the overall compensation package offered.

• I am looking for a salary that reflects my expertise and contributions to the team.
Answered by AI
Add your answer

Q1. Are you willing to do this job
Add your answer
Q2. U have to manage ur team
Add your answer
Q3. Salary expectation
Add your answer

Q1. About myself and family
Add your answer
Q2. Regarding the job
Add your answer