Amdocs Associate Software Engineer Interview Questions and Answers

To find the second highest salary, we can use SQL queries with various approaches like subqueries or the DISTINCT keyword.

• Use a subquery: SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);

• Use DISTINCT: SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 1;

• Use ROW_NUMBER(): SELECT salary FROM (SELECT salary, ROW_NUMBER() OVER (ORDER BY salary DESC) AS rank...read more

Swapping two character variables without using third

• Use XOR operator to swap two variables without using third variable

• Assign the XOR of both variables to the first variable

• Assign the XOR of the first variable and second variable to the second variable

Python is a high-level programming language known for its simplicity and readability. Constructors are special methods used to initialize objects in classes.

• Python is a versatile programming language used for web development, data analysis, artificial intelligence, and more.

• Constructors in Python are special methods with the __init__() function that initialize objects when they are created.

• Arrays in Python are dat...read more

Addition and Deletion of a node in binary tree

• For addition, traverse the tree to find the appropriate position and add the new node as a leaf

• For deletion, find the node to be deleted and replace it with its successor or predecessor

• In case of deletion, if the node has two children, find the inorder successor and replace it with the node to be deleted

Libraries and packages in Python are reusable collections of code that provide functionality to perform specific tasks.

• Libraries and packages help in reducing the amount of code that needs to be written from scratch

• Popular libraries in Python include NumPy for numerical computing, Pandas for data manipulation, and Matplotlib for data visualization

• Packages can be installed using package managers like pip or conda

A static variable in C is a variable that retains its value between function calls.

• Declared using the 'static' keyword

• Retains its value throughout the program's execution

• Useful for maintaining state across function calls