Sign Up

Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

You must login to ask a question.

Forgot Password?

Need An Account, Sign Up Here

You must login to add post.

Forgot Password?

Need An Account, Sign Up Here

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.

Sign InSign Up

mcqoptions.com

mcqoptions.com Logo mcqoptions.com Logo

mcqoptions.com Navigation

  • Home
  • About Us
  • Contact Us
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • About Us
  • Contact Us
Home/ Questions/Q 38384
Next
In Process
Akanksha Mahmood Dube
Akanksha Mahmood Dube
Asked: 3 years ago2022-11-11T00:49:44+05:30 2022-11-11T00:49:44+05:30In: Class 11

Difference between drop command and delete c9mmand

Difference between drop command and delete c9mmand
  • 0
  • 11
  • 0
  • 0
  • 0
    • Report
  • Share
    • Share on Facebook
    • Share on Twitter
    • Share on LinkedIn
    • Share on WhatsApp
Leave an answer

Leave an answer
Cancel reply

Browse

1 Answer

  • Voted
  • Oldest
  • Recent
  • Random
  1. a2e31
    2022-11-09T00:27:11+05:30Added an answer about 3 years ago

    \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

    • 0
    • Reply
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
      • Report

Sidebar

Ask A Question

Stats

  • Questions 500k
  • Answers 393k
  • Best Answers 0
  • User 1
  • Popular
  • Answers
  • Aditi Dugal

    How to approach applying for a job at a company ...

    • 7 Answers
  • Raghavan Prasad Hayer

    How to handle personal stress caused by utterly incompetent and ...

    • 5 Answers
  • Ankita Dinesh Biswas

    What is a programmer’s life like?

    • 5 Answers
  • 47e0c
    47e0c added an answer Correct Answer - Increasing the yield of animals and improving… November 12, 2022 at 9:56 am
  • b6699
    b6699 added an answer Sender\'s addressDateReceivers name and addressSubjectContentYours faithfullyName November 12, 2022 at 9:56 am
  • 10eb8
    10eb8 added an answer Any uncertinity in measurment is known as errorDifference in true… November 12, 2022 at 9:56 am

Related Questions

  • Find value of sin18°

    • 0 Answers
  • Suno salomi jab result aaye to jara no. Sub. Wise ...

    • 1 Answer
  • Explain the word homo. Into how many characteristics it is ...

    • 0 Answers
  • Hey! Is anyone there? Kha ho yrrr sare

    • 1 Answer
  • What is coloid solution....??

    • 1 Answer

Top Members

Trending Tags

Class 11 Parabola Polity Polynomials Probability Projectile Protists Quadrilaterals Rario Reasoning Sampling Social Solutions Spectroscopy Switchgear Thermodynamic Tourism Transients Upsc Wbjee

Explore

  • Home
  • Questions
    • New Questions
    • Trending Questions
    • Must read Questions
    • Hot Questions
  • Tags
  • Badges
  • Users

Footer

mcqoptions.com

About

MCQOptions.com

Here are the top interview questions, example answers, tips for giving the best response.

About Us

  • About Us
  • Contact Us

Legal Stuff

  • Terms of Use
  • Privacy Policy
  • Cookie Policy

Follow

© 2022 MCQOptions. All Rights Reserved

Insert/edit link

Enter the destination URL

Or link to existing content

    No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.