Gorica Group Interview Questions and Answers

Path params are part of the URL path, while query params are appended to the URL after a '?'

• Path params are used to identify a specific resource in the URL path, while query params are used to filter or sort the resources

• Path params are defined in the URL path itself, such as /users/{id}, while query params are appended to the URL, such as /users?sort=asc

• Path params are typically used for mandatory parameters, while query params are used for optional parameters

• Path params are...read more

SQL query using inner join to retrieve data from two tables

• Use INNER JOIN to combine rows from two tables based on a related column

• Specify the columns to select from each table

• Add a condition to match the related columns in the ON clause

Yes, POST method should be used for sending sensitive data or when data length exceeds URL limit.

• POST method should be used when sending sensitive data like passwords or personal information.

• POST method should be used when the data length exceeds the URL limit, as GET has a limit on the amount of data that can be sent.

• GET method should be used for retrieving data from the server without changing anything on the server.

Where clause is used to filter rows before grouping, while having clause is used to filter groups after grouping.

• Where clause is used with SELECT, UPDATE, DELETE statements to filter rows based on a condition

• Having clause is used with GROUP BY statement to filter groups based on a condition

• Where clause is applied before grouping, having clause is applied after grouping

• Example: SELECT * FROM table_name WHERE column_name = 'value'

• Example: SELECT column_name, COUNT(*) FROM table...read more

Aggregate functions in SQL are used to perform calculations on a set of values and return a single value.

• Aggregate functions include functions like SUM, AVG, COUNT, MIN, and MAX.

• SUM - calculates the sum of values in a column

• AVG - calculates the average of values in a column

• COUNT - counts the number of rows in a result set

• MIN - finds the minimum value in a column

• MAX - finds the maximum value in a column