10+ GMR Group Interview Questions and Answers

ORDERBY is used to sort the result set based on specified columns, while GROUPBY is used to group the result set based on specified columns.

• ORDERBY sorts the result set based on specified columns

• GROUPBY groups the result set based on specified columns

• ORDERBY can be used with aggregate functions like SUM, COUNT, etc.

• GROUPBY is used with aggregate functions to perform operations on each group

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

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right table.

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table.

• FULL JOIN returns rows when there is a match in one of the tabl...read more

PUT is used to update an existing resource, while POST is used to create a new resource.

• PUT replaces the entire resource with the new data, while POST only adds a new sub-resource or modifies an existing one.

• PUT is idempotent, meaning multiple identical requests will have the same effect as a single request, while POST is not.

• PUT requires the client to send the entire updated resource, while POST only requires the relevant data to create or modify the sub-resource.

• Examples: P...read more

CRUD stands for Create, Read, Update, and Delete. It is a set of basic operations used in database management.

• Create - Inserting new data into the database

• Read - Retrieving data from the database

• Update - Modifying existing data in the database

• Delete - Removing data from the database

• CRUD operations are commonly used in web applications and APIs

DELETE removes specific rows from a table, DROP removes entire table, TRUNCATE removes all rows from a table

• DELETE is a DML command used to remove specific rows from a table based on a condition

• DROP is a DDL command used to remove an entire table along with its structure and data

• TRUNCATE is a DDL command used to remove all rows from a table but keeps the table structure intact

• DELETE can be rolled back, DROP and TRUNCATE cannot be rolled back

• Example: DELETE FROM table_name WHE...read more

SQL stands for Structured Query Language, used for managing and manipulating relational databases.

• SQL is a standard language for accessing and manipulating databases.

• Types of SQL include MySQL, PostgreSQL, Oracle, SQL Server, etc.

• SQL can be used to retrieve data, update data, insert data, and delete data from databases.

Automation is the use of technology to perform tasks without human intervention.

• Automation can save time and increase efficiency

• Examples include automated emails, chatbots, and self-driving cars

• Automation can also lead to job loss in certain industries

Thread life cycle in Java includes new, runnable, running, blocked, and terminated states.

• Thread starts in new state when created but not started yet

• Thread moves to runnable state when start() method is called

• Thread transitions to running state when CPU starts executing its run() method

• Thread can go to blocked state if it's waiting for a resource or I/O operation

• Thread enters terminated state when its run() method completes or stop() method is called

Java Virtual Machine (JVM) is a virtual machine that enables a computer to run Java programs.

• JVM is responsible for converting Java bytecode into machine code that can be executed by the computer's processor.

• It provides a layer of abstraction between the Java application and the underlying hardware and operating system.

• JVM is platform-independent, allowing Java programs to run on any device or operating system that has a JVM implementation.

• Examples of JVM implementations incl...read more

Tuple is immutable, fixed-size, ordered collection while list is mutable, variable-size, ordered collection.

• Tuple is created using parentheses () while list is created using square brackets []

• Tuple elements cannot be changed once assigned while list elements can be modified

• Tuple is faster than list for iteration and accessing elements

• Example: Tuple - (1, 2, 3) List - [1, 2, 3]