Skills101
← SQL & DBMS — Intermediate

SQL & DBMS Intermediate — Test 1

15 questions19 minPass: 60%+30 XP on first passFree sample test

15 questions · 19 minutes · intermediate level, with an explanation for every answer.

Log in to take the quiz

Free account · see your score, answers and explanations, earn XP

  1. Question 1

    A table is in 2NF but has the dependency roll_no → dept_id → dept_name. Which normal form does it break?

  2. Question 2

    What is the output of this SQL query?

    -- employees(id, name, dept, salary, manager_id)
    -- 1 Asha  IT    70000 NULL | 2 Ravi  IT 50000 1 | 3 Neha  HR    45000 NULL
    -- 4 Karan Sales 40000 3    | 5 Meera Sales 55000 3 | 6 Imran IT 50000 1
    -- departments(dept, city): IT Jaipur | HR Pune | Sales Delhi | Admin Noida
    SELECT name FROM employees WHERE salary > (SELECT AVG(salary) FROM employees) ORDER BY name;
    
  3. Question 3

    Which key can be chosen as the primary key?

  4. Question 4

    What is the output of this SQL query?

    -- employees(id, name, dept, salary, manager_id)
    -- 1 Asha  IT    70000 NULL | 2 Ravi  IT 50000 1 | 3 Neha  HR    45000 NULL
    -- 4 Karan Sales 40000 3    | 5 Meera Sales 55000 3 | 6 Imran IT 50000 1
    -- departments(dept, city): IT Jaipur | HR Pune | Sales Delhi | Admin Noida
    SELECT d.dept, COUNT(e.id) FROM departments d LEFT JOIN employees e ON e.dept = d.dept GROUP BY d.dept ORDER BY d.dept;
    
  5. Question 5

    Which is true about a VIEW?

  6. Question 6

    What is the output of this SQL query?

    -- employees(id, name, dept, salary, manager_id)
    -- 1 Asha  IT    70000 NULL | 2 Ravi  IT 50000 1 | 3 Neha  HR    45000 NULL
    -- 4 Karan Sales 40000 3    | 5 Meera Sales 55000 3 | 6 Imran IT 50000 1
    -- departments(dept, city): IT Jaipur | HR Pune | Sales Delhi | Admin Noida
    SELECT name FROM employees e WHERE NOT EXISTS (SELECT 1 FROM employees x WHERE x.manager_id = e.id) ORDER BY id;
    
  7. Question 7

    What is the output of this SQL query?

    -- employees(id, name, dept, salary, manager_id)
    -- 1 Asha  IT    70000 NULL | 2 Ravi  IT 50000 1 | 3 Neha  HR    45000 NULL
    -- 4 Karan Sales 40000 3    | 5 Meera Sales 55000 3 | 6 Imran IT 50000 1
    -- departments(dept, city): IT Jaipur | HR Pune | Sales Delhi | Admin Noida
    SELECT dept, COUNT(*), SUM(salary) FROM employees GROUP BY dept ORDER BY dept;
    
  8. Question 8

    What is the output of this SQL query?

    -- employees(id, name, dept, salary, manager_id)
    -- 1 Asha  IT    70000 NULL | 2 Ravi  IT 50000 1 | 3 Neha  HR    45000 NULL
    -- 4 Karan Sales 40000 3    | 5 Meera Sales 55000 3 | 6 Imran IT 50000 1
    -- departments(dept, city): IT Jaipur | HR Pune | Sales Delhi | Admin Noida
    SELECT name, CASE WHEN salary >= 55000 THEN 'High' WHEN salary >= 45000 THEN 'Mid' ELSE 'Low' END FROM employees WHERE dept <> 'IT' ORDER BY id;
    
  9. Question 9

    What is the output of this SQL query?

    -- employees(id, name, dept, salary, manager_id)
    -- 1 Asha  IT    70000 NULL | 2 Ravi  IT 50000 1 | 3 Neha  HR    45000 NULL
    -- 4 Karan Sales 40000 3    | 5 Meera Sales 55000 3 | 6 Imran IT 50000 1
    -- departments(dept, city): IT Jaipur | HR Pune | Sales Delhi | Admin Noida
    SELECT e.name, d.city FROM employees e JOIN departments d ON e.dept = d.dept WHERE d.city = 'Delhi' ORDER BY e.name;
    
  10. Question 10

    What is the output of this SQL query?

    -- employees(id, name, dept, salary, manager_id)
    -- 1 Asha  IT    70000 NULL | 2 Ravi  IT 50000 1 | 3 Neha  HR    45000 NULL
    -- 4 Karan Sales 40000 3    | 5 Meera Sales 55000 3 | 6 Imran IT 50000 1
    -- departments(dept, city): IT Jaipur | HR Pune | Sales Delhi | Admin Noida
    SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);
    
  11. Question 11

    What is the output of this SQL query?

    -- employees(id, name, dept, salary, manager_id)
    -- 1 Asha  IT    70000 NULL | 2 Ravi  IT 50000 1 | 3 Neha  HR    45000 NULL
    -- 4 Karan Sales 40000 3    | 5 Meera Sales 55000 3 | 6 Imran IT 50000 1
    -- departments(dept, city): IT Jaipur | HR Pune | Sales Delhi | Admin Noida
    SELECT e.name, m.name FROM employees e JOIN employees m ON e.manager_id = m.id ORDER BY e.id;
    
  12. Question 12

    What is the output of this SQL query?

    -- employees(id, name, dept, salary, manager_id)
    -- 1 Asha  IT    70000 NULL | 2 Ravi  IT 50000 1 | 3 Neha  HR    45000 NULL
    -- 4 Karan Sales 40000 3    | 5 Meera Sales 55000 3 | 6 Imran IT 50000 1
    -- departments(dept, city): IT Jaipur | HR Pune | Sales Delhi | Admin Noida
    SELECT salary, COUNT(*) FROM employees GROUP BY salary HAVING COUNT(*) > 1;
    
  13. Question 13

    What is the difference between INNER JOIN and LEFT JOIN?

  14. Question 14

    In an ER diagram, what does a diamond represent?

  15. Question 15

    What is the output of this SQL query?

    -- employees(id, name, dept, salary, manager_id)
    -- 1 Asha  IT    70000 NULL | 2 Ravi  IT 50000 1 | 3 Neha  HR    45000 NULL
    -- 4 Karan Sales 40000 3    | 5 Meera Sales 55000 3 | 6 Imran IT 50000 1
    -- departments(dept, city): IT Jaipur | HR Pune | Sales Delhi | Admin Noida
    SELECT dept FROM employees GROUP BY dept HAVING AVG(salary) > 50000;
    
🎯 Today’s placement challenge — 10 questions, no login. Can you score 10/10?Take today’s challenge →