Answer Posted / sohini
A transaction is a series of SQL data manipulation
statements that does a logical unit of work.DML statements
run between explicit COMMIT,ROLLBACK or when database is
connected or disconnected form a transaction.DDL, DCL and
TCL statements issue autocommit hence they do not form
transaction.Also when one transaction ends another one
starts.
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Is oracle a relational database?
How can I see all tables in oracle?
What are the data types in oracle?
What is a nested table and how is it different from a normal table?
How to delete all rows a table in oracle?
How to open and close an explicit cursor in oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
Is java required for oracle client?
How does the on-delete-cascade statement work?
What is a nvl function? How can it be used?
How view is different from a table?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What privilege is needed for a user to query tables in another schema?
How to delete a column in an existing table?
How many file formats are supported to export data?