What's the difference between DELETE TABLE and TRUNCATE TABLE
commands?
- 2 Answers
- 3696 Views
- CTC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / naveen reddy
delete table deletes entire table if we want to delete or else we can delete specific column or row.
if we wish to simply get rid of the data but not the table itself? For this, we can use the TRUNCATE TABLE command. The syntax for TRUNCATE TABLE is
TRUNCATE TABLE "table_name"
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / kalyan
truncate table means structure of table cannot deleted but
it deletes the data in the table. And Delete command deletes
the entire table with data.
| Is This Answer Correct ? | 1 Yes | 0 No |
what is output? main() { #define SQR(x) x++ * ++x int i = 3; printf(" %d %d ",SQR(i),i * SQR(i)); } a)9 27 b)35 60 c)20 60 d)15 175
what is the self-referential structure?
write a program to produce the following output; ABCDEFGFEDCBA ABCDEF FEDCBA ABCDE EDCBA ABCD DCBA ABC CBA AB BA A A
17 Answers ABC, College School Exams Tests,
Give the logic for this #include<stdio.h> #include<conio.h> void main() { clrscr(); int a=10,b; b=++a + ++a; printf("%d", b); getch(); } Output: 24......How?
What is the function of ceil(X) defined in math.h do? A)It returns the value rounded down to the next lower integer B)it returns the value rounded up to the next higher integer C)the Next Higher Value D)the next lower value
the data type used for unlimited value in c and how to do this program
Give a one-line C expression to test whether a number is a power of 2. [No loops allowed - it's a simple test.]
Explain the properties of union. What is the size of a union variable
What type of function is main ()?
main() { int i=5; printf("%d%d%d%d",i++,i--,i); }
what is the difference between normal variables and pointer variables..............
15 Answers HP, Infosys, Satyam, Vivekanand Education Society,
Write a program to reverse a string.
0 Answers Global Logic, iNautix, TCS, Wipro,
C 
