AvenData GmbH Interview Questions, Process, and Tips

There is online aptitude test of 100 marks

Q1. Coding question
Add your answer
Q2. Ask question related to DSA AND SQL
Add your answer

They will share you link of test ,

Q1. Basic to moderate level queries question .
Add your answer
Q2. Few question on JOINS ?
Add your answer
Q3. What is triggers?
Ans. 
Triggers are database objects that automatically perform an action when a specified event occurs.
• Triggers are used to enforce business rules, maintain data integrity, and automate repetitive tasks.

• They can be set to execute before or after an INSERT, UPDATE, or DELETE operation on a table.

• Examples of triggers include auditing changes to a table, updating a related table when a record is modified, or enforcing referenti
Answered by AI
Add your answer
Q4. What is stored procedure ?
Ans. 
A stored procedure is a set of SQL statements that are stored in the database and can be called by name to perform a specific task.
• Stored procedures help improve performance by reducing network traffic and improving security.

• They can accept input parameters and return output parameters.

• Stored procedures can be reused across multiple applications.

• Examples: CREATE PROCEDURE, CALL PROCEDURE.
Answered by AI
Add your answer
Q5. Can rollback delete command .
Ans. 
No, the delete command cannot be rolled back in MySQL.
• Delete command permanently removes data from a table.

• Rollback command can only be used with transactions involving insert, update, or alter commands.

• Once a delete command is executed, the data is gone and cannot be recovered.

• To undo a delete operation, you would need to restore the data from a backup.
Answered by AI
Add your answer

Basic c# .net questions

Sql aptitude question were asked

Q1. Function, Stored procedure
Add your answer
Q2. Basic of Sql, window function & Indexes
Add your answer