Financial Software & Systems Senior Technical Support Associate Interview Questions and Answers

Write some simple SQL queries and function,stored procedure

Q1. Difference between ddl and dml
Ans. 
DDL stands for Data Definition Language and is used to define the structure of database objects. DML stands for Data Manipulation Language and is used to manipulate data within the database.
• DDL is used to create, modify, and delete database objects like tables, indexes, etc.

• DML is used to insert, update, delete, and retrieve data from tables.

• Examples of DDL statements include CREATE TABLE, ALTER TABLE, DROP TABLE.

• Examp...read more
Answered by AI
Add your answer
Q2. What is a subquery
Ans. 
A subquery is a query nested within another query in SQL.
• A subquery is enclosed within parentheses and is used to return data that will be used by the main query.

• It can be used in SELECT, INSERT, UPDATE, and DELETE statements.

• Example: SELECT * FROM table1 WHERE column1 = (SELECT column2 FROM table2 WHERE condition);
Answered by AI
Add your answer
Q3. What are you expectations
Add your answer

Basics test, maths and logical

Q1. Server and basics Linux comands
Add your answer
Q2. Are you good with night shifts
Add your answer

Q1. About project on overall experience and expertise
Add your answer

Q1. Basix linux and sql questions eay level
Add your answer

Q1. 2nd round -technical +managerial Fresher based questions behavioral & some sql questions given to solve.
Add your answer