10+ Commonwealth Bank of Australia, India Interview Questions and Answers

To do sales and create market, one must understand customer needs, build relationships, set clear targets, and utilize tools like Excel and Word.

• Understand customer needs and tailor solutions to meet them

• Build strong relationships with clients and prospects

• Set clear and achievable sales targets

• Utilize Excel for data analysis and tracking sales performance

• Use Word for creating professional sales proposals and documents

To convince about any product, highlight its unique features, benefits, and value proposition.

• Understand the customer's needs and pain points

• Highlight the product's unique features and benefits

• Show how the product solves the customer's problems

• Provide social proof and testimonials

• Offer a trial or demo to showcase the product's value

To sell an IT product, focus on understanding customer needs, showcasing product benefits, providing demos, offering trials, and following up.

• Understand customer needs and pain points to tailor your pitch

• Highlight the unique features and benefits of the IT product

• Provide product demos to showcase its functionality and ease of use

• Offer free trials or discounts to encourage customers to try the product

• Follow up with potential customers to address any concerns and close the sale

The unique selling proposition (USP) of a company is what sets it apart from competitors and highlights the benefits of its products or services.

• USP should be clear, concise, and easily understood by customers.

• It should focus on the unique benefits or features that the company offers.

• USP helps in creating a strong brand identity and attracting target customers.

• Examples of USPs include Apple's focus on innovation and design, Nike's emphasis on performance and athleticism, and ...read more

To achieve targets, set clear goals, create a strategic plan, track progress, adjust strategies as needed, and motivate team members.

• Set specific, measurable, achievable, relevant, and time-bound goals

• Develop a strategic plan outlining steps to reach targets

• Regularly track progress and adjust strategies as needed

• Motivate team members through incentives, recognition, and support

I am unable to provide my last 3 months salary slips at this time.

• I am unable to disclose my salary information as it is confidential.

• I can provide information on my salary expectations or previous compensation in a different format.

• Salary information can be discussed further in a confidential setting during the interview process.

To achieve target, one needs to set specific, measurable, achievable, relevant, and time-bound goals and create a plan to execute them.

• Set SMART goals

• Create a plan to achieve the goals

• Track progress regularly

• Make necessary adjustments to the plan

• Stay motivated and focused

• Collaborate with team members

• Learn from failures and successes

Drop command removes a table from the database while delete command removes rows from a table.

• Drop command is a DDL (Data Definition Language) command while delete command is a DML (Data Manipulation Language) command.

• Drop command is irreversible and removes the entire table structure and its data while delete command only removes specific rows.

• Drop command requires the DROP privilege while delete command requires the DELETE privilege.

• Examples: DROP TABLE customers; DELETE FR...read more

Primary key uniquely identifies each record in a database table.

• Primary key ensures data integrity and consistency.

• It helps in faster data retrieval and indexing.

• It can be a single column or a combination of columns.

• Primary key cannot have null values.

• Examples of primary keys are social security number, email address, etc.

Types of Joins are used in SQL to combine rows from two or more tables based on a related column between them.

• Inner Join: Returns only the matching rows from both tables.

• Left Join: Returns all the rows from the left table and the matching rows from the right table.

• Right Join: Returns all the rows from the right table and the matching rows from the left table.

• Full Outer Join: Returns all the rows from both tables, including the unmatched rows.

• Cross Join: Returns the Cartesian ...read more

Query to display employees records

• Use SELECT statement to retrieve data from employee table

• Specify the columns to be displayed in the SELECT statement

• Use WHERE clause to filter the records based on specific conditions

• Use ORDER BY clause to sort the records in ascending or descending order

A foreign key is a column or set of columns in a table that refers to the primary key of another table.

• It is used to establish a relationship between two tables in a database.

• It ensures referential integrity by preventing invalid data from being inserted into the table.

• It allows for efficient querying and joining of related data.

• Example: A customer table may have a foreign key that references the primary key of an orders table.

• The foreign key column in the customer table woul...read more