Home » Oracle » 1z0-061 » 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;
A. You get an error because of a primary key violation.
B. The data and structure of the EMPLOYEES table are deleted.
C. The data in the EMPLOYEES table is deleted but not the structure.
D. You get an error because the statement is not syntactically correct.
Correct Answer: C
Explanation/Reference:
Explanation: . You can remove existing rows from a table by using the DELETE statement.
DELETE [FROM] table
[WHERE. condition];
Incorrect answer:
A. Statement will not cause error
B. Delete statement will not delete the table structure
D. Statement will not cause error
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 8-19
Download Printable PDF. VALID exam to help you PASS.
|
|
its option D.
the correct syntax is delete from employees;
you can delete everything from table using both methods:
DELETE FROM employees;
DELETE employees;
So correct answer is C of course
Vovchik is right, it’s definitely C.