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
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
