Ask questions which are clear, concise and easy to understand.
Ask QuestionPosted by Utk Arsh 6 years, 10 months ago
- 0 answers
Posted by Dipanshu Rai 6 years, 10 months ago
- 1 answers
Posted by Asif Ali 6 years, 10 months ago
- 1 answers
Posted by Aafreen Ansari 6 years, 10 months ago
- 0 answers
Posted by Manish Kumar 6 years, 10 months ago
- 0 answers
Posted by Yash Sangeliya 6 years, 10 months ago
- 0 answers
Posted by Sam Kumar 6 years, 10 months ago
- 1 answers
Shital Soni 6 years, 10 months ago
Posted by Manish Kumar 6 years, 10 months ago
- 0 answers
Posted by Gaurav Soni 6 years, 10 months ago
- 0 answers
Posted by Sumit Kumar 6 years, 10 months ago
- 0 answers
Posted by Ajsal Salam 6 years, 10 months ago
- 0 answers
Posted by Ajsal Salam 6 years, 10 months ago
- 1 answers
Khushi Khair 6 years, 10 months ago
Posted by Kamal Curz 6 years, 10 months ago
- 1 answers
Posted by Ujjwal Vats 6 years, 10 months ago
- 0 answers
Posted by Alok Mishra 6 years, 10 months ago
- 0 answers
Posted by Chanchal Vats 6 years, 10 months ago
- 0 answers
Posted by Siddharth Patel 6 years, 10 months ago
- 0 answers
Posted by Vishal Yadav 3 years, 6 months ago
- 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. |
Posted by Vishal Yadav 6 years, 10 months ago
- 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. |
Posted by Devyani Sharma 6 years, 10 months ago
- 0 answers
Posted by Rekha Tak 6 years, 11 months ago
- 0 answers
Posted by Kanishka Rai 6 years, 11 months ago
- 1 answers
Posted by Ram Kumar 6 years, 11 months ago
- 0 answers
Posted by Praveen Prajapati 6 years, 11 months ago
- 0 answers
Posted by Raman Manchanda 6 years, 11 months ago
- 0 answers
Posted by Tobit Lakra 6 years, 11 months ago
- 0 answers
Posted by Naveen Sony 6 years, 11 months ago
- 0 answers
Posted by Mayank Dhaliya 3 years, 7 months ago
- 1 answers
Sia ? 3 years, 7 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 6 years, 11 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
