Amazon Interview Questions and Answers

Stop words are common words like 'the', 'is', 'and' that are removed during text cleaning to improve NLP performance.

• Stop words are commonly removed during text cleaning to reduce noise and improve the performance of natural language processing (NLP) tasks.

• Examples of stop words include 'the', 'is', 'and', 'in', 'on', 'at', 'for', 'to', etc.

• Removing stop words can help in reducing the dimensionality of the data and focusing on more meaningful words for analysis.

• However, in so...read more

Delete removes specific rows, drop removes entire table, truncate removes all rows but keeps table structure.

• Delete is used to remove specific rows from a table based on a condition.

• Drop is used to remove an entire table from the database.

• Truncate is used to remove all rows from a table but keeps the table structure intact.

• Delete operation can be rolled back, while drop and truncate operations cannot be rolled back.

• Example: DELETE FROM table_name WHERE condition;

• Example: DROP...read more

Troubleshooting laptop sound involves checking volume settings, audio drivers, and hardware connections.

• Check volume settings on the laptop and ensure it is not muted or set too low.

• Update or reinstall audio drivers to ensure they are functioning properly.

• Check hardware connections such as headphones or external speakers to ensure they are properly connected.

• Restart the laptop to see if the sound issue resolves.

• Run a diagnostic test to identify any hardware issues that may be...read more

Correlated subqueries in SQL are subqueries that reference columns from the outer query.

• Correlated subqueries are executed for each row processed by the outer query.

• They can be used to filter results based on values from the outer query.

• Example: SELECT * FROM table1 WHERE column1 = (SELECT MAX(column2) FROM table2 WHERE table2.id = table1.id)

An operating system is a software that manages computer hardware and provides services for computer programs.

• Manages computer hardware resources

• Provides services for computer programs

• Acts as an intermediary between software and hardware

• Examples: Windows, macOS, Linux

Laptops are portable computers with built-in screen and keyboard, while desktops are stationary computers with separate monitor and keyboard.

• Laptops are portable and can be easily carried around, while desktops are stationary and not easily moved.

• Laptops have a built-in screen and keyboard, while desktops have separate monitors and keyboards.

• Laptops are generally more expensive than desktops with similar specifications.

• Desktops are easier to upgrade and repair compared to lap...read more

Guided Buying is a procurement process that guides users to make compliant purchases.

• It is a user-friendly procurement process that helps users make compliant purchases.

• It provides users with a pre-approved list of suppliers and products.

• It ensures compliance with company policies and regulations.

• It helps to streamline the procurement process and reduce maverick spending.

• Example: A company may implement guided buying for office supplies, providing employees with a list of app...read more

Projects are temporary endeavors undertaken to create a unique product, service, or result.

• Projects have defined objectives and goals.

• They have a specific start and end date.

• Projects require resources such as time, money, and people.

• They involve risk and uncertainty.

• Examples: Developing a new software application, constructing a building, organizing an event.