IVY Overseas SQL Developer Interview Questions and Answers

Q1. What is sql , index , stored proc , triggers
Add your answer

Q1. Project in SQL developer
Ans. 
A project in SQL developer involves designing, implementing, and maintaining databases for various applications.
• Understand project requirements and design database schema accordingly

• Write efficient SQL queries to retrieve and manipulate data

• Optimize database performance by indexing, normalization, and query tuning

• Collaborate with developers and stakeholders to ensure database meets project needs
Answered by AI
Add your answer
Q2. Types of sql, explain briefly
Ans. 
Types of SQL include DDL, DML, DCL, and TCL.
• DDL (Data Definition Language) - used to define the structure of database objects (CREATE, ALTER, DROP)

• DML (Data Manipulation Language) - used to manipulate data in database objects (SELECT, INSERT, UPDATE, DELETE)

• DCL (Data Control Language) - used to control access to data (GRANT, REVOKE)

• TCL (Transaction Control Language) - used to manage transactions (COMMIT, ROLLBACK)
Answered by AI
Add your answer

They asked to do installation

Q1. Joins in sql server
Add your answer
Q2. Set operator in sql
Add your answer

Q1. Explain about SSIS Architecture
Ans. 
SSIS Architecture is a platform for data integration and workflow applications.
• SSIS stands for SQL Server Integration Services

• It includes a data flow engine, control flow engine, and event handling

• SSIS packages can be created using SQL Server Data Tools (SSDT)

• SSIS packages can be scheduled and executed using SQL Server Agent
Answered by AI
Add your answer
Q2. How to implement transactions in ssis
Ans. 
Transactions in SSIS can be implemented using the TransactionOption property in Control Flow tasks.
• Set the TransactionOption property to Required on the Control Flow tasks that need to be included in the transaction.

• Use the TransactionOption property to specify the level of transaction support needed for each task.

• Transactions can be managed using the Distributed Transaction Coordinator (DTC) service.
Answered by AI
Add your answer

Q1. How to insert multiple values in one go
Ans. 
Use the INSERT INTO statement with multiple value sets separated by commas
• Use the INSERT INTO statement followed by the table name

• List the column names in parentheses after the table name

• Use the VALUES keyword followed by multiple value sets in parentheses, separated by commas

• Example: INSERT INTO table_name (column1, column2) VALUES (value1, value2), (value3, value4)
Answered by AI
Add your answer
Q2. Update query using joins
Ans. 
Update query using joins in SQL
• Use UPDATE statement with JOIN clause to update data in multiple tables

• Specify the tables to be updated and joined using ON clause

• Set the columns to be updated in SET clause
Answered by AI
Add your answer

Q1. Technical discussion
Add your answer

Q1. Manager round and technical discussion
Add your answer

Q1. Selection processs
Add your answer

Q1. Write a query to display the highest salary
Ans. 
Query to display the highest salary in a table
• Use the SELECT statement to retrieve data

• Use the MAX() function to find the highest salary

• Specify the column name for salary in the query
Answered by AI
Add your answer
Q2. Stored proceduers,functions,cursors triggers,
Add your answer

Q1. Types of Indexes
Ans. 
Types of indexes include clustered, non-clustered, unique, composite, and filtered indexes.
• Clustered indexes physically reorder the data in the table based on the index key.

• Non-clustered indexes create a separate structure for the index, pointing back to the original table data.

• Unique indexes ensure that no two rows have the same values in the indexed columns.

• Composite indexes are created on multiple columns to improve...read more
Answered by AI
Add your answer
Q2. Sceanrio based question
Add your answer

Q1. Salary discussion
Add your answer
Q2. Joining date and last working date
Add your answer