Oracle
1Z0-061 · Question #221
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…
The correct answer is C. The data in the EMPLOYEES table is deleted but not the structure. You can remove existing rows from a table by using the DELETE statement. DELETE [FROM] table [WHERE. condition];
Manipulating Data
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;
Options
- AYou get an error because of a primary key violation.
- BThe data and structure of the EMPLOYEES table are deleted.
- CThe data in the EMPLOYEES table is deleted but not the structure.
- DYou get an error because the statement is not syntactically correct.
How the community answered
(36 responses)- A11% (4)
- B3% (1)
- C81% (29)
- D6% (2)
Explanation
You can remove existing rows from a table by using the DELETE statement. DELETE [FROM] table [WHERE. condition];
Topics
#DELETE statement#table structure#DML#data removal
Community Discussion
No community discussion yet for this question.