what is difference between delete and truncet ?
Answer Posted / karna
As of I know,we can roll back bothe delete and truncate
statements.but in case of delete statement logging of the
details in the log file takes more time,beacuse it logs the
details row by row in the page.
when it comes to truncate,all the rows will be logged at
the same time.
Please correct me,If I am wrong.
Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
How to produce such kind of file?
First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9
What is a database example?
aht is the difference b/w network & hierarchial & relational dbms????
Give the syntax of exception handling used in DBMS?
There are three servers are run by Oracle, MS Access and .Net. What are the procedure fetching the values of two variables from two servers among these?
Explain the record term used in database.
What is global database name?
What do you mean by cluster and non cluster index?
What is meant by distributed system?
what is data access layer?
How to do Data integrity testing? Who does this testing (Developer or tester)?
What is odm database?
Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
What advantages does DBMS have over traditional file systems?