Explain the difference between drop and delete, Database Management System

Assignment Help:

Explain the Difference between DROP and DELETE

DELETE deletes one or more than one tuples of a particular relation from the database. DROP is employed to remove a table from the schema. While DROP removes the definition of the relation also the data in the given relation, delete only deletes the tuples but keeps the table definition.

Related Discussions:- Explain the difference between drop and delete

What is called an evaluation primitive, What is called an evaluation primit...

What is called an evaluation primitive? A relational algebra operation annotated with instructions on how to evaluate is known as an evaluation primitive.

Non-redundant cover and canonical cover, Given the following set of functio...

Given the following set of functional dependencies {cf?bg, g?d, cdg?f, b?de, d?c} defined on R(b,c,d,e,f,g) a.Find a non-redundant cover. b.Find a canonical cover.

Differentiate between strict and rigorous two phase locking, Differentiate ...

Differentiate between strict two-phase and rigorous two-phase with conversion protocol Ans: Strict two-phase locking holds all its exclusive that is write locks until commit t

What is theta join explain, What is theta join explain? Theta Join -...

What is theta join explain? Theta Join - The theta join operation is an extension to the natural-join operation which permits us to merge selection and a Cartesian

Example for while until, Assume you are given a uniprocessor system with on...

Assume you are given a uniprocessor system with one gigabyte of memory and a 300 gigabyte disk. The OS on the machine has a demand paged virtual memory system with a local page rep

Fragmentation, Differentiate between horizontal & mixed horizontal fragment...

Differentiate between horizontal & mixed horizontal fragmentation?

Which is the properties of entities, Which is the properties of entities? ...

Which is the properties of entities? Attributes is the properties of entities.

What are the different integrity constraints in rdbms, What are the differe...

What are the different integrity constraints in RDBMS? The various integrity constraints in RDBMS are as: Primary Key: primary key is a grouping of one or more attributes

Concurrency executions, Explain TPS concurreny executions stating their adv...

Explain TPS concurreny executions stating their advantages in online business advancement

What are the strategies of implementation of the statecharts, What are the ...

What are the different strategies of implementation of the Statecharts? There are two strategies for implementation of state charts: i) Basic Implementation Strategy

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages