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]; Incorrect answer: A Statement will not cause error B Delete statement will not delete the table structure D Statement will not cause error

Manipulating Data (DML)

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

(34 responses)

A
3% (1)
B
12% (4)
C
79% (27)
D
6% (2)

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

Topics

#DELETE without WHERE#DML#table data removal#table structure

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice