i have executed the Delete command after the I have created
table whether deletions will be
commit or not? if table is successfully created?
Answer Posted / mohit singla
Deletion won't be commit. Also if our table is created
successfully and we are using rollback even then it won't
fetch the delete statement.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
interview questions with answer for cts
List the types of joins used in writing subqueries?
What privilege is needed for a user to insert rows to tables in another schema?
What is an oracle tablespace?
What is an oracle user account?
How to call a stored function with parameters?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to define default values for formal parameters?
What is key preserved table?
Explain the use of record length option in exp command.
Why cursor variables are easier to use than cursors?
Give the various rollback segment states.
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.
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
How many memory layers are in the oracle shared pool?