Oasis Test House Interview Questions and Answers

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

Q1. What are the reasons we should consider hiring you?
Ans. 
I bring a unique blend of creativity, technical skills, and attention to detail to every project.
• I have a strong portfolio showcasing my design skills and creativity.

• I am proficient in various design software such as Adobe Creative Suite.

• I have a keen eye for detail and strive for perfection in every project.

• I am a team player and can collaborate effectively with colleagues and clients.

• I am always eager to learn and st...read more
Answered by AI
Add your answer
Q2. What motivated you to choose this field?
Ans. 
Passion for creativity and visual communication led me to choose graphic design.
• Passion for creativity and art

• Interest in visual communication

• Enjoyment of working with various design tools and software
Answered by AI
Add your answer

Create a mascot for Equinox Lab.

Q1. How do you prioritize backlog
Ans. 
I prioritize backlog based on value, dependencies, deadlines, and customer feedback.
• Prioritize user stories with high business value

• Consider dependencies between user stories

• Meet deadlines by prioritizing critical tasks first

• Incorporate customer feedback to adjust priorities
Answered by AI
Add your answer
Q2. How do ypu handle changing requirements
Ans. 
I handle changing requirements by prioritizing them based on impact and feasibility.
• Regular communication with stakeholders to understand the changes

• Prioritizing changes based on impact and feasibility

• Adapting the project plan and timeline accordingly

• Implementing Agile methodologies to accommodate changes

• Ensuring clear documentation of changes for team members
Answered by AI
Add your answer
Q3. What is your experience with agile
Add your answer

Q1. Example user stories
Ans. 
User stories are short, simple descriptions of a feature told from the perspective of the person who desires the new capability.
• As a user, I want to be able to create a profile so I can personalize my experience

• As a user, I want to be able to search for products by category so I can easily find what I need

• As a user, I want to be able to add items to my shopping cart and checkout quickly
Answered by AI
Add your answer
Q2. How do you manage client changes after starting a project
Add your answer
Q3. Explain your work experience
Add your answer
Q4. The interviewer looked very disinterested and the HR sent me the link 6 min before interview. Very rushed and badly planned
Add your answer

Multiple choice questions

Q1. About yourself complete details
Add your answer
Q2. About work profile
Add your answer
Q3. About your skill level
Add your answer

Q1. Complete details regarding work profile
Add your answer
Q2. How to handle your KPI
Ans. 
Handling KPI involves setting clear goals, tracking progress, analyzing data, and making adjustments as needed.
• Set specific and measurable KPIs related to credit control performance, such as DSO (Days Sales Outstanding) or collection efficiency.

• Regularly track and monitor KPIs to assess performance and identify areas for improvement.

• Analyze data to understand trends, patterns, and root causes of any issues affecting KP...read more
Answered by AI
Add your answer

Q1. What are you doing current organization?
Add your answer
Q2. Suzuki coupling byproduct? And how many pic shows in LCMS Suzuki reaction.
Ans. 
Suzuki coupling byproduct is typically a biphenyl compound. LCMS shows peaks corresponding to reactants, products, and intermediates.
• Suzuki coupling byproduct is often a biphenyl compound formed due to side reactions.

• LCMS analysis of Suzuki reaction typically shows peaks corresponding to reactants, products, and intermediates.

• Monitoring the LCMS peaks can provide insights into the progress and efficiency of the Suzuki
Answered by AI
Add your answer
Q3. How to conform cis and tras by NMR.
Ans. 
Conforming cis and trans isomers by NMR involves analyzing the chemical shifts and coupling constants of the molecules.
• Analyze the chemical shifts of the protons in the molecule to determine the stereochemistry (cis or trans).

• Look for characteristic coupling constants that indicate the relative positions of the protons in the molecule.

• Compare the NMR spectra of the cis and trans isomers to identify any differences in c...read more
Answered by AI
Add your answer
Q4. Nitrile react with lithium alluminium hydride which product. And Nitrile react with DiBaL-H which product from.
Ans. 
Nitrile reacts with lithium aluminum hydride to form primary amines, and with DiBaL-H to form aldehydes.
• Nitrile + lithium aluminum hydride -> primary amine

• Nitrile + DiBaL-H -> aldehyde
Answered by AI
Add your answer

Basic questions regarding Pharmacovigilance, signal detection, narrative writing and medical terminology. Scenario based questions for causality and dechallenge and rechallence assessment.

Q1. What is the earliest date you are available to join?
Add your answer
Q2. We will offer you bonus if you join early
Add your answer