Chetu Software Engineer Interview Questions and Answers

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 t...read more

Print and echo are both used to output data in PHP, but they have key differences in usage and behavior.

• echo can take multiple parameters: echo 'Hello', 'World';

• print can only take one argument: print 'Hello World';

• echo is slightly faster than print because it doesn't return a value;

• print returns 1, so it can be used in expressions: $result = print 'Hello';

• echo does not require parentheses: echo 'Hello'; while pri...read more

Triggers are used to perform custom actions before or after specific events, while Process Builders are used to automate business processes.

• Triggers are written in Apex code, while Process Builders are point-and-click tools in Salesforce.

• Triggers can handle complex logic and multiple objects, while Process Builders are more declarative and easier to use.

• Triggers execute at the database level, while Process Builder...read more

Storefront apk is a mobile application package file used for online shopping platforms.

• Storefront apk is a file format used for Android apps that provide online shopping services.

• It contains all the necessary files and resources for the app to function properly.

• Users can download and install the storefront apk on their Android devices to access the online shopping platform.

• Examples of storefront apks include Amazo...read more

Mixin is a way to reuse code in multiple classes by including the code in another class.

• Mixin allows for code reuse by combining methods and attributes from multiple classes into a single class.

• It helps in avoiding code duplication and promotes modular design.

• An example of mixin is a class 'Logger' that contains logging methods and can be included in other classes to enable logging functionality.

Assets pipeline in Rails is a feature that helps manage and compile assets like CSS, JavaScript, and images for a Rails application.

• The assets pipeline in Rails combines and minifies assets to improve performance.

• It allows for easy organization and management of assets in a Rails project.

• By default, Rails uses Sprockets as the assets pipeline to handle asset compilation and management.

• You can customize the assets ...read more

Reverse a string in C# without using built-in features

• Create a character array from the input string

• Use two pointers to swap characters at the beginning and end of the array

• Continue swapping until the pointers meet in the middle