PeerLogic Systems Interview Questions and Answers

DSA- 1easy, 1 medium

Q1. Project discussion
Add your answer
Q2. DBMS views
Add your answer
Q3. Hibernate
Add your answer
Q4. What happens when u enter www.google.com
Add your answer
Q5. Authentication
Add your answer
Q6. What is socket
Add your answer
Q7. Bubble sort and time complexity
Add your answer

Q1. Question on writing the xpath,Java, Selenium related.
Add your answer

Q1. Questions on checking ours confidence.
Add your answer

Q1. Related to Generative AI.
Add your answer

Q1. Salary discussion
Add your answer

Q1. Self introduction
Add your answer
Q2. Windows function and how you used
Ans. 
Window functions are used to perform calculations across a set of table rows that are related to the current row.
• Window functions are used in SQL to perform calculations on a specific subset of rows related to the current row.

• They are often used with aggregate functions like SUM, AVG, and COUNT to calculate running totals, moving averages, and rankings.

• Examples of window functions include ROW_NUMBER(), RANK(), LEAD(),
Answered by AI
Add your answer
Q3. Sql Coding questions. Window functions with joins.
Add your answer
Q4. Pyspark code for how you connect the data to ADLS with doing partition
Ans. 
Use PySpark code to connect data to ADLS with partitioning
• Use SparkSession to create a Spark application

• Set the configuration for ADLS storage account and container

• Read data from ADLS using Spark DataFrame API

• Partition the data based on a specific column while writing back to ADLS
Answered by AI
Add your answer

Q1. Tell about yourself
Add your answer
Q2. About your experience
Add your answer

Q1. How you handle the escalation
Add your answer

Q1. Salary discussion
Add your answer

Q1. DC DC power supply and their details
Add your answer
Q2. Inductor and common mode choke parameters and usage
Add your answer

Q1. Technically experience skill
Add your answer
Q2. Integration Testing
Add your answer

Q1. Company Experience
Add your answer
Q2. Salary
Add your answer

Q1. What is your work experience in gaming
Ans. 
I have 5 years of experience working as a Game Artist in the gaming industry.
• Worked on creating 2D and 3D assets for various game projects

• Collaborated with game designers and developers to ensure visual consistency

• Experience with game engines like Unity and Unreal Engine

• Created concept art, character designs, and environment assets

• Knowledge of animation and visual effects for games
Answered by AI
Add your answer
Q2. What is your salary expectation
Ans. 
My salary expectation is based on industry standards, my experience, and the responsibilities of the role.
• Research industry standards for Game Artists salaries

• Consider my level of experience and skills

• Factor in the responsibilities and requirements of the specific role

• Be open to negotiation based on benefits and other perks offered
Answered by AI
Add your answer

Design a character and Royal symbol (fully rendered in realistic style) and one Mid Pay concept sketch for slot game.

Q1. About yourself and experience
Add your answer
Q2. About assignment related questions
Add your answer
Q3. Some unprofessional questions
Add your answer

There were basic questions asked related to the profile

There were some questions and an ER diagram to create.

Q1. Tell me about yourself
Add your answer
Q2. They started asking about the projects
Add your answer