Ask questions which are clear, concise and easy to understand.
Ask QuestionPosted by Asif Ali 8 years, 1 month ago
- 1 answers
Posted by Aafreen Ansari 8 years, 1 month ago
- 0 answers
Posted by Manish Kumar 8 years, 1 month ago
- 0 answers
Posted by Yash Sangeliya 8 years, 1 month ago
- 0 answers
Posted by Sam Kumar 8 years, 1 month ago
- 1 answers
Shital Soni 8 years, 1 month ago
Posted by Manish Kumar 8 years, 1 month ago
- 0 answers
Posted by Gaurav Soni 8 years, 1 month ago
- 0 answers
Posted by Sumit Kumar 8 years, 1 month ago
- 0 answers
Posted by Ajsal Salam 8 years, 1 month ago
- 0 answers
Posted by Ajsal Salam 8 years, 1 month ago
- 1 answers
Khushi Khair 8 years, 1 month ago
Posted by Kamal Curz 8 years, 1 month ago
- 1 answers
Posted by Ujjwal Vats 8 years, 1 month ago
- 0 answers
Posted by Alok Mishra 8 years, 1 month ago
- 0 answers
Posted by Chanchal Vats 8 years, 1 month ago
- 0 answers
Posted by Siddharth Patel 8 years, 1 month ago
- 0 answers
Posted by Vishal Yadav 4 years, 9 months ago
- 1 answers
Sia ? 4 years, 9 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. |
Posted by Vishal Yadav 8 years, 1 month ago
- 1 answers
Sia ? 4 years, 9 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. |
Posted by Devyani Sharma 8 years, 1 month ago
- 0 answers
Posted by Rekha Tak 8 years, 1 month ago
- 0 answers
Posted by Kanishka Rai 8 years, 1 month ago
- 1 answers
Posted by Ram Kumar 8 years, 1 month ago
- 0 answers
Posted by Praveen Prajapati 8 years, 1 month ago
- 0 answers
Posted by Raman Manchanda 8 years, 1 month ago
- 0 answers
Posted by Tobit Lakra 8 years, 1 month ago
- 0 answers
Posted by Naveen Sony 8 years, 1 month ago
- 0 answers
Posted by Mayank Dhaliya 4 years, 10 months ago
- 1 answers
Sia ? 4 years, 10 months ago
System software is a type of computer program that is designed to run a computer's hardware and application programs. System software is of three main types : Operating system. Language processor.
Posted by Vinayak Raj 8 years, 1 month ago
- 0 answers
Posted by Varshita Virwal 8 years, 2 months ago
- 0 answers
Posted by Tanisha Sharma 8 years, 2 months ago
- 0 answers
myCBSEguide
Trusted by 1 Crore+ Students
Test Generator
Create papers online. It's FREE.
CUET Mock Tests
75,000+ questions to practice only on myCBSEguide app
Lakshay Agarwal 8 years, 1 month ago
1Thank You