Avaloq Plsql Developer Interview Questions and Answers

Q1. What are closures in javascript
Ans. 
Closures in JavaScript are functions that have access to variables from their outer scope even after the outer function has finished executing.
• Closures allow for maintaining state in an asynchronous environment

• They are created whenever a function is defined within another function

• Example: function outerFunction() { let outerVar = 'I am outer'; return function innerFunction() { console.log(outerVar); }; }
Answered by AI
Add your answer

Q1. Is NaN === NaN
Add your answer

Q1. How do you handle stressful situations?
Ans. 
I handle stressful situations by staying calm, prioritizing tasks, and seeking support when needed.
• I prioritize tasks to focus on what needs to be done first

• I take breaks to clear my mind and refocus

• I communicate with team members or supervisors for guidance and support

• I practice mindfulness techniques such as deep breathing or meditation
Answered by AI
Add your answer

Q1. Projects worked on
Add your answer
Q2. Coding leetcode easy/medium questions
Add your answer

Q1. Tell me about yourself
Add your answer

Dsa predict the output

One medium problem. Based on that the students are selected. And modifications in code has been asked

Q1. Coding related questions
Add your answer

No of Questions : 4 questions
Difficulty : Difficult
Topics : Sieve of eratosthenis, DP, Hashing

Q1. Search in the rotated Sorted array. (Binary Search - pivot)
Ans. 
Search for an element in a rotated sorted array using binary search with pivot.
• Find the pivot element using binary search.

• Compare the target element with the first element of the array to determine which half to search.

• Perform binary search on the selected half of the array.

• Repeat until the target element is found or the array is exhausted.
Answered by AI
Add your answer
Q2. Sort the array which consists of 0's, 1's , 2's. (Two Pointer approach)
Ans. 
Sort an array of 0's, 1's, and 2's using two pointer approach.
• Initialize two pointers, one at the beginning and one at the end of the array.

• Traverse the array and swap 0's to the beginning and 2's to the end using the pointers.

• Stop when the pointers meet or cross each other.
Answered by AI
Add your answer
Q3. Tell me about id selector in CSS
Ans. 
ID selector is used to select an element with a specific ID attribute in CSS.
• ID selector is denoted by '#' followed by the ID name.

• ID should be unique on a page.

• ID selector has higher specificity than class selector.

• Example: #header { color: blue; }
Answered by AI
Add your answer

Q1. Differences between ShallowCopy & DeepCopy
Ans. 
ShallowCopy copies only the reference of an object while DeepCopy creates a new object with a new reference.
• ShallowCopy creates a new reference to the same object, so changes made to the copy will reflect in the original object.

• DeepCopy creates a new object with a new reference, so changes made to the copy will not reflect in the original object.

• ShallowCopy is faster and less memory-intensive than DeepCopy.

• DeepCopy is ...read more
Answered by AI
Add your answer
Q2. Define Copy Constructor
Ans. 
Copy constructor is a special constructor that creates a new object by copying an existing object.
• It is used to create a new object with the same values as an existing object.

• It takes an object of the same class as a parameter.

• It is automatically called when a new object is created from an existing object.

• It creates a deep copy of the object, meaning that all the member variables are copied.

• Example: class MyClass { pub...read more
Answered by AI
Add your answer
Q3. Define Operator overloading
Ans. 
Operator overloading allows operators to have different meanings based on the context of their usage.
• Operator overloading is a feature in object-oriented programming languages.

• It allows operators to be redefined for custom classes.

• For example, the '+' operator can be overloaded to concatenate strings or add numbers.

• It can improve code readability and reduce the amount of code needed for certain operations.
Answered by AI
Add your answer
Q4. Differences between struct and class
Ans. 
Struct is a value type while class is a reference type in C#.
• Structs are stored on the stack while classes are stored on the heap.

• Structs cannot be inherited while classes can be inherited.

• Structs do not support destructors while classes do.

• Structs are used for small data structures while classes are used for larger, more complex objects.

• Example of struct: struct Point { public int X; public int Y; }

• Example of class: c...read more
Answered by AI
Add your answer
Q5. DSA : Search an element in infinite soted array
Ans. 
Search an element in an infinite sorted array using binary search.
• Initialize low as 0 and high as 1.

• Double the high index until arr[high] is greater than the target element.

• Perform binary search between low and high indexes.
Answered by AI
Add your answer

Q1. Basic screening questions
Add your answer

Same questions related technical

Q1. Salary discussion
Add your answer

25 Aptitude MCQ and 25 post based MCQ

Q1. They are asking Technical Questions
Add your answer

Q1. They are asking HR questions
Add your answer

Easy to Medium Data Structures Question they will ask

Q1. Basic DSA questions and basic core topics
Add your answer
Q2. Java easy to medium difficulty questions
Add your answer