Interested to Buy Any Domain ? << Click Here >> for more details...
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
Can group functions be used in the order by clause in oracle?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What are nested tables?
Can we create trigger on materialized view in oracle?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How to select some columns from a table in oracle?
What is oracle database 10g express edition?
What do you mean by a database transaction & what all tcl statements are available in oracle?
What are the different types of database objects?
How to compare dates in oracle sql?
What is snapshot is too old? Give and example for better understand.
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How to view the data files in the current database?
ABOUT IDENTITY?
How to create tables for odbc connection testing?
