DAY 18 - MySQL Commands: DDL, DML, TCL (Query Related)- 3rd July

Which query creates a new table named 'Students' with columns 'id', 'name' & 'age' ?

• CREATE TABLE students (id INT, name

  VARCHAR(100), age INT);

• NEW TABLE students (id INT, name VARCHAR(100),

  age INT);

• MAKE TABLE students (id INT, name

  VARCHAR(100), age INT);

• BUILD TABLE students (id INT, name

  VARCHAR(100), age INT);

Which query inserts a new record into the 'students' table

with 'id' as 1, 'name' as 'John' and 'age' as 20?

• INSERT INTO students VALUES (1, 'John' , 20);

• ADD INTO students (1, 'John' , 20);

• NEW ENTRY students VALUES (1, 'John' , 20);

• INSERT VALUES INTO students (1, 'John' , 20);

Which query updates the 'age' of the student with 'id' 1 to

21 in the 'students' table?

• UPDATE students SET age = 21 WHERE id = 1;

• MODIFY students SET age = 21 WHERE id = 1;

• CHANGE students SET age = 21 WHERE id = 1;

• ALTER students SET age = 21 WHERE id = 1;

Which query deletes the student record with 'id' 1 from

the 'students' table?

• REMOVE FROM students WHERE id = 1;

• DELETE FROM students WHERE id = 1;

• ERASE FROM students WHERE id = 1;

• DROP FROM students WHERE id = 1;

Which query retrieves all records from the 'students'

table?

• GET * FROM students;

• FETCH * FROM students;

• SELECT * FROM students;

• RETRIEVE * FROM students;

Which query adds a new column 'email' to the 'students'

table?

• ADD COLUMN email TO students VARCHAR(100);

• ALTER TABLE students ADD COLUMN email

  VARCHAR(100);

• UPDATE TABLE students ADD email

  VARCHAR(100);

• MODIFY TABLE students ADD email

  VARCHAR(100);

Which query renames the 'students' table to 'pupils' ?

• RENAME TABLE students TO pupils;

• ALTER TABLE students RENAME TO pupils;

• UPDATE TABLE students RENAME TO pupils;

• MODIFY TABLE students TO pupils;

Which query commits the current transaction?

• SAVE;

• COMMIT;

• EXECUTE;

• APPLY;

Which query undoes all changes made in the current

transaction?

• UNDO;

• ROLLBACK;

• CANCEL;

• REVERT;

Which query removes all records from the 'students'

table but does not delete the table itself?

• DELETE FROM students;

• TRUNCATE TABLE students;

• CLEAR TABLE students;

• REMOVE FROM students;