Optmyzr Software Developer Intern Interview Questions, Process, and Tips

Leetcode easy-medium

Q1. What is Cyber Security and information security?
Ans. 
Cyber security is the practice of protecting systems, networks, and data from digital attacks.
• Cyber security involves implementing measures to prevent unauthorized access, data breaches, and other cyber threats.

• It includes technologies, processes, and practices designed to protect networks, devices, programs, and data from attack, damage, or unauthorized access.

• Examples of cyber security measures include firewalls, ant...read more
Answered by AI
Add your answer
Q2. What are the types of encryption?
Ans. 
Types of encryption include symmetric encryption, asymmetric encryption, and hashing.
• Symmetric encryption: Uses the same key for both encryption and decryption, examples include AES and DES.

• Asymmetric encryption: Uses a pair of public and private keys for encryption and decryption, examples include RSA and ECC.

• Hashing: Converts data into a fixed-size string of bytes, examples include MD5 and SHA.
Answered by AI
Add your answer

Q1. Pivot columns in sql
Ans. 
Pivoting columns in SQL involves transforming rows into columns to display data in a different format.
• Use the PIVOT keyword in SQL to pivot columns

• Specify the columns to pivot on and the values to display in the new columns

• Aggregate functions like SUM, AVG, COUNT can be used with PIVOT

• Example: SELECT * FROM table_name PIVOT (SUM(value_column) FOR pivot_column IN ('value1', 'value2', 'value3'))
Answered by AI
Add your answer
Q2. Slow changing dimensions
Add your answer
Q3. Dynamic rankx top 3
Add your answer
Q4. Field parameters
Add your answer
Q5. Stored procedures
Add your answer

Two Medium DSA questions, then questions about react and springboot

Q1. Basic JavaScript and React.js questions
Add your answer
Q2. Questions on functions, hooks and DOM
Add your answer
Q3. Questions on SSR
Add your answer
Q4. Questions on strings and arrays
Add your answer

Api related questions

Q1. Explain in detail about your last project
Add your answer
Q2. What is Regression Testing and Retesting
Ans. 
Regression testing is testing the existing functionality of the software after making changes to ensure that the changes have not affected the existing functionality. Retesting is testing the same functionality again after fixing the defects found during regression testing.
• Regression testing is done to ensure that the changes made to the software have not affected the existing functionality.

• Retesting is done to ensure ...read more
Answered by AI
Add your answer
Q3. What 300 & 301 status codes represents?
Ans. 
300 represents multiple choices and 301 represents moved permanently.
• 300 status code represents multiple choices, indicating that the requested resource has multiple representations available.

• 301 status code represents moved permanently, indicating that the requested resource has been permanently moved to a new URL.

• Both status codes are used in HTTP responses to indicate the status of a requested resource.

• Examples of 3...read more
Answered by AI
Add your answer
Q4. What is Sanity Testing and Smoke Testing?
Ans. 
Sanity testing and Smoke testing are types of software testing performed to check the basic functionality of the application.
• Smoke testing is a type of testing that checks whether the critical functionalities of the application are working fine or not.

• Sanity testing is a type of testing that checks whether the bugs reported earlier have been fixed or not.

• Smoke testing is performed after the build is received from the d...read more
Answered by AI
Add your answer
Q5. What is Severity and Priority?
Ans. 
Severity is the impact of a defect on the system, while Priority is the order in which defects should be fixed.
• Severity is based on the extent of damage caused by a defect

• Priority is based on the importance of the affected functionality

• High Severity and High Priority defects should be fixed first

• Example: A spelling mistake in a button label has low Severity but high Priority if it affects usability
Answered by AI
Add your answer
Q6. Explain High priority and low severity with an example
Ans. 
High priority means the issue needs to be fixed immediately, while low severity means the issue has minimal impact on the system.
• High priority issues are critical and can cause system failure or data loss

• Low severity issues are minor and do not affect the system's functionality

• Example of high priority and low severity issue: A critical security vulnerability is high priority but low severity because it has not yet been...read more
Answered by AI
Add your answer
Q7. Explain low priority and high severity with an example
Ans. 
Low priority and high severity refer to the impact and urgency of a bug respectively.
• Low priority bugs are those that do not have a significant impact on the system or user experience, but still need to be fixed eventually.

• High severity bugs are those that have a significant impact on the system or user experience and need to be fixed urgently.

• For example, a low priority bug could be a typo in a non-critical error mess...read more
Answered by AI
Add your answer
Q8. What is Agile methodology
Ans. 
Agile methodology is an iterative approach to software development that emphasizes flexibility and customer satisfaction.
• Agile values individuals and interactions over processes and tools

• It emphasizes working software over comprehensive documentation

• It encourages collaboration between developers and customers

• It involves breaking down projects into smaller, manageable chunks called sprints

• Examples of Agile methodologies...read more
Answered by AI
Add your answer
Q9. Which test should do first and why?
Ans. 
The test that should be done first is the one that covers the most critical and high-risk functionality.
• Identify critical and high-risk functionality

• Prioritize tests based on risk

• Perform tests in a logical order

• Re-evaluate test priorities as development progresses
Answered by AI
Add your answer
Q10. Logical question - You have 3 switches and one bulb in another room, you have to find which switch in connected to that bulb, you are given only ONE CHANCE.
Add your answer

Q1. What is Indexing in Mysql
Ans. 
Indexing in MySQL is a technique to improve the performance of database queries by creating a data structure that allows for faster data retrieval.
• Indexes are created on one or more columns of a table.

• They help in speeding up the search, sorting, and joining of data.

• Indexes can be created using different algorithms like B-tree, hash, or bitmap.

• Using indexes appropriately can significantly enhance query performance.

• Exam...read more
Answered by AI
Add your answer
Q2. Opps concepts in php
Ans. 
Object-oriented programming concepts in PHP
• Encapsulation: bundling data and methods together in a class

• Inheritance: creating new classes based on existing ones

• Polymorphism: using a single interface to represent different types

• Abstraction: hiding unnecessary details and exposing only essential features

• Class: blueprint for creating objects

• Object: instance of a class

• Method: function defined inside a class

• Property: variabl
Answered by AI
Add your answer

Q1. It was good and easy
Add your answer

Q1. Its all about package discussion
Add your answer