Societe Generale Global Solution Centre Production Support Analyst Interview Questions and Answers

24/7 production environment

Q1. What is the difference between PL SQL AND SQL?
Ans. 
PL/SQL is a procedural language extension to SQL used for writing complex queries and programs.
• SQL is used for querying and manipulating data in a database

• PL/SQL is used for writing complex queries and programs

• PL/SQL is a procedural language that extends SQL with programming constructs like loops and conditional statements

• PL/SQL is used to create stored procedures, functions, and triggers in Oracle databases
Answered by AI
Add your answer
Q2. About programming
Add your answer
Q3. Write a query using below data to find out last string from emp table?
Ans. 
Query to find last string from emp table
• Use the ORDER BY clause with DESC keyword to sort the table in descending order

• Use the LIMIT keyword to limit the result to 1 row

• Assuming the last string refers to the last row in the table
Answered by AI
Add your answer
Q4. Write s query to find maximum salary from EMP?
Ans. 
Query to find maximum salary from EMP
• Use the MAX() function to find the maximum salary

• Specify the column name for salary in the SELECT statement

• Specify the table name and column name for salary in the FROM clause
Answered by AI
Add your answer