Oracle
Watoto Ministries Interview Questions and Answers
Q1. please write a code for pulling non alphabetic data from a string
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
Q2. How dependency injection works?
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
Q3. What is cursor? Why we use?
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
Q4. Diff between right and left join
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
Q5. REST API status code explanation?
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
Q6. Explain Devops pipeline of your project
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
Q7. Right example for right join
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;
More about working at Oracle
Interview Process at Watoto Ministries
Reviews
Interviews
Salaries
Users/Month