Difference between drop command and delete c9mmand
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
\tSr. No.KeyDELETEDROP1PurposeDELETE Command, removes some or all tuples/records from a relation/tableDROP Command, removes named elements of schema like relations/table, constraints or entire schema.2LanguageDELETE is DML.DROP is DDL.3ClauseWhere clause is used to add filtering.No where clause is available.4RollbackDelete command can be rollbacked as it works on data buffer.Drop command can\’t be rollbacked as it works directly on data.5Memory SpaceTable memory space is not free if all records are deleted using Delete Command.Drop command frees the memory space.6ProblemDELETE command may face shortage of memory.DROP Command may cause memory fragmentation.6InteractionSQL directly interacts with database server.PL/SQL does not directly interacts with database server.7OrientationSQL is data oriented language.PL/SQL is application oriented language.8ObjectiveSQL is used to write queries, create and execute DDL and DML statments.PL/SQL is used to write program blocks, functions, procedures, triggers and packages.\t