Opsio Software Developer Interview Questions and Answers

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

Mathematical and logical questions including distance -time, work -time, reasoning, blood relation etc

Q1. Database queries including joins.
Add your answer

DSA moderate question like string reverse, string rotation, frequency of letter in a string.

Simple questions of quant and coding output

3 coding question and one pattern question

Q1. Discussions on questions of prev round
Add your answer
Q2. One SQL query need to implement
Add your answer

MCQ - 20 (aptitude), 20(c+ and sql)

Pattern, array and sql questions

Online test was conducted

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

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