What Is The Difference Between TRUNCATE, DELETE, DROP?

⟩ what is the difference between TRUNCATE, DELETE, DROP?

1) Drop will drop the records from the table along with its structure.All the indexes associated with it will also deleted and there is no rollback.

2) Delete will deletes the records of the table but the structure of the table is retained back.It is a DML operation which is slower but provides rollback facility.

3) Truncate is a DDL command which is faster ,retain structure of the table and rollback is possible.It allocates memory usually after truncating so structure is retained.

Is this answer helpful?
0 Yes | 0 No

238 views

Explain A benefit-cost ratio of 3.22 indicates a A. Profit of s3.22 per unit produced. B. Profit of s3.22 for each dollar expended. C. Resources assigned to other tasks on the critical path. D. Payback of s3.22 for each dollar expended.

Explain Although they have a variety of side-effects, the primary objective of incentive clauses in a contract is to A. Aligning contractor and buyer goals. B. Reduce risk for the contractor C. Controlling contractor costs D. Reduce costs to the buyer E. Reducing production costs.

Explain Which of the following statements describes quality control? A. Monitoring specific project results to determine if they comply with relevant quality standards. B. Evaluating over ll project performance on a regular basis. C. Taking action to increase the effectiveness and efficiency of they project. D. Identifying which quality standards are standards are relevant to the project.

As the project manager, which of the following techniques would you employ to control the project schedule? A. Pareto diagram. B. Statistical sampling. C. Performance measurement. D. Parametric modeling. E. All of the above.

Explain Which of the following theories are illustrated by the principle Employees who believe that their efforts will lead to effective performance and who anticipate important rewards for their accomplishments become productive stay productive.? A. The X-Y theory. B. Maslows theory. C. The expectancy theory. D. Ouchis Theory Z E. Herzbergs theory.

Ho to determine the staffing requirements of the project, the project mange FIRST needs a(n); A. Resource breakdown schedule. B. Responsibility assignment matrix. C. Work breakdown structure. D. Organization chart.

Explain The senior executive of your company wants monthly schedule update of your project. Which of the following would you send to the executive? A. Milestone chart B. Time-scaled network diagram C. Arrow activity diagram D. PERT chart

Explain Payback period analysis identifies that point in time when A. Profit maximum is realized. B. Unit profit is realized. C. Monthly revenue exceeds monthly costs. D. Cumulative revenue exceeds cumulative costs.

Explain Conflict resolution techniques that may be used on a project include A. Withdrawing, compromising, controlling, and forcing. B. Controlling forcing smoothing, and withdrawing. C. Confronting, compromising, smoothing and directing. D. Smoothing, confronting, forcing, and withdrawing.

Question and Answer:

Home Oracle Certification