SQL POST-ASSESSMENT

What is PRIMARY KEY?

• Unique Identifier

• A field existing in another table

• Key for creating table

• Key for creating database

It is the size of each field/record individually.

• DataType

• Integer

• Total

• Data Size

If the primary key is auto incremented, there is no need to include it for inserting records since it will be automatically generated as auto increment for each record.

• TRUE

• FALSE

It is a clause that is use to set condition in what to select, update or delete.

• SET

• ALL

• WHERE

• LIKE

SELECT * FROM tbl_students WHERE stud_lastname = 'Punzalan';

• CORRECT

• INCORRECT

UPDATE tbl_students SET stud_lastname = 'Punzalan' WHERE stud_id = 1;

• CORRECT

• INCORRECT

DELETE * FROM tbl_students WHERE stud_id = 1;

• CORRECT

• INCORRECT

Command use to retrieve record in a table

Command use to update record in a table

Command use to delete record in a table