Pie Infocomm Software Developer Interview Questions and Answers for Freshers

Strong appitude knowledge is required.

Q1. String , arrays, oops
Add your answer

Q1. Strecture of sql statement
Ans. 
SQL statements are used to interact with databases by performing operations like querying, updating, and deleting data.
• SQL statements are made up of keywords like SELECT, INSERT, UPDATE, DELETE, etc.

• They are structured in a specific order, with clauses like WHERE, ORDER BY, GROUP BY, etc.

• Tables are referenced using their names, and conditions are specified to filter data.

• Joins can be used to combine data from multiple
Answered by AI
Add your answer

Q1. Intro about Experience
Add your answer
Q2. Knowledge on tools
Add your answer

Q1. Sdfsfd kjdk dvfikjsf vsjv
Add your answer
Q2. Sdjvks sdkvjsk skdcj
Add your answer

Q1. What is normalization why use this
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization helps in reducing data redundancy by breaking down large tables into smaller ones.

• It ensures data integrity by minimizing data anomalies such as update, insert, and delete anomalies.

• Normalization follows a set of rules (normal forms) like 1NF, 2NF, 3NF, etc., to organize data efficiently.

• Example: ...read more
Answered by AI
Add your answer

Online test was conducted

We were asked to talk about one topic for 2mins.

Basic knowledge required for the Aptitude Test. You need to understand the questions and their technicality and then each question is very easy.

Need to focus more on the SQL Queries and some average coding skills. This test is used to check the code understanding of the candidate.

Little more complex problems, need to understand the logic and some complex SQL Queries.
More Focus on JOINS in SQL.

40 Minutes. 40 Question in office Test.
20 Questions Programming related and 20 Questions Aptitude

Basic Aptitude question were asked around 20 Question of Aptitude and 20 of basic debugging of C language code. Before aptitude there was a essay writing on "factors which increases the market of E-commerce platforms"

There were 4 coding question and 2 SQL questions. Basic pattern printing question and easy question of leetcode were there in coding and in SQL from "joins" topic.

Same as the previous round more question of Coding and SQL, plus in the starting they would ask about your tech stack and then assign you a stack for the same.