What happens when you execute this DELETE statement?

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;

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.
The data in the EMPLOYEES table is deleted but not the structure.

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

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

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



Leave a Reply 0

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