ITDB202 - SQL DDL, DML and TCL Statements

Which of the following allows you to add Address column with string value up to 50 characters in your EMP table?

• ALTER TABLE emp ADD address VARCHAR2(50);

• ALTER TABLE emp ADD COLUMN address VARCHAR2(50);

• ALTER TABLE emp ADD address VARCHAR2(30);

• ALTER TABLE emp DROP COLUMN address;

Which is an example of Data Manipulation Language (DML) command?

• CREATE

• INSERT

• ALTER

• DROP

Which is an example of Data Definition Language (DDL) command?

• INSERT

• DELETE

• CREATE

• UPDATE

Which of the following will display all the records in EMPLOYEES table?

• SELECT salary FROM employees;

• SELECT * FROM employees;

• SELECT ALL FROM employees;

Which command will delete your table from the database?

• DROP

• DELETE

• TRUNCATE

• MERGE

Which data type should you use for the BIRTHDAY column in STUDENTS table?

• CHAR

• VARCHAR2

• DATE

• NUMBER

Which command will execute properly?

• INSERT INTO emp (101, 'Melissa', 300);

• INSERT INTO emp VALUES (101, Melissa, 300);

• INSERT INTO emp VALUES (101, 'Melissa', 300);

• INSERT INTO emp VALUES ('101', Melissa, '300');

Which command will execute correctly?

• CREATE TABLE emp (ID Number(5), Name Varchar2(25));

• CREATE TABLE emp (ID Number(5), Name Varchar(25));

• CREATE TABLE emp ID Number(5), Name Varchar2(25);

• CREATE TABLE emp (ID Number(5), Name Varchar);

If you did not include a WHERE clause in your UPDATE table command, what will happen to the records?

• All records will be updated.

• Only specific record will be updated.

• None of the records will be updated.

The following statements were executed in sequence:

DELETE FROM employees;

SELECT * FROM employees;

What will happen after you execute the given SELECT statement?

• All records will be displayed.

• No records will be displayed.

• An error message will be displayed.

• Table does not exist.