Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 15568 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
Why would you call update statistics? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
who owns the operating system files created by the utl_file package?
Query processing is slow(eg select query)how will u solve that
Which autogrowth database setting is good? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
which background process invoke at the time of upgradation tell me???
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
what is ora 24313?what is the procedure to exclude that error?
