Add office photos
Engaged Employer

Oracle

3.7
based on 5.2k Reviews
Video summary
Filter interviews by

Watoto Ministries Interview Questions and Answers

Updated 1 Jul 2024
Popular Designations

Q1. please write a code for pulling non alphabetic data from a string

Ans.

Code to extract non-alphabetic characters from a string

  • Iterate through each character in the string

  • Check if the character is not in the range of 'A' to 'Z' and 'a' to 'z'

  • Add the non-alphabetic character to a separate array of strings

Add your answer

Q2. How dependency injection works?

Ans.

Dependency injection is a design pattern where components are given their dependencies rather than creating them internally.

  • Dependencies are injected into a component through constructor injection, setter injection, or interface injection.

  • This allows for easier testing, flexibility, and reusability of components.

  • Common frameworks for dependency injection include Spring Framework for Java and Angular for TypeScript.

  • Example: In Spring Framework, dependencies are defined in a co...read more

Add your answer

Q3. What is cursor? Why we use?

Ans.

A cursor is a database object used to retrieve data from a result set one row at a time.

  • Used to fetch and manipulate data row by row

  • Improves performance by reducing memory usage

  • Can be static, dynamic, forward-only, etc.

  • Examples: FETCH, OPEN, CLOSE

Add your answer

Q4. Diff between right and left join

Ans.

Right join includes all records from the right table and matching records from the left table, while left join includes all records from the left table and matching records from the right table.

  • Right join keeps all records from the right table, even if there are no matches in the left table.

  • Left join keeps all records from the left table, even if there are no matches in the right table.

  • Example: In a right join between tables A and B, all records from table B will be included ...read more

Add your answer
Discover Watoto Ministries interview dos and don'ts from real experiences

Q5. REST API status code explanation?

Ans.

REST API status codes indicate the outcome of an HTTP request.

  • 200 - OK: Request was successful

  • 404 - Not Found: Resource not found

  • 500 - Internal Server Error: Server error occurred

Add your answer

Q6. Explain Devops pipeline of your project

Ans.

Our DevOps pipeline automates the software delivery process, from code commit to production deployment.

  • Continuous Integration (CI) - Code is automatically built and tested whenever changes are made.

  • Continuous Deployment (CD) - Changes that pass CI are automatically deployed to production.

  • Infrastructure as Code (IaC) - Infrastructure is defined in code and managed through version control.

  • Automated Testing - Various types of tests are run automatically to ensure code quality.

  • Mo...read more

Add your answer

Q7. Right example for right join

Ans.

A right join returns all records from the right table and the matched records from the left table.

  • Use when you want to include all records from the right table, even if there are no matches in the left table.

  • Syntax: SELECT * FROM table1 RIGHT JOIN table2 ON table1.column = table2.column;

  • Example: SELECT * FROM employees RIGHT JOIN departments ON employees.department_id = departments.department_id;

Add your answer

More about working at Oracle

#22 Best Mega Company - 2022
#3 Best Internet/Product Company - 2022
Contribute & help others!
Write a review
Share interview
Contribute salary
Add office photos

Interview Process at Watoto Ministries

based on 9 interviews
2 Interview rounds
Technical Round - 1
Technical Round - 2
View more
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
75 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter