Pellsys Pharma Interview Questions and Answers

They are asking aptitude related questions and total 15 to 20 questions

Have to attend a psychometric test as an part of initial screening process. It really helps to understand your personal & porfessional skills and areas to be worked upon.

Q1. Technical questions with regards to the role by the hiring manager
Add your answer

Q1. Meeting the directros & promoters
Add your answer

Q1. Salary negotiation and discussion about joining details and roles and responsibilities
Add your answer

Q1. What is difference between inner join and full join
Ans. 
Inner join returns only the matching rows between two tables, while full join returns all rows from both tables.
• Inner join only includes rows that have a match in both tables

• Full join includes all rows from both tables, filling in NULL values for non-matching rows

• Inner join is more commonly used than full join in practice

• Example: Inner join - SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id

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

Concentrate on an array of strings and fundamental coding knowledge.

Core concepts and coding involve integrating and understanding processes from the beginning to successfully complete projects.

Q1. Can you provide some basic information about yourself and describe the projects you have worked on?
Ans. 
I am a software developer with 5 years of experience. I have worked on projects involving web development, mobile app development, and database management.
• 5 years of experience in software development

• Proficient in web development, mobile app development, and database management

• Worked on projects involving e-commerce websites, iOS and Android apps, and SQL database optimization
Answered by AI
Add your answer
Q2. Culture fit
Add your answer

Q1. Salary discussion
Add your answer
Q2. Communication
Add your answer

Q1. Anagram of two strings in java
Ans. 
Java program to check if two strings are anagrams
• Create a function that takes two strings as input

• Convert both strings to character arrays and sort them

• Check if the sorted arrays are equal to determine if they are anagrams
Answered by AI
Add your answer
Q2. Insert and select query in MySQL
Ans. 
Insert and select data in MySQL using SQL queries
• Use INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...); to insert data

• Use SELECT * FROM table_name; to select all data from a table

• Use SELECT column1, column2 FROM table_name WHERE condition; to select specific data based on a condition
Answered by AI
Add your answer
Q3. Get and Post APIs in rest
Ans. 
GET and POST are HTTP methods used in REST APIs for retrieving and sending data.
• GET method is used to retrieve data from a server

• POST method is used to send data to a server

• GET requests are idempotent, while POST requests are not

• GET requests should only be used for retrieving data, not for modifying data

• Example: GET request to retrieve a list of users - GET /users

• Example: POST request to create a new user - POST /users
Answered by AI
Add your answer