SQL Commands Quiz

The SQL command to delete a table is ..

• ALTER

• DELETE

• CREATE

• DROP

The command to change the structure of a table is ...

• ALTER

• DELETE

• CREATE

• DROP

Below are command that do not include DDL commands ...

• ALTER

• DELETE

• CREATE

• DROP

The command for manipulating data in the database is ...

• DCL

• DML

• SQL

• DDL

The command to define the database structure is ...

• DCL

• DML

• SQL

• DDL

The TRUNCATE command is used to ...

• create a table

• delete some records from a table

• remove all rows from a table

• delete fields from a table

The following is a SQL command to change the data type from EmployeeName column to varchar2 (30) ...

• UPDATE Table Employees SET EmployeeName varchar2(30);

• ALTER TABLE Employees UPDATE EmployeeName varchar2(30);

• ALTER TABLE Employees MODIFY EmployeeName varchar2(30);

• MODIFY Table Employees SET EmployeeName varchar2(30);

Below is a correct SQL statement for changing data or records ...

• UPDATE Table Employees SET EmployeeName varchar2(30);

• UPDATE Employees SET EmployeeName = Fatih;

• MODIFY Table Employees SET EmployeeAddress = "Broadway 114";

• UPDATE Employees SET EmployeeCity = "Bandung";

SQL commands that are appropriate for adding a foreign key to a table is ...

• ALTER TABLE Employees ADD CONSTRAINTS FK_Job_id FOREIGN KEY (Job_id) REFERENCES JOBS(Job_id);

• ALTER TABLE Employees ADD CONSTRAINT FK_Job_id FOREIGN KEY (Job_id) REFERENCES JOBS(Job_id);

• ALTER TABLE Employees ADD CONSTRAINTS FK_Job_id REFERENCES JOBS(Job_id) FOREIGN KEY (Job_id);

• ALTER TABLE Employees ADD CONSTRAINT FK_Job_id REFERENCES JOBS(Job_id) FOREIGN KEY (Job_id);

SQL stands for ...

• Standard Query Language

• Structured Query Language

• Structured Question Language

• None of the answers is correct