JCB Interview Questions and Answers

To form a query in SQL, use the SELECT statement followed by the columns to retrieve and the table to retrieve from.

• Use the SELECT statement to specify the columns to retrieve

• Use the FROM keyword to specify the table to retrieve from

• Use the WHERE keyword to specify any conditions for the query

• Use the ORDER BY keyword to specify the order of the results

• Use the GROUP BY keyword to group the results by a specific column

• Use the JOIN keyword to combine data from multiple tables

• Exa...read more

Yes, Agile is a project management methodology that emphasizes on iterative and incremental development.

• Agile is based on the Agile Manifesto which values individuals and interactions, working software, customer collaboration, and responding to change.

• It involves breaking down the project into smaller chunks called sprints and delivering a working product incrementally.

• Scrum, Kanban, and Extreme Programming (XP) are some of the popular Agile frameworks.

• Agile is widely used in...read more

The 4 P's of marketing are Product, Price, Place, and Promotion, essential for effective marketing strategies.

• Product: The item or service offered, e.g., a smartphone with unique features.

• Price: The cost consumers pay, e.g., premium pricing for luxury brands.

• Place: Distribution channels, e.g., selling online vs. in retail stores.

• Promotion: Marketing communications, e.g., social media advertising or TV commercials.

SDLC cycle is a process followed by software development teams to design, develop and test high-quality software.

• SDLC stands for Software Development Life Cycle

• It consists of several phases including planning, analysis, design, implementation, testing, and maintenance

• Each phase has its own set of deliverables and goals

• The cycle is iterative, meaning that each phase may be revisited multiple times

• The goal is to produce high-quality software that meets the needs of the end-user...read more

Joins in SQL combine rows from two or more tables based on related columns.

• INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id;

• LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id;

• RIGHT JOIN: Returns all records from the right table and matched records from the left table. Example: SELECT * FROM A RIGHT JOIN B ON A.id = ...read more