No products in the cart.

Difference between drop command and delete …

CBSE, JEE, NEET, CUET

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

Difference between drop command and delete command

Posted by Vishal Yadav 3 years, 6 months ago

CBSE > Class 11 > Informatics Practices

1 answers

Sia ? 3 years, 6 months ago

Sr. No.	Key	DELETE	DROP
1	Purpose	DELETE Command, removes some or all tuples/records from a relation/table	DROP Command, removes named elements of schema like relations/table, constraints or entire schema.
2	Language	DELETE is DML.	DROP is DDL.
3	Clause	Where clause is used to add filtering.	No where clause is available.
4	Rollback	Delete command can be rollbacked as it works on data buffer.	Drop command can't be rollbacked as it works directly on data.
5	Memory Space	Table memory space is not free if all records are deleted using Delete Command.	Drop command frees the memory space.
6	Problem	DELETE command may face shortage of memory.	DROP Command may cause memory fragmentation.
6	Interaction	SQL directly interacts with database server.	PL/SQL does not directly interacts with database server.
7	Orientation	SQL is data oriented language.	PL/SQL is application oriented language.
8	Objective	SQL 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.

ANSWER

http://mycbseguide.com/examin8/

Related Questions

Which memory is termed as "destructive write" but 'non destructive read' memory

Posted by T Kumaran 7 months, 1 week ago

CBSE > Class 11 > Informatics Practices

0 answers

What is the security thread involved when we throw away electronic gadgets that are non functional

Posted by Samyak Jain 9 months ago

CBSE > Class 11 > Informatics Practices

0 answers

Case study questions of chapter 1

Posted by Jaspreet Sethi 6 months, 3 weeks ago

CBSE > Class 11 > Informatics Practices

0 answers

This content has been hidden. One or more users have flagged this content as inappropriate. Once content is flagged, it is hidden from users and is reviewed by myCBSEguide team against our Community Guidelines. If content is found in violation, the user posting this content will be banned for 30 days from using Homework help section. Suspended users will receive error while adding question or answer. Question comments have also been disabled. Read community guidelines at https://mycbseguide.com/community-guidelines.html

Few rules to keep homework help section safe, clean and informative.

Don't post personal information, mobile numbers and other details.
Don't use this platform for chatting, social networking and making friends. This platform is meant only for asking subject specific and study related questions.
Be nice and polite and avoid rude and abusive language. Avoid inappropriate language and attention, vulgar terms and anything sexually suggestive. Avoid harassment and bullying.
Ask specific question which are clear and concise.

Remember the goal of this website is to share knowledge and learn from each other. Ask questions and help others by answering questions.

Posted by Gopall Mahato 6 months ago

CBSE > Class 11 > Informatics Practices

0 answers

8. To find the third largest/smallest number in a list.

Posted by Account Deleted 10 months, 3 weeks ago

CBSE > Class 11 > Informatics Practices

1 answers

This content has been hidden. One or more users have flagged this content as inappropriate. Once content is flagged, it is hidden from users and is reviewed by myCBSEguide team against our Community Guidelines. If content is found in violation, the user posting this content will be banned for 30 days from using Homework help section. Suspended users will receive error while adding question or answer. Question comments have also been disabled. Read community guidelines at https://mycbseguide.com/community-guidelines.html

Few rules to keep homework help section safe, clean and informative.

Don't post personal information, mobile numbers and other details.
Don't use this platform for chatting, social networking and making friends. This platform is meant only for asking subject specific and study related questions.
Be nice and polite and avoid rude and abusive language. Avoid inappropriate language and attention, vulgar terms and anything sexually suggestive. Avoid harassment and bullying.
Ask specific question which are clear and concise.

Remember the goal of this website is to share knowledge and learn from each other. Ask questions and help others by answering questions.

Posted by Abi S 8 months, 3 weeks ago

CBSE > Class 11 > Informatics Practices

0 answers

Define each of the following 1.byte 2.kilobyte 3.megabyte 4.gigabyte 5.terabyte

Posted by Anchal Ratna 10 months, 3 weeks ago

CBSE > Class 11 > Informatics Practices

1 answers

1. Which of the following statement is incorrect? (a) 1 Byte 8 bits (c) 1 MB 1024 KB (b) 1 KB 1024 bytes (d) \overline{GB=} 1024 KB

Posted by Harleen Kaur 1 year ago

CBSE > Class 11 > Informatics Practices

4 answers

Differentiate between displaying and printing method in Python

Posted by Gowri Menon .Menon 6 months, 1 week ago

CBSE > Class 11 > Informatics Practices

0 answers

Differentiate between interactive and script mode of python.

Posted by Anshika Maurya 5 months, 3 weeks ago

CBSE > Class 11 > Informatics Practices

0 answers

myCBSEguide App

myCBSEguide

Trusted by 1 Crore+ Students

Test Generator

Test Generator

Create papers online. It's FREE.

CUET Mock Tests

CUET Mock Tests

75,000+ questions to practice only on myCBSEguide app

Google Play

Download myCBSEguide App