Xcellence IT Interview Questions and Answers

Q1. Languages attended
Add your answer

Logic and MCQ were there

Q1. How cobol db 2 works? how to add checkpoint logic.
Ans. 
COBOL DB2 is a programming language used for database management. Checkpoint logic is used to ensure data integrity and recoverability.
• COBOL DB2 is used for accessing and manipulating data in DB2 databases.

• Checkpoint logic in COBOL DB2 involves saving the current state of the database at specific points to ensure data integrity.

• To add checkpoint logic, you can use COMMIT and ROLLBACK statements in your COBOL DB2 progra...read more
Answered by AI
Add your answer
Q2. How jcl works, how to do restart
Ans. 
JCL (Job Control Language) is used to control batch jobs on mainframe systems. Restarting a job involves identifying the step where it failed and resubmitting the job from that step.
• JCL is used to define and control batch jobs on mainframe systems

• To restart a job, identify the step where it failed

• Modify the JCL to start from the failed step by specifying the restart parameter

• Submit the modified JCL to restart the job
Answered by AI
Add your answer

It was easy, the topic is upi

Aptitude + coding Test

Q1. It's about my projects
Add your answer
Q2. And few Javascript questions
Add your answer

Q1. General HR questions
Add your answer

Q1. What are different KPI's
Ans. 
Key Performance Indicators (KPIs) are measurable values that demonstrate how effectively a company is achieving key business objectives.
• KPIs are specific, measurable, achievable, relevant, and time-bound metrics used to evaluate the success of an organization or a particular activity.

• Examples of KPIs include revenue growth rate, customer acquisition cost, customer retention rate, website traffic, conversion rate, and e
Answered by AI
Add your answer
Q2. Differentiate loc and iloc in pandas
Ans. 
loc is label-based indexing while iloc is integer-based indexing in pandas.
• loc is used to access a group of rows and columns by labels

• iloc is used to access a group of rows and columns by integer position

• Example: df.loc['row_label', 'column_label'] vs df.iloc[0, 1]
Answered by AI
Add your answer

Used an online IDE and asked general DS Algo questions

Q1. System Design HLD question to make URL shortener
Add your answer

Q1. General HR Aptitude questions
Add your answer

Online assessment with quantitative and qualitative questions

Some Tree traversal coding question

Q1. Load balancer design question
Add your answer
Q2. Technical challenges faced
Add your answer