Oracle Interview Questions - 5Monday, March 24, 2014
Oracle Interview Questions - 5
Extracted Page: http://www.gcreddy.net/2013/01/oracle-interview-questions-5.html
Q.Can you use a commit statement within a database trigger?
no,we can't use commit statement
in the trigger,we are using trigger
for checking purpose.
within table we can add constraint or trigger.purpose of both is same.
Q.What should be the return type for a cursor variable.Can we use a scalar data type as return type?
The return type for a cursor must be a record type.It can be declared explicitly as a user-defined or %ROWTYPE can be used. eg TYPE t_studentsref IS REF CURSOR
Q.What are various privileges that a user can grant to another user
Additional text has been truncated due to copyright reasons. Things without URLs and private things don't get truncated.