Digital Technologies – SS2 – Introduction to Database Management System (DBMS) II – Questions with Answers and Explanations

Which statement correctly inserts a new class into Classes (ClassID, ClassName, FormTeacher)?

A. INSERT INTO Classes (ClassID, ClassName, FormTeacher) VALUES (4, SS2 Ruby, Mr. Obi);
B. INSERT INTO Classes (ClassID, ClassName, FormTeacher) VALUES (4, 'SS2 Ruby');
C. INSERT INTO Classes (ClassID, ClassName, FormTeacher) VALUES (4, 'SS2 Ruby', 'Mr. Obi');
D. INSERT Classes VALUES FROM (4, 'SS2 Ruby', 'Mr. Obi');

A field whose value is unique for every record and is never empty is called a

A. foreign key
B. primary key
C. data type
D. attribute

Which SQL command is used to retrieve data from a table?

A. UPDATE
B. DELETE
C. SELECT
D. INSERT INTO