CSC Interview Questions and Answers for Freshers

Q1. Difference between sql and nosql
Ans. 
SQL is a relational database management system, while NoSQL is a non-relational database management system.
• SQL databases are table-based and have a predefined schema, while NoSQL databases are document-based, key-value pairs, graph databases, or wide-column stores.

• SQL databases are suitable for complex queries and transactions, while NoSQL databases are better for large amounts of data and scalable applications.

• Example...read more
Answered by AI
Add your answer
Q2. Explain oops concept
Ans. 
OOPs (Object-Oriented Programming) is a programming paradigm based on the concept of objects, which can contain data and code.
• OOPs focuses on creating objects that interact with each other to solve problems.

• Key principles of OOPs include encapsulation, inheritance, polymorphism, and abstraction.

• Encapsulation involves bundling data and methods that operate on the data into a single unit.

• Inheritance allows a class to inh...read more
Answered by AI
Add your answer

Q1. Why are you interested
Ans. 
Passionate about building scalable and efficient backend systems
• Fascinated by the complexity and challenges of backend development

• Enjoy problem-solving and optimizing code for performance

• Excited about the opportunity to work on real-world projects and learn from experienced developers
Answered by AI
Add your answer
Q2. Where did u see yourselves in 5 years
Ans. 
In five years, I envision myself as a skilled backend developer, leading projects and mentoring new talent in a dynamic tech environment.
• I aim to deepen my expertise in backend technologies like Node.js and Python, contributing to impactful projects.

• I see myself taking on leadership roles, guiding teams through complex challenges and fostering collaboration.

• I plan to stay updated with industry trends, possibly contribu...read more
Answered by AI
Add your answer

No aptitude test was taken

Q1. What is Net asset value ?
Ans. 
Net asset value (NAV) is the value of a fund's assets minus its liabilities, divided by the number of shares outstanding.
• NAV is calculated by subtracting the fund's liabilities from its assets.

• The result is then divided by the number of shares outstanding to determine the NAV per share.

• NAV is used to determine the price at which shares of a mutual fund are bought or sold.

• It is an important metric for investors to asses...read more
Answered by AI
Add your answer
Q2. What do you mean by corporate actions ?
Add your answer

Q1. Different types of capital
Ans. 
Different types of capital include financial capital, human capital, social capital, and cultural capital.
• Financial capital refers to money and assets that can be used for investment or production.

• Human capital is the skills, knowledge, and experience possessed by individuals.

• Social capital is the network of relationships and connections that individuals have.

• Cultural capital includes the values, beliefs, and practices...read more
Answered by AI
Add your answer
Q2. Different types of distributions
Ans. 
Different types of distributions refer to the various ways data can be spread out in a dataset.
• Normal distribution: bell-shaped curve with mean and standard deviation

• Uniform distribution: all outcomes are equally likely

• Binomial distribution: discrete distribution with fixed number of trials and probability of success

• Poisson distribution: used for count data with rare events

• Exponential distribution: used for continuous ...read more
Answered by AI
Add your answer

Q1. What is term loan?
Ans. 
A term loan is a type of loan that is repaid in regular installments over a set period of time.
• Term loans have a fixed repayment schedule, typically ranging from one to ten years.

• Interest rates on term loans can be fixed or variable.

• Term loans are commonly used for financing major purchases or investments, such as buying equipment or expanding a business.

• The borrower receives the full loan amount upfront and repays it ...read more
Answered by AI
Add your answer
Q2. What is different types of loan?
Ans. 
Different types of loans include personal loans, home loans, auto loans, student loans, and business loans.
• Personal loans are unsecured loans that individuals can use for various purposes.

• Home loans are used to purchase a home or real estate property.

• Auto loans are specifically for purchasing a vehicle.

• Student loans are used to finance education expenses.

• Business loans are for funding business operations or expansion.
Answered by AI
Add your answer