Chapter 3 : SQL Command

Which SQL command correctly creates the ConferenceRoom table?

• MAKE TABLE ConferenceRoom (room_id INT, room_name VARCHAR(100), capacity INT);

• CREATE ConferenceRoom TABLE (room_id INT, room_name VARCHAR(100), capacity INT);

• CREATE TABLE ConferenceRoom (

  room_id INT PRIMARY KEY,

  room_name VARCHAR(100),

  capacity INT

  );

• TABLE CREATE ConferenceRoom (room_id INT, room_name VARCHAR(100), capacity INT);

Which command inserts a record into Employee?

• INSERT Employee (1, 'Alice Tan', 'IT');

• INSERT INTO Employee VALUES (1, 'Alice Tan', 'IT');

• INSERT INTO Employee (emp_id, emp_name, department) VALUES 'Alice Tan', 1, 'IT';

• ADD INTO Employee VALUES (1, 'Alice Tan', 'IT');

Which query changes Workshop with workshop_id = 2 to title "Leadership Skills"?

• UPDATE Workshop workshop_title = 'Leadership Skills' workshop_id = 2;

• CHANGE Workshop SET workshop_title = 'Leadership Skills' WHERE workshop_id = 2;

• UPDATE Workshop SET 'Leadership Skills' WHERE workshop_id = 2;

• UPDATE Workshop

  SET workshop_title = 'Leadership Skills'

  WHERE workshop_id = 2;

Shows all employees from HR department?

• SELECT * FROM Employee department = 'HR';

• SELECT *

  FROM Employee

  WHERE department = 'HR';

• SELECT emp_name FROM Employee HAVING department = 'HR';

• SELECT emp_name FROM Employee GROUP BY department = 'HR';

shows Workshop title and ConferenceRoom name?

• SELECT workshop_title, room_name FROM Workshop INNER ConferenceRoom;

• SELECT w.workshop_title, c.room_name

  FROM Workshop w

  JOIN ConferenceRoom c ON w.room_id = c.room_id;

• SELECT workshop_title, room_name WHERE w.room_id = c.room_id;

• SELECT w.workshop_title, c.room_name FROM Workshop w, ConferenceRoom c;

shows employee name, workshop title, and fee paid?

• SELECT e.emp_name, w.workshop_title, r.fee

  FROM Registration r

  JOIN Employee e ON r.emp_id = e.emp_id

  JOIN Workshop w ON r.workshop_id = w.workshop_id;

• SELECT e.emp_name, w.workshop_title, w.fee FROM Employee, Workshop, Registration;

• SELECT e.emp_name, w.workshop_title, r.fee JOIN Employee e, Workshop w;

• SELECT emp_name, workshop_title, fee FROM Registration NATURAL JOIN Employee;

finds the highest fee paid?

• SELECT fee FROM Registration MAX();

• SELECT MAXIMUM(fee) FROM Registration;

• SELECT MAX(fee) AS max_fee FROM Registration;

• SELECT MAX fee FROM Registration;

finds the smallest fee paid?

• SELECT fee MIN FROM Registration;

• SELECT MIN(fee) FROM Registration;

• SELECT MINIMUM fee FROM Registration;

• SELECT fee FROM Registration WHERE MIN;

calculates the total fee collected?

• SELECT ADD(fee) FROM Registration;

• SELECT SUM(fee) FROM Registration;

• SELECT fee SUM FROM Registration;

• SUM(fee) SELECT FROM Registration;

counts total registrations?

• SELECT COUNT(*) FROM Registration;

• SELECT COUNT(ALL) Registration;

• SELECT COUNT Registration;

• COUNT(*) FROM Registration;