Differentiate between delete and truncate table?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Databases AllOther Interview Questions

What is the importance of database partitioning?

0 Answers  


Which three commands cause a transaction to end?

0 Answers   3i Infotech,


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

0 Answers   IBM,


What is the difference between database and server?

0 Answers  


What is Object Oriented model?

0 Answers   Thomson Reuters,






1.what are components of querystdio and report studio and cognoss connection? 2. how to use prompts in query studio? 3.what is lock and un lock objects? 4.how to test the re[ports in query studio? 5.how to use brust option and when? 6.what is the performance testing? 7.condition explorer whaen your using? 8.in impromptu how do you create cascading prompt? 9.diff between section and group? 10.types filters where you are using group filters and tabular filter? 11.tabular model, tabular references ,tabular set , tabular sql? 12.what is the use of multi[le packages? 13what types of problems arise when create a join? 14.how to provide package sequirety? 15.report server components? 16.how many kinds of quality subjects? 17.how do you specify the joins? 18.how would you maintain the relations in frame work manager? 19.what is usage of segments and how to provide it? 20.governer settings in frame work maneger? 21.how to create filter in frame work manager? 22diffrence between represention layer and physical layer? 23.how to create prompts in frame work manager? 24.what errors occured when verify the model? 25.how to publish package in net work or local system?

1 Answers   Wipro,


What is the function of cluster index?

0 Answers   Alcatel-Lucent,


Can you create a database in word?

0 Answers  


what is meant by Dynamic query?

3 Answers   Satyam,


Explain various types of locks in a transaction? Which is better and why?

0 Answers   Agilent,


How does non-cluster index functions?

0 Answers   Alcatel-Lucent,


What is the Difference Primary key and Unique Key

0 Answers   HCL,


Categories