Fintellix Solutions Associate Consultant Interview Questions and Answers

Round 1 : Aptitude Round (MCQs)
Time : 1.5 Hour

Consist of 3 Sections
1. Quant ( 40 Questions - 60 Minutes )
2. Verbal ( 10 Questions - 15 Minutes )
3. Pseudocode and Language Related Questions ( 10 Question - 15 Minutes )

Topics for Quant: Percentages, Profit & Loss, Speed Distance & Time, Clocks & Angles, Probability, Permutation & Combination, Number System, Simple & Compound Interest, Ratio & Proportion, Letter Series, Number Series, Ages, Blood Relations, Area & Volumes

Topics for Verbal: Paragraphs, Vocabulary, Grammer

Topics for Pseudocode MCQs: C++/Java, Syntax, Variables, Error identification, If-else conditions, for/while/do-while loops, Arrays, Strings, Arithmetic Operations, Bytes, Logical Operators.

Q1. Tell me about yourself
Add your answer
Q2. Tell me about your projetcs
Add your answer
Q3. Explain your projects in detail
Add your answer
Q4. What was your role in projects ?
Add your answer
Q5. Rate yourself in Languages, Development & Databases on the scale of 5
Ans. 
Languages - 4, Development - 3, Databases - 3
• Proficient in Java and Python for development

• Familiar with SQL for database management

• Continuously learning new languages and technologies
Answered by AI
Add your answer
Q6. What is Object Oriented Programming?
Ans. 
Object Oriented Programming is a programming paradigm based on the concept of objects, which can contain data in the form of fields and code in the form of procedures.
• OOP focuses on creating objects that interact with each other to solve problems.

• Encapsulation, inheritance, and polymorphism are key principles of OOP.

• Classes are used to create objects, which can have attributes (fields) and methods (functions).

• Example: ...read more
Answered by AI
Add your answer
Q7. What are 4 pillars of OOP?
Add your answer
Q8. Can you explain all 4 pillars in detail
Add your answer
Q9. What is Structured Query Language?
Add your answer
Q10. What are joints?
Add your answer
Q11. Explain all joints with examples
Add your answer
Q12. What is union? What is intersection?
Ans. 
Union and intersection are set operations in mathematics.
• Union of two sets includes all unique elements from both sets

• Intersection of two sets includes only elements that are common to both sets

• Example: Set A = {1, 2, 3} and Set B = {3, 4, 5}, Union of A and B = {1, 2, 3, 4, 5}, Intersection of A and B = {3}
Answered by AI
Add your answer
Q13. What is normalization ?
Add your answer
Q14. How many forms of normalization are there?
Add your answer
Q15. What is 1NF? (First Normal Form)
Ans. 
1NF is the first step in database normalization where each column in a table contains only atomic values.
• Each column in a table must contain only a single value

• Values in a column must be of the same data type

• Each column must have a unique name

• Example: A table with columns for student ID, name, and address
Answered by AI
Add your answer
Q16. What is 2NF? (Second Normal Form)
Add your answer
Q17. How do we remove partial-dependency in 2NF?
Ans. 
Partial dependency in 2NF can be removed by splitting the table into two separate tables.
• Identify the attributes causing partial dependency in the table.

• Create a new table with the partially dependent attributes along with the determinant attribute.

• Link the new table to the original table using a foreign key.

• Ensure each table now satisfies 2NF independently.
Answered by AI
Add your answer
Q18. What is 3NF? (3rd Normal Form)
Ans. 
3NF is a database normalization technique that ensures data is stored in a table with no transitive dependencies.
• Each non-prime attribute is non-transitively dependent on every super key.

• Every non-prime attribute is fully functionally dependent on the primary key.

• Helps in reducing data redundancy and improving data integrity.

• Example: If a table has columns A, B, and C where B is functionally dependent on A, and C is fu...read more
Answered by AI
Add your answer
Q19. What are character functions?
Add your answer
Q20. Explain any 2 character functions.
Ans. 
Character functions are used to manipulate individual characters in a string.
• toupper(): Converts a character to uppercase

• tolower(): Converts a character to lowercase
Answered by AI
Add your answer
Q21. What are number functions?
Ans. 
Number functions are mathematical operations that can be performed on numbers to manipulate or analyze data.
• Number functions include addition, subtraction, multiplication, division, exponentiation, etc.

• They can be used to perform calculations in various fields such as finance, engineering, and statistics.

• Examples of number functions include finding the average of a set of numbers, calculating the square root, or determ...read more
Answered by AI
Add your answer
Q22. Explain any 2 number functions.
Add your answer
Q23. Write a SQL query to find MAXIMUM salary from the table.
Add your answer
Q24. Write a SQL query to find SECOND MAXIMUM salary from the table.
Add your answer
Q25. Write a SQL query to create database with proper fields
Ans. 
Create a SQL query to create a database with proper fields
• Use CREATE DATABASE statement to create a new database

• Specify the database name after CREATE DATABASE

• Define the fields and their data types using CREATE TABLE statement
Answered by AI
Add your answer

Q1. Introduce Yourself
Add your answer
Q2. What is Object Oriented Programming?
Add your answer
Q3. What are 4 pillars of OOP?
Ans. 
Encapsulation, Inheritance, Polymorphism, Abstraction
• Encapsulation: Bundling data and methods that operate on the data into a single unit

• Inheritance: Ability of a class to inherit properties and behavior from another class

• Polymorphism: Ability to present the same interface for different data types

• Abstraction: Hiding the complex implementation details and showing only the necessary features
Answered by AI
Add your answer
Q4. What is Abstraction? explain it with pseudocode
Add your answer
Q5. What is Encapsulation? explain it with pseudocode
Ans. 
Encapsulation is the concept of bundling data and methods that operate on the data into a single unit.
• Encapsulation helps in hiding the internal state of an object and restricting access to it.

• It allows for better control over the data by preventing direct access from outside the class.

• Encapsulation is achieved in object-oriented programming languages through the use of access specifiers like public, private, and prote...read more
Answered by AI
Add your answer
Q6. What is Inheritance?
Add your answer
Q7. How many types of inheritance are there?
Add your answer
Q8. Explain them in short.
Ans. 
Explain them in short
• Provide a concise explanation of a topic or concept

• Avoid unnecessary details and focus on key points

• Use clear and simple language to ensure understanding
Answered by AI
Add your answer
Q9. What is Polymorphism?
Add your answer

Q1. Tell me about yourself.
Add your answer
Q2. Do you know which role are interviewing for?
Add your answer
Q3. What will be your responsibilities as Associate Consultant?
Add your answer
Q4. Which is regulatory authority of India (Banks)?
Ans. 
The regulatory authority of banks in India is the Reserve Bank of India (RBI).
• Reserve Bank of India (RBI) is the central banking institution in India

• RBI regulates the functioning of banks in India to ensure financial stability and prevent malpractices

• It issues guidelines, policies, and regulations for banks to follow
Answered by AI
Add your answer
Q5. As you leave quite far from office? Will you be able to travel to office daily?
Add your answer
Q6. Will you get bored if you work on same technology for a while?
Add your answer
Q7. Are you willing to take different roles after some time?
Add your answer
Q8. Tell me about your family background
Add your answer
Q9. Do you have any plans for Higher Education / Master?
Add your answer
Q10. Do you have any questions?
Add your answer