Data Intern Interview Questions and Answers

To sort raw data in spreadsheets, use the sort function or the filter function in spreadsheet software.

• Use the sort function to arrange data in ascending or descending order based on a specific column.

• Use the filter function to display only the rows that meet certain criteria.

• Click on the column header and select the sort option to manually sort the data.

• Apply multiple sorting criteria by selecting multiple columns.

• Use the sort range option to sort a specific range of cells w...read more

Both Excel and Google Sheets are safe to store data, but the level of security may vary.

• Excel and Google Sheets have built-in security features to protect data.

• Both platforms offer password protection and encryption options.

• Google Sheets has the advantage of automatic cloud backup, reducing the risk of data loss.

• Excel allows for more advanced security measures, such as file-level protection and restricted access.

• The choice between the two depends on the specific needs and pre...read more

Tuples and lists are data structures in Python used to store multiple items. Tuples are immutable while lists are mutable.

• Tuples are created using parentheses, while lists are created using square brackets.

• Tuples are immutable, meaning their values cannot be changed after creation.

• Lists are mutable, allowing for changes to be made to their values.

• Both tuples and lists can store different data types, including strings, integers, and other data structures.

• Example: tuple = (1, '...read more

DDL and DML commands in SQL

• DDL (Data Definition Language) commands: CREATE, ALTER, DROP, TRUNCATE

• DML (Data Manipulation Language) commands: SELECT, INSERT, UPDATE, DELETE

• DDL commands are used to define the structure of database objects

• DML commands are used to manipulate data within the database

• Example: CREATE TABLE (DDL), INSERT INTO (DML)