K2 Developer Interview Questions and Answers

Explanation of SQL joins and examples

• Inner join: returns only matching rows from both tables

• Left join: returns all rows from left table and matching rows from right table

• Right join: returns all rows from right table and matching rows from left table

• Full outer join: returns all rows from both tables

• Example: Inner join - SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column

• Example: Left join - SELECT * FROM table1 LEFT JOIN table2 ON table1.column = table2.col...read more

Optimize images, reduce HTTP requests, minify CSS and JS, use caching, and optimize database queries.

• Optimize images by compressing them and reducing their size.

• Reduce HTTP requests by combining multiple files into one.

• Minify CSS and JS by removing unnecessary characters.

• Use caching to store frequently accessed data.

• Optimize database queries by indexing tables and avoiding unnecessary joins.

Workflow rules are used to automate business processes and enforce rules mainly based on conditions.

• Workflow rules are created in K2 Designer.

• Conditions are set using logical operators such as AND, OR, NOT.

• Actions can be triggered based on the conditions being met.

• Examples of conditions include checking if a field is empty or if a date is in the past.

• Workflow rules can be used to send notifications, update data, or start other workflows.

Yes, I have integrated APIs in my previous projects.

• Integrated Google Maps API for location services

• Integrated Stripe API for payment processing

• Integrated Twilio API for SMS notifications