Question: Examine this command: TRUNCATE TABLE test; Table truncated. Which two are true? ( Choose two. ) a . The structure of the TEST table is

Examine this command:
TRUNCATE TABLE test;
Table truncated.
Which two are true? (Choose two.)
a. The structure of the TEST table is removed.
b. All the indexes on the TEST table are dropped.
c. All the constraints on the TEST table are dropped.
d. Removed rows can not be recovered using the ROLLBACK command.
e. All the rows in the TEST table are removed.
You issued this command:
DROP TABLE hr employep;
Which three statements are true? (Choose three.)
A. Sequences used to populate columns in the HR FMPIOYFES table are dropped.
B. Synonyms for HR FMPIOYFFS are dropped.
C. Views referencing HR FMPIOYFFS are dropped.
D. All constraints defined on HR FMPIOYFFC are dropped.
E. The HR FMPIOYFFS table may be moved to the recycle bin.
F. All indexes defined on HR FMPIOYFFS are dropped
Examine this command: TRUNCATE TABLE test; Table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!