Horizontal Integration SQL and PL SQL Developer Interview Questions and Answers

Q1. Difference between function and stored procedure.
Ans. 
Functions return a value while stored procedures do not. Functions can be used in SELECT statements, stored procedures cannot.
• Functions return a value, stored procedures do not

• Functions can be used in SELECT statements, stored procedures cannot

• Functions must return a value, stored procedures may or may not
Answered by AI
Add your answer
Q2. Write a query to find the manager of the employee.
Ans. 
Use a self join to find the manager of the employee.
• Join the employee table with itself on the manager_id and employee_id columns

• Select the manager's details based on the employee's manager_id
Answered by AI
Add your answer
Q3. To write a stored procedure.
Add your answer
Q4. What is trigger?
Ans. 
A trigger is a special type of stored procedure that automatically executes when certain events occur in a database.
• Triggers can be used to enforce business rules, perform data validation, or maintain referential integrity.

• Examples of trigger events include INSERT, UPDATE, and DELETE operations on a table.

• Triggers can be defined to execute before or after the triggering event.
Answered by AI
Add your answer
Q5. What do you know about JSON?
Add your answer

Q1. Tell me about
Add your answer
Q2. Your self they are asking
Add your answer
Q3. What is your weakness
Add your answer
Q4. Any questions ask for me
Add your answer
Q5. All the best future
Add your answer

Coding for international

Quantitative arithmetic,verbal reasoning,non-verbal reasoning,etc

Duration 1 hr general aptitude topics

Duration 1hr subject related coding questions

Simple question on maths

Q1. Explain OOPS concept
Ans. 
OOPS (Object-Oriented Programming) is a programming paradigm based on the concept of objects, which can contain data and code.
• OOPS focuses on creating objects that interact with each other to solve complex problems

• Key principles include encapsulation, inheritance, polymorphism, and abstraction

• Encapsulation ensures that the internal state of an object is hidden from the outside world

• Inheritance allows a class to inherit...read more
Answered by AI
Add your answer
Q2. Coding array questions
Add your answer

Q1. Introduce yourself
Ans. 
I am a software developer with 5 years of experience in Java, Python, and SQL.
• 5 years of experience in Java, Python, and SQL

• Strong problem-solving skills

• Experience working in Agile development environment
Answered by AI
Add your answer
Q2. Short term goals
Add your answer

It is MCQ based test which contain both aptitude and technical question

Q1. Technical question was asked
Add your answer

Q1. HR question was asked
Add your answer

Q1. What is cursor and types
Ans. 
A cursor is a pointer to a private SQL area that stores information about the processing of a SELECT or DML statement.
• A cursor is used to retrieve data row by row from a result set.

• There are two types of cursors: Implicit and Explicit.

• Implicit cursors are used for single-row queries, while explicit cursors are used for multi-row queries.

• Cursor variables can be used to pass cursors as parameters to procedures and functi
Answered by AI
Add your answer
Q2. Truncate & delete difference
Ans. 
Truncate removes all data from a table while delete removes specific rows.
• Truncate is faster than delete as it doesn't log individual row deletions

• Truncate cannot be rolled back while delete can be

• Truncate resets the identity of the table while delete doesn't

• Truncate doesn't fire triggers while delete does
Answered by AI
Add your answer
Q3. Explain about trigger
Ans. 
A trigger is a special type of stored procedure that automatically executes in response to certain events.
• Triggers are used to enforce business rules or to perform complex calculations.

• They can be defined to execute before or after a data modification operation.

• Triggers can be used to audit changes to data or to replicate data changes to other tables.

• Examples of events that can trigger a trigger include INSERT, UPDATE,...read more
Answered by AI
Add your answer

Q1. About your self
Add your answer
Q2. About work experience
Add your answer
Q3. About salary expectation
Add your answer