Optiemus Electronics Assistant Manager- Program Management Interview Questions and Answers

Basic PL/SQL coding including sql codes and theory

Q1. Write PL/SQL functions
Ans. 
PL/SQL functions are used to perform specific tasks and return values.
• Functions are created using the CREATE FUNCTION statement

• Functions can take input parameters and return a single value

• Functions can be used in SQL statements or called from other PL/SQL code

• Functions can be stored in the database for reuse

• Example: CREATE FUNCTION get_employee_name(emp_id NUMBER) RETURN VARCHAR2 IS ... END;
Answered by AI
Add your answer
Q2. Write SQL queries like subqueries, analytical function
Ans. 
Demonstrate SQL subqueries and analytical functions
• Subqueries can be used to retrieve data from a table based on values in another table

• Analytical functions can be used to perform calculations on a set of rows in a table

• Examples of analytical functions include RANK(), ROW_NUMBER(), and SUM() OVER()

• Subqueries can be used in the SELECT, FROM, WHERE, and HAVING clauses

• Analytical functions can be used in the SELECT and ORD
Answered by AI
Add your answer