G10 Structured Query Language

Look at the table named "Employeelist"

Which SQL statement exactly represents in selecting all FIELDS where the Department = 'Engineering'

• SELECT * FROM Employeelist WHERE Department = 'Engineering'

• SELECT * FROM Employeelist WHEN Department = 'Engineering'

• SELECT ^^ FROM Employeelist WHICH Department = 'Engineering'

• SELECT ++ FROM Employeelist WHILE Department = 'Engineering'

Look at the table named "Employeelist"

Which SQL statement exactly represents in selecting 'Name' where the Age is lesser than or equal '30'

• SELECT Employeelist.Name FROM Employeelist WHERE Age <= '30'

• SELECT Employeelist.[Name] FROM Employeelist WHERE Age <= '30'

• SELECT Employeelist.Name FROM Employee_list WHERE Age =< '30'

• SELECT Employeelist.Name FROM Employeelist WHERE Age <= '30'

In creating a table named "Students2024".

Can you identify which is missing or error in the statement below:

CREATE Students2024(Employee_ID INTEGER, LASTNAME TEXT (50), FIRSTNAME TEXT (50))

• TABLE

• comma (s)

• spelling error

• No error

Look at the image and create a table named "Students2024" with the parameters as shown.

• CREATE TABLE Students2024(

  Employee_ID INTEGER; LASTNAME TEXT (50); FIRSTNAME TEXT (50))

• CREATE TABLE Students2024(

  Employee_ID INTEGER, LASTNAME TEXT (50), FIRSTNAME TEXT (50))

• CREATE Students2024(

  Employee_ID INTEGER, LASTNAME TEXT (50), FIRSTNAME TEXT (50))

• CREATE TABLE Students2024(

  Employee_ID INTEGER, LASTNAME WORD (50), FIRSTNAME WORD (50))

Which statement is true to delete the table "Employee_list_V1" from the database.

• DEL TABLE Employee_list_V1

• DROP TABLE Employee_list_V1

• DELETE Employee_list_V1

• DROP_TABLE "Employee_list_V1"

Which statement is true to delete the table "Employee_list_V1" from the database.

Look at the image and Identify if there is an error in the SQL statement.

• ( )

• ;

• spelling error

• No errors

• [ ]

Identify if there is an error in the SQL statement below:

INSERT INTO Employee_details(Emp_number; Lastname; Firstname; Gender; Date_joined; Department; Salary)

VALUES ('C00007', 'THANH', 'QUYNH', 'F', '4/3/2024', 'Management','2800');

• ( )

• ;

• spelling error

• No errors

• [ ]

Answer explanation

INSERT INTO Employee_details

(Emp_number, Lastname, Firstname, Gender, Date_joined, Department; Salary)

VALUES

('C00007', 'THANH', 'QUYNH', 'F', '4/3/2024', 'Management','2800');

Identify if there is an error in the SQL UPDATE statement below:

UPDATE Employee_details

SET Employee_details.Lastname = 'THANTRA', Employee_details.Salary = '3600'

WHERE Employee_details.ID =8;

• ( )

• ;

• spelling error

• No errors

• [ ]

Answer explanation

No errors

Identify if there is an error in the SQL UPDATE statement below:

UPDATE Employee_details

SHOW Employee_details.Lastname = 'THANTRA', Employee_details.Salary = '3600'

WHERE Employee_details.ID =8;

• ( )

• ;

• spelling error

• No errors

• Show

Answer explanation

UPDATE Employee_details

SET Employee_details.Lastname = 'THANTRA', Employee_details.Salary = '3600'

WHERE Employee_details.ID =8;