What does ROLLBACK do ?
It is used to undo the work performed by the current transaction.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is SQL Tuning Advisor in Oracle?
Explain cascading triggers.
What is Database Buffers ?
Why we choose emp number as primarykey?
How to invoke the data pump import utility?
What are nested tables?
9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS
What is a schema in oracle?
Whether any commands are used for months calculation? If so, what are they?
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
What WHERE CURRENT OF clause does in a cursor?
How to define default values for formal parameters?