Topic 4: Structured Query Language (SQL)

Define the type of SQL that used to insert, delete and retrieve data within the database tables.

• Data Control Language (DCL)

• Data Definition Language (DDL)

• Data Manipulation Language (DML)

• Transaction Control Language (TCL)

List the Data Definition Language (DDL) command.

• CREATE, USE ALTER, DROP

• CREATE, USE, INSERT, DELETE

• INSERT, UPDATE, DELETE, SELECT

• INSERT, UPDATE, DROP, SELECT

Differentiate between DELETE and DROP command.

• DELETE is DDL command while DROP is DML command

• DELETE cannot use with WHERE clause while DROP can use with WHERE clause

• DELETE is used to remove a table from the database while DROP cannot remove a table from the database

• DELETE is used to remove a record of a table while DROP is used to remove a structure and records of a table

Identify the SQL command use to add price column into PRODUCT table.

• ALTER TABLE PRODUCT

  ADD price decimal (6,2);

• ALTER TABLE PRODUCT

  ADD COLUMN price decimal (6,2)

• ALTER TABLE PRODUCT

  MODIFY COLUMN price decimal (6,2)

• ALTER TABLE PRODUCT

  MODIFY price decimal (6,2)

Choose SQL command to display the name of cake that end with word cheese.

• SELECT cakeName

  FROM CAKE

  WHERE cakeName LIKE "%cheese";

• SELECT cakeName

  FROM CAKE

  WHERE cakeName LIKE "cheese%";

• SELECT cakeName

  FROM CAKE

  WHERE cakeName LIKE "%cheese%";

• SELECT cakeName

  FROM CAKE

  WHERE cakeName LIKE "cheese";

Select SQL command to insert values in COURSE table.

• INSERT COURSE VALUES("DFC20203", "Database Design");

• INSERT VALUES INTO COURSE ("DFC20203", "Database Design");

• INSERT COURSE VALUES ("DFC20203", "Database Design") INTO COURSE;

• INSERT INTO COURSE VALUES ("DFC20203", "Database Design");

Choose the CORRECT query for using comparison operators in SQL.

• SELECT eName, ePosition

  FROM employeeInfo

  WHERE age>40 AND <60;

• SELECT eName, ePosition

  FROM employeeInfo

  WHERE age>40 AND age<60;

• SELECT eName, ePosition

  FROM employeeInfo

  WHERE age>40 AND WHERE age<60;

• SELECT eName, ePosition

  FROM employeeInfo

  WHERE >40 AND <60 age;

Based on the statement in Figure 1, choose the SQL command to update Aiman's position in EMPLOYEE table.

• ALTER EMPLOYEE

  SET position ="Assistant Engineer to Executive Engineer"

  WHERE employee_id = "F2001";

• UPDATE EMPLOYEE

  SET position = "Executive Engineer"

  WHERE employee_id = "F2001";

• ALTER EMPLOYEE

  SET position ="Executive Engineer"

  WHERE employee_id = "F2001";

• UPDATE EMPLOYEE

  SET position ="Assistant Engineer to Executive Engineer"

  WHERE employee_id = "F2001";

Based on Figure A4, identify the number of column that will be shown in the output.

• 2

• 3

• 4

• 5

Based on Figure A10, predict the line that has an error in the SQL command.

• Line 1

• Line 2

• Line 3

• Line 4