Clandica Interview Questions and Answers

Aggregate functions in SQL are used to perform calculations on a set of values and return a single value.

• Common aggregate functions include SUM, AVG, COUNT, MAX, and MIN.

• SUM calculates the total of a set of values.

• AVG calculates the average of a set of values.

• COUNT counts the number of values in a set.

• MAX returns the highest value in a set.

• MIN returns the lowest value in a set.

Answering the question of writing name 100 times without using any loop.

• Write your name 100 times manually

• Use copy-paste feature to write your name multiple times

• Use a script or program to generate your name 100 times

OOPs stands for Object-Oriented Programming. Pillars of OOPs are Inheritance, Encapsulation, Abstraction, and Polymorphism. Lists and tuples are data structures in Python.

• OOPs stands for Object-Oriented Programming

• Pillars of OOPs are Inheritance, Encapsulation, Abstraction, and Polymorphism

• Lists and tuples are data structures in Python

• Lists are mutable while tuples are immutable

A recursion program is a function that calls itself until a base case is reached.

• Identify the base case and write the code to handle it

• Write the recursive case that calls the function with a modified input

• Ensure the recursive case moves towards the base case

• Example: Factorial function: function factorial(n) { if (n === 0) { return 1; } else { return n * factorial(n-1); } }

• Example: Fibonacci sequence: function fibonacci(n) { if (n <= 1) { return n; } else { return fibonacci(n-...read more

Remove duplicates from an array

• Use a loop to iterate through the array

• Use a hash table to keep track of unique values

• If a value is already in the hash table, remove it from the array

The pillars of Python refer to the core principles that guide the design and development of the Python programming language.

• Readability counts: Python emphasizes code readability and simplicity, making it easier for developers to write and maintain code.

• Explicit is better than implicit: Python encourages clear and explicit code over ambiguity and complexity.

• Simple is better than complex: Python promotes simplicity and straightforward solutions to problems.

• There should be one-...read more