Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kiran.
Delete(DML) : All records not possible to Delete at a time,
Where clause is allowed.
structure of the table is available.
Roll Back is possible.
Truncate(DDL): All records possible to Delete at a time,
Where clause is not allowed.
structure of the table is not available.
Roll Back is possible.
>Truncate Table<tablename>;
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is union and union all keyword in sql and what are their differences?
Explain what is rdbms?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
How to get unique records from a table?
what are the disadvantages of mysql? : Sql dba
Mention what are the benefits of pl/sql packages?
Show the two pl/sql cursor exceptions.
What is microsoft t sql?
What are the different types of joins in sql?
What is where clause in sql?
Why we use triggers in mysql?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
what are the 'mysql' command line arguments? : Sql dba
How do I run a sql trace?
What is gpt format?
