Q: How do you manipulate strings in Python? Write a function that reverses a string and handles edge cases like empty strings.

String manipulation is a fundamental skill in Python. You can use string slicing, concatenation, and various built-in methods to manipulate strings. Here’s an implementation of a function that reverses a string while handling edge cases: ```python def reverse_string(s): if s is None: return 'Input cannot be None' if len(s) == 0: return 'Input is an empty string' return s[::-1] # Test the function print(reverse_string('hello')) # Output: 'olleh' print(reverse_string('')) # Output: 'Input is an empty string' print(reverse_string(None)) # Output: 'Input cannot be None' ``` This function checks for None and empty string inputs and uses slicing to reverse the string efficiently.

Q: How do you perform a GROUP BY operation in SQL? Provide an example with aggregation functions.

The GROUP BY statement in SQL is used to arrange identical data into groups. This is often used with aggregate functions like COUNT(), SUM(), AVG(), MIN(), and MAX() to perform calculations on each group. Here’s how to use it effectively: Example: Suppose we have a table called `Sales` with the following schema: ```sql CREATE TABLE Sales ( id INT, product_name VARCHAR(50), quantity INT, sale_date DATE ); ``` Query: To find the total quantity sold for each product, you can use the following SQL query: ```sql SELECT product_name, SUM(quantity) AS total_quantity FROM Sales GROUP BY product_name; ``` Explanation: - `SELECT product_name`: This specifies that we want to group by the `product_name` column. - `SUM(quantity) AS total_quantity`: This calculates the total quantity sold for each product. - `GROUP BY product_name`: This groups the results by each unique product name. Output might look like: ``` | product_name | total_quantity | |--------------|----------------| | Apples | 150 | | Bananas | 200 | | Oranges | 100 | ``` Edge Cases: If the `Sales` table is empty, the result will be an empty set. If there are NULL values in `product_name`, they will be treated as one group. To handle NULLs, you can use: ```sql SELECT COALESCE(product_name, 'Unknown') AS product_name, SUM(quantity) AS total_quantity FROM Sales GROUP BY COALESCE(product_name, 'Unknown'); ``` This will replace NULL product names with 'Unknown'. Grouping is a powerful way to summarize data and is widely used in reporting and analytics.

Q: What is the difference between deep copy and shallow copy in Python? Provide code examples.

In Python, a shallow copy creates a new object but inserts references into it to the objects found in the original. In contrast, a deep copy creates a new object and recursively adds copies of nested objects found in the original. Below are examples of both: ```python import copy # Original list original_list = [[1, 2, 3], [4, 5, 6]] # Shallow copy shallow_copied_list = copy.copy(original_list) # Deep copy deep_copied_list = copy.deepcopy(original_list) # Modifying the original list original_list[0][0] = 'Changed' print('Original List:', original_list) # Output: [['Changed', 2, 3], [4, 5, 6]] print('Shallow Copied List:', shallow_copied_list) # Output: [['Changed', 2, 3], [4, 5, 6]] print('Deep Copied List:', deep_copied_list) # Output: [[1, 2, 3], [4, 5, 6]] ``` In this example, modifying the original list affects the shallow copy but not the deep copy.

Q: What type of hard-level coding questions can you solve using Python and SQL from FAANG companies?

One common hard-level question could involve integrating Python with SQL to manipulate data. For instance, consider a scenario where you need to retrieve the top 5 employees by salary using SQL and then process this in Python. You might write something like: ```sql SELECT employee_id, name, salary FROM employees ORDER BY salary DESC LIMIT 5; ``` Then, in Python, you could handle this data: ```python import sqlite3 # Connect to the database conn = sqlite3.connect('company.db') cursor = conn.cursor() # Execute the SQL query cursor.execute("SELECT employee_id, name, salary FROM employees ORDER BY salary DESC LIMIT 5;") results = cursor.fetchall() # Process the results for employee in results: print(f'Employee ID: {employee[0]}, Name: {employee[1]}, Salary: {employee[2]}') conn.close() ``` This showcases your ability to work with databases and handle data efficiently, which is crucial for roles at FAANG companies.

Question 1

How can you implement a binary search algorithm in Python? Provide an example.

Accepted Answer

A binary search algorithm efficiently finds a target value within a sorted array by repeatedly dividing the search interval in half. Below is an implementation in Python:

```python
def binary_search(arr, target):
    left, right = 0, len(arr) - 1
    while left <= right:
        mid = (left + right) // 2
        if arr[mid] == target:
            return mid  # Target found at index mid
        elif arr[mid] < target:
            left = mid + 1  # Target is in the right half
        else:
            right = mid - 1  # Target is in the left half
    return -1  # Target not found

# Example usage
sorted_array = [1, 2, 3, 4, 5, 6, 7, 8, 9]
target = 5
result = binary_search(sorted_array, target)
print('Element found at index:', result)  # Output: Element found at index: 4
```
This implementation runs in O(log n) time complexity, making it highly efficient for large datasets.

Question 2

How do you manipulate strings in Python? Write a function that reverses a string and handles edge cases like empty strings.

Accepted Answer

String manipulation is a fundamental skill in Python. You can use string slicing, concatenation, and various built-in methods to manipulate strings.

Here’s an implementation of a function that reverses a string while handling edge cases:

```python
def reverse_string(s):
    if s is None:
        return 'Input cannot be None'
    if len(s) == 0:
        return 'Input is an empty string'
    return s[::-1]

# Test the function
print(reverse_string('hello'))  # Output: 'olleh'
print(reverse_string(''))       # Output: 'Input is an empty string'
print(reverse_string(None))     # Output: 'Input cannot be None'
```

This function checks for None and empty string inputs and uses slicing to reverse the string efficiently.

Question 3

How do you perform a GROUP BY operation in SQL? Provide an example with aggregation functions.

Accepted Answer

The GROUP BY statement in SQL is used to arrange identical data into groups. This is often used with aggregate functions like COUNT(), SUM(), AVG(), MIN(), and MAX() to perform calculations on each group. Here’s how to use it effectively:

Example: Suppose we have a table called `Sales` with the following schema:
```sql
CREATE TABLE Sales (
    id INT,
    product_name VARCHAR(50),
    quantity INT,
    sale_date DATE
);
```

Query: To find the total quantity sold for each product, you can use the following SQL query:
```sql
SELECT product_name, SUM(quantity) AS total_quantity
FROM Sales
GROUP BY product_name;
```
Explanation:
- `SELECT product_name`: This specifies that we want to group by the `product_name` column.
- `SUM(quantity) AS total_quantity`: This calculates the total quantity sold for each product.
- `GROUP BY product_name`: This groups the results by each unique product name.

Output might look like:
```
| product_name | total_quantity |
|--------------|----------------|
| Apples       | 150            |
| Bananas      | 200            |
| Oranges      | 100            |
```

Edge Cases: If the `Sales` table is empty, the result will be an empty set. If there are NULL values in `product_name`, they will be treated as one group. To handle NULLs, you can use:
```sql
SELECT COALESCE(product_name, 'Unknown') AS product_name, SUM(quantity) AS total_quantity
FROM Sales
GROUP BY COALESCE(product_name, 'Unknown');
```

This will replace NULL product names with 'Unknown'. Grouping is a powerful way to summarize data and is widely used in reporting and analytics.

Question 4

What is the difference between deep copy and shallow copy in Python? Provide code examples.

Accepted Answer

In Python, a shallow copy creates a new object but inserts references into it to the objects found in the original. In contrast, a deep copy creates a new object and recursively adds copies of nested objects found in the original. Below are examples of both:

```python
import copy

# Original list
original_list = [[1, 2, 3], [4, 5, 6]]

# Shallow copy
shallow_copied_list = copy.copy(original_list)

# Deep copy
deep_copied_list = copy.deepcopy(original_list)

# Modifying the original list
original_list[0][0] = 'Changed'

print('Original List:', original_list)  # Output: [['Changed', 2, 3], [4, 5, 6]]
print('Shallow Copied List:', shallow_copied_list)  # Output: [['Changed', 2, 3], [4, 5, 6]]
print('Deep Copied List:', deep_copied_list)  # Output: [[1, 2, 3], [4, 5, 6]]
```
In this example, modifying the original list affects the shallow copy but not the deep copy.

Question 5

What type of hard-level coding questions can you solve using Python and SQL from FAANG companies?

Accepted Answer

One common hard-level question could involve integrating Python with SQL to manipulate data. For instance, consider a scenario where you need to retrieve the top 5 employees by salary using SQL and then process this in Python. You might write something like:

```sql
SELECT employee_id, name, salary
FROM employees
ORDER BY salary DESC
LIMIT 5;
```

Then, in Python, you could handle this data:

```python
import sqlite3

# Connect to the database
conn = sqlite3.connect('company.db')
cursor = conn.cursor()

# Execute the SQL query
cursor.execute("SELECT employee_id, name, salary FROM employees ORDER BY salary DESC LIMIT 5;")
results = cursor.fetchall()

# Process the results
for employee in results:
    print(f'Employee ID: {employee[0]}, Name: {employee[1]}, Salary: {employee[2]}')

conn.close()
```

This showcases your ability to work with databases and handle data efficiently, which is crucial for roles at FAANG companies.

SarthiQ

Interview Preparation Guide

Deloitte
Questions & Answers

Document Details

Need Help?

Top Deloitte Interview Questions

Deloitte Interview Questions

A Software Engineer was asked

A Software Engineer was asked

Software Engineer

Software Engineer

Interview Preparation Guide

DeloitteQuestions & Answers

Document Details

Need Help?

Top Deloitte Interview Questions

Deloitte Interview Questions

A Software Engineer was asked

A Software Engineer was asked

Software Engineer

Software Engineer

Deloitte
Questions & Answers