Enerrgia Skyi Developers Data Scientist Interview Questions and Answers

DELETE is used to remove rows from a table, while DROP is used to remove entire tables from a database.

• 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 entire tables, views, or databases from a database.

• DELETE does not remove the table structure, only the data within it.

• DROP removes the table structure along with all its data, and it cannot be r...read more

Primary Key in SQL is a unique identifier for each record in a table.

• Primary Key ensures each record in a table is unique

• It can consist of one or multiple columns

• Primary Key values cannot be NULL

• Example: 'id' column in a 'users' table

UNION combines and removes duplicates, UNION ALL combines without removing duplicates.

• UNION merges the result sets of two or more SELECT statements, removing duplicates.

• UNION ALL merges the result sets of two or more SELECT statements, including duplicates.

• UNION is slower than UNION ALL as it involves removing duplicates.

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example: SELECT column1 FROM t

The LIKE operator is used in SQL to search for a specified pattern in a column.

• The LIKE operator is used with the WHERE clause to search for a specified pattern in a column.

• It allows for the use of wildcards such as % (matches any sequence of characters) and _ (matches any single character).

• For example, 'SELECT * FROM table_name WHERE column_name LIKE 'a%'' will return all rows where the column starts with 'a'.

I have over 10 years of experience in sales management, leading teams to exceed targets and drive revenue growth.

• Led a sales team to consistently exceed quarterly targets by 20%

• Implemented new sales strategies resulting in a 30% increase in revenue

• Trained and mentored sales representatives to improve performance and customer satisfaction