Once data is truncated it can not be rolled back (recovered). However, data can be rolled back if deleted accidentally.
Delete statement deletes only the data from the table but you can apply some condition and only part of the data can be deleted. Truncate empties entire table. Drop deletes the table itself.
difference between database and non database
Database integrity refers to the safety of data. For example a transaction is made from an account of rs 500 and in between of transaction there is an abrupt , then integrity of data will be maintained and transaction will not occur.
what is the difference between hirarchical,network and relational database model?
explain the difference between cash and credit transaction
the difference is about the transactions. the normal database is not included deadline, but the real time database is.
processing a transaction includes involves cash or non transaction and concept of different between two?
the difference between database operating system and conventional operating system
Transaction is bank risk
What is transaction what it contains
Database is the data stored in the server and Database administrator is the person who designs the database.
It is a collection tables that is stored in a database
A relational database is a type of database, so in one sense there is no difference. There are various kinds of database. A relational database is one type. Others include network and hierarchical.
A database is composed of one or more records.
A database is a file. A database server is a computer that shares that file over a network.
CACHE is multidimensional and postconsonantal database and its supporting scripting
·A nested transaction is a transaction that is logically decomposed into a hierarchy of sub transaction. A distributed transaction is logically a flat, indivisible transaction that operates on distributed data.
differences between document management and database technology
local procedure wont store in database. Stored procedure store in database permanently and we can use it whenever we require. Other program also can use this stored procedure. And the transaction of stored procedure take care by DBA. But the local procedure transaction is take care by manually only
The difference is not so much in the database itself but with the application that uses it. An operational application does all database queries/updates in a single one-and-done manner. Transactional applications have multiple steps that are considered a single unit and may involve dozens of database operations that must all be completed before any are finalized. Otherwise, the entire transaction is rolled back.
even though both these commands are related to the structure of the table...,we can regain the data when we use use drop command by use of rollback command but its not possible in the case of truncate command.
DATABASE FILE - is one that is stored on a server and it is in the format that the database needs to read it. It is stored in the database catalog......
File is a collection of records whereas database is a collection of data in a file