PYTHON CODING QUESTIONS
1. Prime Number
num = 7
is_prime = True
for i in range(2, num):
if num % i == 0:
is_prime = False
break
if is_prime:
print("Prime")
else:
print("Not Prime")
2. Palindrome
text = "madam"
if text == text[::-1]:
print("Palindrome")
else:
print("Not Palindrome")
3. Factorial
num = 5
factorial = 1
for i in range(1, num + 1):
factorial *= i
print(factorial)
4. Fibonacci Series
a, b = 0, 1
for i in range(10):
print(a)
a, b = b, a + b
5. Reverse String
text = "python"
print(text[::-1])
Alternative:
text = "python"
reverse = ""
for char in text:
reverse = char + reverse
print(reverse)
6. Largest Number in List
numbers = [10, 45, 22, 89, 5]
print(max(numbers))
Manual:
numbers = [10, 45, 22, 89, 5]
largest = numbers[0]
for num in numbers:
if num > largest:
largest = num
print(largest)
7. Count Vowels
text = "data analyst"
count = 0
for char in [Link]():
if char in "aeiou":
count += 1
print(count)
8. List Operations
Add Element
numbers = [1, 2, 3]
[Link](4)
print(numbers)
Remove Element
numbers = [1, 2, 3]
[Link](2)
print(numbers)
Length
numbers = [1, 2, 3]
print(len(numbers))
9. Dictionary Basics
student = {
"name": "Suresh",
"marks": 85
}
print(student["name"])
print(student["marks"])
Add New Key:
student["city"] = "Bangalore"
print(student)
10. Anagram
str1 = "listen"
str2 = "silent"
if sorted(str1) == sorted(str2):
print("Anagram")
else:
print("Not Anagram")
SQL QUESTIONS
Assume Table:
employees
(id, name, salary, department)
1. Second Highest Salary
SELECT MAX(salary)
FROM employees
WHERE salary < (
SELECT MAX(salary)
FROM employees
);
2. Duplicate Records
SELECT name,
COUNT(*)
FROM employees
GROUP BY name
HAVING COUNT(*) > 1;
3. INNER JOIN
SELECT [Link],
d.department_name
FROM employees e
INNER JOIN departments d
ON e.department_id = d.department_id;
LEFT JOIN
SELECT [Link],
d.department_name
FROM employees e
LEFT JOIN departments d
ON e.department_id = d.department_id;
4. GROUP BY
SELECT department,
COUNT(*)
FROM employees
GROUP BY department;
5. HAVING
SELECT department,
COUNT(*)
FROM employees
GROUP BY department
HAVING COUNT(*) > 5;
6. Average Salary
SELECT AVG(salary)
FROM employees;
7. Department Count
SELECT department,
COUNT(*) AS employee_count
FROM employees
GROUP BY department;
8. Top N Salaries
Top 3 Salaries
SELECT *
FROM employees
ORDER BY salary DESC
LIMIT 3;
9. NULL Values
Find NULL Values
SELECT *
FROM employees
WHERE salary IS NULL;
Find Non-NULL Values
SELECT *
FROM employees
WHERE salary IS NOT NULL;
10. LIKE Operator
Starts With S
SELECT *
FROM employees
WHERE name LIKE 'S%';
Ends With A
SELECT *
FROM employees
WHERE name LIKE '%A';
Contains "an"
SELECT *
FROM employees
WHERE name LIKE '%an%';
LAST-MINUTE MUST REMEMBER
Python
✅ Prime Number
✅ Palindrome
✅ Factorial
✅ Fibonacci
✅ Reverse String
✅ Largest Number
✅ Count Vowels
✅ Dictionary
✅ Anagram
SQL
✅ Second Highest Salary
✅ Duplicate Records
✅ INNER JOIN
✅ LEFT JOIN
✅ GROUP BY
✅ HAVING
✅ AVG()
✅ COUNT()
✅ NULL Values
✅ LIKE Operator
If you can write these without looking, you'll be in a strong position for tomorrow's written
test. 🚀💪
Excellent. These are exactly the types of questions that can appear in written tests.
PYTHON CODING – NEXT 15
QUESTIONS
1. Sum of Digits
num = 1234
sum = 0
while num > 0:
sum += num % 10
num //= 10
print(sum)
2. Check Armstrong Number
num = 153
temp = num
sum = 0
while temp > 0:
digit = temp % 10
sum += digit ** 3
temp //= 10
if sum == num:
print("Armstrong")
3. Count Digits
num = 12345
count = 0
while num > 0:
count += 1
num //= 10
print(count)
4. Find Minimum Number in List
numbers = [10,5,30,2]
print(min(numbers))
5. Find Maximum and Minimum Together
numbers = [10,5,30,2]
print(max(numbers))
print(min(numbers))
6. Check Leap Year
year = 2024
if (year % 4 == 0 and year % 100 != 0) or year % 400 == 0:
print("Leap Year")
7. Multiplication Table
num = 5
for i in range(1,11):
print(num * i)
8. Count Words in String
text = "Data Analyst Interview"
words = [Link]()
print(len(words))
9. Find Largest of Three Numbers
a,b,c = 10,25,15
print(max(a,b,c))
10. Sort List
numbers = [5,2,8,1]
[Link]()
print(numbers)
11. Find Common Elements
a = [1,2,3,4]
b = [3,4,5,6]
for i in a:
if i in b:
print(i)
12. Count Frequency of Element
numbers = [1,2,2,3,2]
print([Link](2))
13. Check String Anagram
a = "listen"
b = "silent"
if sorted(a) == sorted(b):
print("Anagram")
14. Find Second Largest Number
numbers = [10,50,20,40]
[Link]()
print(numbers[-2])
15. Remove Spaces from String
text = "data analyst"
print([Link](" ",""))
SQL QUERY – NEXT 15 QUESTIONS
Assume table:
employees
(id,name,salary,department)
1. Display All Employees
SELECT * FROM employees;
2. Display Employee Names Only
SELECT name
FROM employees;
3. Employees Salary Greater Than 50000
SELECT *
FROM employees
WHERE salary > 50000;
4. Employees From IT Department
SELECT *
FROM employees
WHERE department='IT';
5. Sort Salary Descending
SELECT *
FROM employees
ORDER BY salary DESC;
6. Top 5 Highest Salaries
SELECT *
FROM employees
ORDER BY salary DESC
LIMIT 5;
7. Count Employees
SELECT COUNT(*)
FROM employees;
8. Average Salary
SELECT AVG(salary)
FROM employees;
9. Highest Salary
SELECT MAX(salary)
FROM employees;
10. Lowest Salary
SELECT MIN(salary)
FROM employees;
11. Total Salary Department Wise
SELECT department,
SUM(salary)
FROM employees
GROUP BY department;
12. Average Salary Department Wise
SELECT department,
AVG(salary)
FROM employees
GROUP BY department;
13. Employee Names Starting With S
SELECT *
FROM employees
WHERE name LIKE 'S%';
14. Employee Names Ending With A
SELECT *
FROM employees
WHERE name LIKE '%a';
15. Employees Between Salary Range
SELECT *
FROM employees
WHERE salary BETWEEN 30000 AND 60000;
MOST LIKELY WRITTEN TEST QUESTIONS TOMORROW
Python
1. Prime Number
2. Palindrome
3. Factorial
4. Fibonacci
5. Reverse String
6. Largest Number
7. Count Vowels
8. List Operations
9. Dictionary Basics
10. Anagram
SQL
1. Second Highest Salary
2. Duplicate Records
3. Joins
4. GROUP BY
5. HAVING
6. Average Salary
7. Department Count
8. Top N Salaries
9. NULL Values
10. LIKE Operator
If you master these 30 additional questions + the document, you'll be very well prepared
for a fresher written test and technical interview tomorrow. 💪🔥