Database - Introduction to SQL - Discussion

Discussion :: Introduction to SQL - General Questions (Q.No.7)

7. 

The command to eliminate a table from a database is:

[A]. REMOVE TABLE CUSTOMER;
[B]. DROP TABLE CUSTOMER;
[C]. DELETE TABLE CUSTOMER;
[D]. UPDATE TABLE CUSTOMER;

Answer: Option B

Explanation:

No answer description available for this question.

Vinod said: (Jul 1, 2011)  
Once the table is dropped from data base by using drop
the data will be exists in recycle bin ....
so we can get it back by using >flashback ....... command

if we drop the table by using
>drop table customer purge;
(drop+purge) the whole data will be loss from recycle bin so we will no get it back ..... even by using >flashback ...... command also

Ruthvik said: (Aug 31, 2011)  
Flash back is a command that is added from oracle 10g only, if we drop a table on oracle 8i or 9i we can't get it back.

Manche Shekhar said: (Nov 8, 2011)  
If you want to remove a table from the database then we use drop command.

Drop is a DDL command.

The syntax is:
Drop table <tablename>;

From oracle 10g onwards if u remove a table ,we can get back by using Flashback command:

The syntax is:

Flashback table <tablename> before drop;

If you want to remove a table perminently then we use purge command.

Drop table <tablename> purge;

Vishwa said: (Jan 29, 2012)  
But we can delete table from database by using Delete Command.
So Both B and C correct.

Snehal said: (Nov 14, 2013)  
Then what is use of truncate command and what is difference between delete and truncate command?

Can we undo these commands?

Snehal said: (Nov 14, 2013)  
What is use of truncate command?can we undo delete and truncate command?And difference between delete and truncate command?

Lovesh said: (Feb 12, 2014)  
Truncate command is used to delete the complete data from an existing table.

syntax:

TRUNCATE TABLE table_name;

Santosh Yepuri said: (Feb 20, 2014)  
Delete Command Can delete specific record but in Truncate command it is not possible to delete specific record. And in Truncate command Where clause not support.

Parvez said: (Feb 29, 2016)  
Truncate command clear the records and free the memory. Wheres delete command doesn't free the memory.

Nicat said: (Dec 16, 2016)  
Truncate is used for Emptying the interior.(Clear records from table). Example we have students table. If we use the truncate command, only deleted records, not column names.

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.