AvenData GmbH Mysql Developer Interview Questions and Answers

Q1. Linked list question to detect cycle
Add your answer
Q2. Basic questions from JS
Add your answer

Q1. Some questions related to my projects
Add your answer
Q2. Some Questions related to my past experience
Add your answer

Q1. What is difference between responsive and adaptive design ?
Ans. 
Responsive design adapts to different screen sizes, while adaptive design uses predefined layouts for specific screen sizes.
• Responsive design uses fluid grids and media queries to adjust layout based on screen size.

• Adaptive design uses multiple fixed layout sizes designed for specific screen sizes.

• Responsive design provides a more flexible and seamless user experience across various devices.

• Adaptive design may offer be...read more
Answered by AI
Add your answer
Q2. What is difference between Static and Dynamic website
Ans. 
Static websites display the same content to all users, while dynamic websites can change content based on user interactions.
• Static websites are built using only HTML and CSS, with no server-side processing involved.

• Dynamic websites use server-side scripting languages like PHP, Python, or Ruby to generate content on the fly.

• Static websites are faster to load as they do not require server processing for each request.

• Dyna...read more
Answered by AI
Add your answer
Q3. What is javascript ?
Ans. 
JavaScript is a high-level, interpreted programming language used for creating interactive websites and web applications.
• JavaScript is a client-side scripting language that runs in the browser.

• It is used to add interactivity, animations, and dynamic content to websites.

• JavaScript can also be used on the server-side with Node.js.

• Commonly used for form validation, DOM manipulation, and AJAX requests.

• Example: document.get
Answered by AI
Add your answer
Q4. What is react js ?
Ans. 
React JS is a JavaScript library for building user interfaces.
• React JS allows developers to create reusable UI components.

• It uses a virtual DOM for better performance by updating only the necessary parts of the actual DOM.

• React JS follows a unidirectional data flow, making it easier to manage state and props.

• It is commonly used in single-page applications and for building interactive web interfaces.
Answered by AI
Add your answer
Q5. What is promise in javascript ?
Ans. 
Promise in JavaScript is an object representing the eventual completion or failure of an asynchronous operation.
• Promises are used to handle asynchronous operations in JavaScript.

• They can be in one of three states: pending, fulfilled, or rejected.

• Promises can be chained using .then() to handle success and .catch() to handle errors.

• Example: const myPromise = new Promise((resolve, reject) => { ... });
Answered by AI
Add your answer

Logical reasoning and Aptitude

Functions with Pointers and strings concepts

Q1. Mainly on Pointers and Dynamic Memory Allocation of 2-D Array
Add your answer
Q2. Structure Padding and Packing
Add your answer

Q1. Experience in domains
Add your answer
Q2. Previous companies
Add your answer

Q1. SQL basic questions
Add your answer
Q2. .net and OOP basics
Add your answer

Q1. General questions and introduction
Add your answer

1 round is coding round in pan paper test atleast 5 coding questions and some multiple questions and 1 DSA questions and 4 coding questions correct and dsa correct than interview

Q1. What are oops concepts in java, explain real time scenario
Ans. 
OOPs concepts in Java include inheritance, polymorphism, encapsulation, and abstraction.
• Inheritance allows a subclass to inherit properties and methods from a superclass.

• Polymorphism allows objects to take on multiple forms and behave differently based on their context.

• Encapsulation hides the implementation details of an object and only exposes necessary information.

• Abstraction allows for the creation of abstract class...read more
Answered by AI
View 1 more answer
Q2. Uses of interface, inheritance
Ans. 
Interfaces define contracts for behavior, while inheritance allows for code reuse and polymorphism.
• Interfaces allow for loose coupling and abstraction, enabling multiple implementations of the same behavior.

• Inheritance allows for code reuse and extension of existing classes, reducing code duplication.

• Polymorphism allows objects of different classes to be treated as if they were of the same class, simplifying code and i
Answered by AI
Add your answer
Q3. SQL query for join of tables
Ans. 
SQL query for joining tables
• Use JOIN keyword to combine two or more tables based on a related column

• Specify the columns to be selected using SELECT keyword

• Use ON keyword to specify the condition for joining the tables

• Different types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN
Answered by AI
Add your answer
Q4. Java concepts used in your project
Ans. 
Used Java concepts such as inheritance, polymorphism, and exception handling in my project.
• Implemented inheritance to create a base class and derived classes with specific functionalities.

• Utilized polymorphism to allow objects of different classes to be treated as if they were of the same class.

• Implemented exception handling to handle errors and prevent program crashes.

• Used interfaces to define a set of methods that a ...read more
Answered by AI
Add your answer
Q5. Overloading vs overriding, practical uses
Ans. 
Overloading is having multiple methods with the same name but different parameters. Overriding is having a method in a subclass with the same name and parameters as a method in the superclass.
• Overloading is used to provide different ways to call a method with different parameters

• Overriding is used to provide a specific implementation of a method in a subclass

• Overloading is resolved at compile-time while overriding is r...read more
Answered by AI
Add your answer