OHUM Healthcare Solutions Software Developer Interview Questions and Answers

Q1. Explain Behaviour subject in Angular.
Ans. 
Behaviour subject in Angular is a special type of subject that allows both subscribing and emitting values.
• BehaviourSubject is a type of subject in RxJS library.

• It has an initial value that will be emitted to new subscribers.

• It stores the latest value and emits it immediately to new subscribers.

• Example: const subject = new BehaviorSubject('initial value');

• Example: subject.next('new value');
Answered by AI
Add your answer
Q2. Explain Design Principles
Ans. 
Design principles are guidelines for designing software solutions that are maintainable, scalable, and efficient.
• Design principles help in creating software that is easy to understand, modify, and maintain.

• They promote code reusability, modularity, and flexibility.

• Examples of design principles include SOLID principles, DRY (Don't Repeat Yourself), KISS (Keep It Simple, Stupid), and YAGNI (You Aren't Gonna Need It).
Answered by AI
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

Normal question of reasoning and maths

Sorting arraylist , sorted map

Q1. Is sql necessary for your project ?
Ans. 
SQL is necessary for most projects involving databases to manage and query data efficiently.
• SQL is essential for creating, updating, and querying databases in most projects.

• Without SQL, it would be challenging to interact with databases and retrieve specific data.

• Examples of SQL commands include SELECT, INSERT, UPDATE, and DELETE.

• SQL can help optimize database performance and ensure data integrity.
Answered by AI
Add your answer
Q2. What is Hql ?
Ans. 
HQL stands for Hibernate Query Language, a query language similar to SQL but used for Hibernate ORM framework.
• HQL is used to perform database operations in Hibernate ORM framework.

• It is similar to SQL but operates on Hibernate objects instead of database tables.

• HQL queries are written in Hibernate-specific syntax.

• Example: 'FROM Employee e WHERE e.department = :dept'

• HQL queries are translated into SQL queries by Hiberna
Answered by AI
Add your answer
Q3. What are views ?
Ans. 
Views in Java are user interface components that display data from a model in a specific format.
• Views are used to represent the user interface in Java applications.

• They display data from a model in a visually appealing format.

• Examples include buttons, text fields, labels, and checkboxes.
Answered by AI
Add your answer
Q4. What are cross joins ?
Ans. 
Cross joins are a type of join operation in SQL that combines each row from one table with each row from another table.
• Cross joins do not have a join condition specified, resulting in a Cartesian product of the two tables.

• They can be used when you want to combine every row from one table with every row from another table.

• Cross joins can lead to a large result set if the tables being joined have many rows.
Answered by AI
Add your answer
Q5. Difference between delete and truncate
Ans. 
Delete removes rows one by one, while truncate removes all rows at once.
• Delete is a DML command, while truncate is a DDL command.

• Delete can be rolled back, while truncate cannot be rolled back.

• Delete fires triggers, while truncate does not fire triggers.

• Delete is slower as it logs individual row deletions, while truncate is faster as it logs the deallocation of the data pages.
Answered by AI
Add your answer