What happens when you execute this DELETE statement?

Previous Question
Next Question

You own a table called EMPLOYEES with this table structure:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
HIRE_DATE DATE
What happens when you execute this DELETE statement?

DELETE employees;

A.
You get an error because of a primary key violation.

B.
The data and structure of the EMPLOYEES table are deleted.

C.
You get an error because the statement is not syntactically correct.

D.
The data in the EMPLOYEES table is deleted but not the structure.

Explanation:

: You can remove existing rows from a table by using the DELETE statement.
DELETE [FROM] table
[WHERE condition];

Previous Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *