CAMS Interview Questions and Answers

Q1. How to find duplicate values in a table
Ans. 
To find duplicate values in a table, use SQL queries to group and count records based on specific columns.
• Use the GROUP BY clause to group records by the column(s) you want to check for duplicates.

• Apply the HAVING clause to filter groups that have a count greater than 1.

• Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;

• You can check for duplicates across multiple columns ...read more
Answered by AI
Add your answer
Q2. How to find 2nd highest salary
Ans. 
To find the 2nd highest salary, use SQL queries to filter and sort salary data effectively.
• Use the DISTINCT keyword to eliminate duplicate salaries: SELECT DISTINCT salary FROM employees.

• Sort the salaries in descending order and use LIMIT or ROWNUM to get the second highest: SELECT salary FROM employees ORDER BY salary DESC FETCH FIRST 1 ROWS ONLY OFFSET 1 ROWS.

• Alternatively, use a subquery: SELECT MAX(salary) FROM emp...read more
Answered by AI
Add your answer

Q1. N type semiconductor
Add your answer
Q2. What is current
Ans. 
Current is the flow of electric charge, measured in amperes, essential for powering devices and circuits.
• Current is defined as the rate of flow of electric charge.

• Measured in amperes (A), where 1 ampere equals 1 coulomb per second.

• There are two types of current: direct current (DC) and alternating current (AC).

• DC flows in one direction, like in batteries, while AC changes direction periodically, as in household outlets...read more
Answered by AI
View 1 more answer
Q3. Personal details
Add your answer
Q4. What is transfarmer
Ans. 
A transfarmer is a tool or process that transforms data or information from one format to another.
• Used in data migration to convert databases from one system to another.

• Example: Converting CSV files to JSON format for web applications.

• Can also refer to software that transforms code from one programming language to another.

• Example: A tool that converts Python code to JavaScript.
Answered by AI
View 1 more answer
Q5. What is KVL
Ans. 
KVL, or Kirchhoff's Voltage Law, states that the sum of electrical potential differences around a closed circuit loop is zero.
• KVL is fundamental in circuit analysis, ensuring energy conservation.

• Example: In a simple loop with a battery and resistors, the voltage drop across resistors equals the battery voltage.

• KVL can be applied in complex circuits using mesh analysis.

• It helps in understanding how voltage is distribute...read more
Answered by AI
View 1 more answer

Q1. Speed of 2 trains using bird travelling between them
Ans. 
The speed of the two trains can be calculated by considering the speed of the bird and the distance between them.
• Calculate the relative speed of the two trains by adding their individual speeds

• Use the formula: Speed of train A + Speed of train B = Speed of bird

• Determine the distance between the two trains to calculate their individual speeds
Answered by AI
Add your answer

Q1. Design an app for on-demand maid services
Ans. 
An app connecting users with on-demand maid services for easy booking and scheduling.
• Users can browse available maids based on location, availability, and reviews

• Allow users to book and pay for services directly through the app

• Include features for scheduling recurring cleanings and special requests

• Provide a rating system for users to leave feedback on maid services

• Offer customer support and easy communication between u...read more
Answered by AI
Add your answer

Q1. General aptitude related
Add your answer

Q1. About their company
Add your answer
Q2. About mutual fund industry
Add your answer

Q1. Introduction an profile
Add your answer
Q2. Profile detail questions
Add your answer

Logical thinking and mathematics MCQ

Q1. What is SEBI and its use
Ans. 
SEBI stands for Securities and Exchange Board of India. It is the regulatory body for the securities market in India.
• Regulates the securities market in India

• Protects the interests of investors

• Promotes fair and transparent dealings in the securities market

• Regulates stock exchanges, brokers, and other intermediaries

• Enforces rules and regulations to prevent fraudulent activities

• Issues guidelines and regulations for compan...read more
Answered by AI
Add your answer
Q2. Excel Shortcuts
Add your answer
Q3. What do you think about mutual funds
Ans. 
Mutual funds are investment vehicles that pool money from multiple investors to invest in a diversified portfolio of securities.
• Mutual funds offer diversification by investing in a variety of securities such as stocks, bonds, and commodities.

• They are managed by professional fund managers who make investment decisions on behalf of the investors.

• Investors can choose from different types of mutual funds based on their ris...read more
Answered by AI
Add your answer

Q1. Using Excel Shortcuts and give output
Ans. 
Excel shortcuts enhance productivity by streamlining tasks, allowing users to navigate and manipulate data efficiently.
• Ctrl + C: Copy selected cells. Example: Highlight a range and press Ctrl + C to copy it.

• Ctrl + V: Paste copied cells. Example: After copying, select a new location and press Ctrl + V.

• Ctrl + Z: Undo the last action. Example: If you accidentally delete a cell, press Ctrl + Z to restore it.

• Alt + Enter: In...read more
Answered by AI
Add your answer