Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 15772 Views
- I also Faced
- E-Mail Answers
Answer Posted / kishore
truncate removes all the rows from a table
it can't be rollback
delete removes all /specific rows from a table
it can be rollback
drop removes whole table
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how can a session indicate its interest in receiving alerts?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is asm?
how can you create a user-defined lock?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
How would you extract DDL of a table without using a GUI tool?
What is replication? : sql server DBA
how can you initialize log miner?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
how can you record information about current session?
internal architecture
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
what do you understand by flashback feature of oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
