Crowe Horwath Placement Assessment

What are the key features of object-oriented programming?

• Composition

• Delegation

• Abstraction and Encapsulation

• Encapsulation, Inheritance, Polymorphism, Abstraction

Explain the difference between Java and C#.

• Java is only used for mobile applications, while C# is used for web development.

• C# is an open-source language, whereas Java is proprietary software.

• Java and C# both run exclusively on Windows operating systems.

• Java is platform-independent and runs on JVM, while C# is primarily for .NET and Windows integration.

What is the purpose of normalization in database design?

• To increase data redundancy and decrease data integrity.

• To simplify the database structure by merging tables.

• To enhance the performance of database queries without changing data structure.

• The purpose of normalization is to reduce data redundancy and improve data integrity.

Describe the process of writing an optimized stored procedure in SQL Server.

• Ignoring error handling and performance testing.

• Writing stored procedures without defining any requirements.

• The process of writing an optimized stored procedure in SQL Server involves defining requirements, using efficient SQL queries, implementing error handling, and testing performance.

• Using only SELECT statements without optimization techniques.

How would you approach solving a complex math problem?

• Break down the problem, identify concepts, solve step by step, and combine results.

• Guess the answer randomly

• Ignore the problem and move on

• Ask someone else to solve it for you

What is pseudocode and how is it used in programming?

• Pseudocode is a programming language used to write software directly.

• Pseudocode is a type of code that can be executed by a computer.

• Pseudocode is a simplified, human-readable representation of an algorithm used to plan and design programs.

• Pseudocode is a graphical representation of data structures in programming.

List some common data validation techniques used in financial services.

• Data encryption methods

• Network security protocols

• Range checks, format checks, consistency checks, cross-validation.

• User authentication techniques

What tools can be used for data analysis and visualization?

• Notepad

• Photoshop

• Python, R, Tableau, Microsoft Power BI, Excel

• Google Docs

Explain the significance of relational databases in data management.

• Relational databases are only used for small datasets.

• Relational databases are significant in data management because they provide structured data organization, ensure data integrity, support complex queries, and facilitate efficient data manipulation and retrieval.

• Relational databases are primarily used for storing images and videos.

• Relational databases do not support data integrity.

What are the main differences between Python and R?

• Python is slower than R in executing statistical computations.

• Python is primarily used for web development, while R is used for machine learning.

• Python is a general-purpose language with a broad application scope, while R is specialized for statistical analysis and data visualization.

• R is a general-purpose programming language, while Python is only for data analysis.