Pharmaspectra Associate Software Engineer Interview Questions and Answers

Q1. Swap two variables, prime number
Ans. 
To swap two variables, use a temporary variable to store one value before swapping them.
• Create a temporary variable to store one of the values

• Assign the first variable to the temporary variable

• Assign the second variable to the first variable

• Assign the temporary variable to the second variable
Answered by AI
Add your answer
Q2. Based on Linux, SQL and other
Add your answer
Q3. What are pointers
Ans. 
Pointers are variables that store memory addresses of other variables or functions.
• Pointers are used to access and manipulate memory directly.

• They are commonly used in programming languages like C and C++.

• Example: int *ptr; // declaring a pointer to an integer variable
Answered by AI
Add your answer
Q4. Commands on SQL and Linux
Add your answer
Q5. Questions related to HR
Add your answer

Q1. What is the difference between drop and delete in SQL?
Ans. 
Drop removes a table from the database while delete removes specific rows from a table.
• DROP is a DDL (Data Definition Language) command used to remove a table and its data from the database.

• DELETE is a DML (Data Manipulation Language) command used to remove specific rows from a table based on a condition.

• DROP command is irreversible and all the data in the table is lost, while DELETE can be rolled back if used within a...read more
Answered by AI
Add your answer
Q2. What are the different commands in SQL?
Ans. 
SQL commands are used to interact with databases and perform various operations like querying, updating, and deleting data.
• SELECT - retrieves data from a database

• INSERT - adds new data to a database

• UPDATE - modifies existing data in a database

• DELETE - removes data from a database

• CREATE - creates a new database or table

• ALTER - modifies the structure of a database object

• DROP - deletes a database object

• JOIN - combines row...read more
Answered by AI
Add your answer

There were two coding questions

There was oncampus coding round , where 1 question was given.

Q1. Tell me something about yourself?
Add your answer
Q2. What are your projects?
Add your answer

Q1. Where do you see yourself after 5 years?
Add your answer

Q1. Read the sentence
Add your answer
Q2. Listen and repeat the sentence
Add your answer

Mercel platform 1 hour

Q1. Explain ur project
Ans. 
Developed a web-based project management tool for tracking tasks and deadlines.
• Used HTML, CSS, and JavaScript for front-end development

• Implemented backend functionality using Node.js and MongoDB

• Incorporated user authentication and authorization features

• Utilized RESTful APIs for communication between front-end and back-end
Answered by AI
Add your answer
Q2. One code according to ur cluster
Ans. 
I would write a code snippet based on the specific cluster or category provided.
• Identify the specific cluster or category provided in the question

• Write a code snippet that aligns with the requirements of the cluster

• Ensure the code is accurate and relevant to the given cluster
Answered by AI
Add your answer

General aptitude, behaviourial and some analytical questions

Q1. Tell me about yourself
Add your answer
Q2. Questions from projects mentioned in resume
Add your answer
Q3. Few basic technical questions
Add your answer

Numerical based questions are there mostly

Good basic level coding questions

Q1. Tell me about urself
Add your answer
Q2. Tell about ur projects
Ans. 
I have worked on various projects including a web application for online shopping and a mobile app for task management.
• Developed a web application using HTML, CSS, and JavaScript for online shopping

• Created a mobile app using React Native for task management

• Implemented RESTful APIs for communication between front-end and back-end systems
Answered by AI
Add your answer

They will give assignment with video explanation.

Q1. Theory questions on java
Add your answer
Q2. Spring boot questions
Add your answer

Q1. Difference between abstract class and interface
Ans. 
Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.
• Abstract class can have constructors, fields, and methods, while interface cannot have any of these.

• A class can implement multiple interfaces but can only inherit from one abstract class.

• Abstract classes are used to provide a common base for multiple classes, while interfaces define a contract that implementin
Answered by AI
Add your answer
Q2. Why static and final key words used
Ans. 
Static and final keywords are used in Java to define class-level variables and constants respectively.
• Static keyword is used to define class-level variables and methods, which are shared among all instances of the class.

• Final keyword is used to define constants that cannot be changed once initialized.

• Static variables are accessed using the class name, while final variables are accessed using object references.

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