Covansys Interview Questions and Answers

Q1. Skillset, Current CTC, Expected CTC, Notice Period
Add your answer
Q2. Ready to work 3 days from office Ready to work from client location in Gurgaon (without extra pay)
Add your answer

Q1. Intro, Role and responsibilities in current project
Add your answer
Q2. Explain test plan in detail Explain software testing life cycle in detail
Add your answer
Q3. What are joins in sql? Write query (for any one join) and explain that query with output
Add your answer
Q4. Write test cases for uploading a file and explain each scenario
Add your answer
Q5. Explain the process of regression testing in detail. Why we do it? When we do it? How we should do it? Explain the strategy to chose regression test suite. What is the current process followed in your proj...read more
Add your answer
Q6. How to create a bug in jira? What all information needs to be entered while raising a defect in jira? What labels , tags to be used. Write all information in detail and explain with an example
Add your answer
Q7. What is priority and severity of a defect? Explain different types. How to chose priority and severity of a defect? Explain everything with example
Add your answer
Q8. Explain defect management system and test management system in detail. What tools you are using to manage them in your current project
Add your answer
Q9. Explain the process of test case creating and execution in qtest and how one can check the overall progress of test execution. Based on execution if test report is getting generated, explain that in detail
Add your answer
Q10. How to check reports generated in sql. What are the benefits of doing database testing
Add your answer
Q11. What is the tool you are currently using for verifying regulatory reports? Explain the process in detail. What things you verify in those reports
Add your answer

Q1. Tell me about Yourself
Add your answer
Q2. What is ARP? How it will work? Can we able to delete the ARP entry? And What is the command? How long the ARP entry will be there in table? What is ARP Poisoning?
Add your answer
Q3. What is DHCP? Explain in Detail?
Add your answer
Q4. What is TCP/UDP and how it will work?
Add your answer
Q5. What is VLAN a d how it will work? Explain with scenario
Add your answer
Q6. What is STP and how it will work?
Add your answer
Q7. How to check network connectivity speed? And how will you debug? How can you increase the frames size and how to capture the frames?
Add your answer
Q8. Explain me Layer2 and Layer3 in detail
Add your answer
Q9. What is ICMP and how it will work? How ping works?
Add your answer
Q10. What is the difference between RIP and OSPF? Explain me OSPF?
Add your answer
Q11. What is the difference between Cisco switch and other company switches? What is the difference between cisco switch and white box switch?
Add your answer
Q12. What is SONIC cards?
Add your answer
Q13. Python program. Input: lst = [12,83,0,17,0,71] Output = [12,83,17,71,0,0] Answer: lst=[12, 83,0,17,0,71] ls=[] l=[] for i in lst: if i! = 0: ls.append(i) else: l.append(i) ...read more
Add your answer
Q14. Print the below mentioned pattern: * * * * * * * * * * * * * * *
Add your answer

Mcq questions on python aws database and networks ans os

8 members in a panel and they gave a topic generally a social issue or a general topic you can a lot about

Q1. Project based questions
Add your answer
Q2. Python and pandas core question
Add your answer
Q3. Dsa question combination sum
Add your answer
Q4. Database queries
Add your answer

Q1. Question to test your soft skills
Add your answer
Q2. About behavioral attitude and how likely you are to fit in their organization
Add your answer

Q1. What is your current work profile?
Add your answer
Q2. What is CIR ratio
Add your answer

Q1. What is Return on Tangible Equity (RoTE), and how do planning and budgeting work?
Add your answer
Q2. What is a Banking Profit and Loss (P&L) statement?
Add your answer

Q1. What are the different sizes available for a virtual warehouse in Snowflake, and which sizes are currently being utilized in your current project?
Add your answer
Q2. What are stored procedures in Snowflake, and how did you utilize them?
Add your answer

Q1. How did you verify the data after transferring it from one database to another?
Add your answer
Q2. What are the different types of duplicate checks that can be performed using SQL queries?
Add your answer

Q1. Are you open to relocating to Hyderabad?
Add your answer
Q2. What information do you have about ValueLabs?
Add your answer

Q1. Regarding previous project work
Add your answer
Q2. MCDC, DO178-B/C
Add your answer

Q1. Project explanation
Add your answer
Q2. Basic Coding like dead code and deactivate code.
Add your answer

Q1. Package discussion
Add your answer

Q1. Explain capital markets
Ans. 
Capital markets are where financial securities are bought and sold, including stocks, bonds, and commodities.
• Capital markets facilitate the buying and selling of financial securities such as stocks, bonds, and commodities.

• They provide a platform for companies and governments to raise capital by issuing securities to investors.

• Investors can trade these securities through exchanges like the New York Stock Exchange (NYSE)...read more
Answered by AI
Add your answer
Q2. Explain Reconciliation, explain bond market, futures and options
Ans. 
Reconciliation involves comparing two sets of records to ensure they are in agreement. Bond market, futures, and options are financial instruments used for trading.
• Reconciliation is the process of comparing two sets of records to ensure they are in agreement, typically used in accounting to verify transactions.

• The bond market is where investors buy and sell debt securities issued by governments or corporations, with th...read more
Answered by AI
Add your answer

Q1. How do you handle audit queries
Ans. 
I handle audit queries by thoroughly reviewing the information, communicating effectively with stakeholders, and providing detailed responses.
• Thoroughly review the audit query to understand the scope and requirements

• Communicate with relevant stakeholders to gather necessary information and clarify any doubts

• Provide detailed responses with supporting documentation and explanations

• Follow up on any outstanding queries to
Answered by AI
Add your answer
Q2. How to handle team
Ans. 
Handle team by setting clear expectations, providing support, fostering open communication, and recognizing achievements.
• Set clear expectations and goals for the team members.

• Provide necessary support and resources to help team members succeed.

• Foster open communication and encourage feedback from team members.

• Recognize and reward achievements to motivate the team.

• Address conflicts and issues promptly to maintain a posi
Answered by AI
Add your answer

Q1. Questions on Jetpack compose, kotlin, hilt, permission, Testing,
Add your answer

Q1. Questions on mvvm, clean architecture.
Add your answer

Q1. Client round with questions on android permission, Android security
Add your answer

Q1. Salary discussed
Add your answer

Q1. Process and technical questions
Add your answer
Q2. SQL and Databases
Add your answer
Q3. IIS and WebServer
Add your answer
Q4. Troubleshooting
Add your answer
Q5. Proactiveness and leadership
Add your answer