Citicorp Interview Questions, Process, and Tips

SQL joins are used to combine rows from two or more tables based on a related column between them.

• SQL joins are used to retrieve data from multiple tables based on a related column between them

• Common types of SQL joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the...read more

Common automation tools used in testing include Selenium, Appium, JUnit, TestNG, and Cucumber.

• Selenium is widely used for web application testing

• Appium is popular for mobile application testing

• JUnit and TestNG are commonly used for unit testing in Java

• Cucumber is used for behavior-driven development testing

We primarily use Selenium for automation testing, along with tools like JUnit and TestNG for test execution and reporting.

• Selenium is the main automation tool used for web application testing

• JUnit and TestNG are used for test execution and reporting

• We also utilize tools like Cucumber for behavior-driven development

Trade life cycle is the process of a trade from initiation to settlement.

• Initiation: Trade is proposed and agreed upon by parties involved.

• Execution: Trade is executed either manually or electronically.

• Confirmation: Parties confirm details of the trade.

• Clearing: Trade details are submitted to clearing house for validation.

• Settlement: Actual exchange of funds and securities takes place.

• Post-trade processing: Reconciliat...read more

Bilateral trade refers to the exchange of goods and services between two countries.

• Bilateral trade agreements are made between two countries to facilitate trade and investment.

• It involves the import and export of goods and services between the two countries.

• Bilateral trade can help strengthen diplomatic relations between countries.

• Examples include the US-Mexico trade agreement and the Australia-Japan trade agreement.