What are built-ins used for Processing rows?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

345. What are built-ins used for Processing rows?

GET_GROUP_ROW_COUNT(function) GET_GROUP_SELECTION_COUNT(function) GET_GROUP_SELECTION(function) RESET_GROUP_SELECTION(procedure) SET_GROUP_SELECTION(procedure) UNSET_GROUP_SELECTION(procedure)

(Continued on next question...)

Other Job Interview Questions

• What is WHEN-Database-record trigger?
• What are the different windows events activated at runtimes?
• How can you find out how many users are currently logged into the database? How can you find their operating system id?
• What is Distributed database?
• What are the different approaches used by Optimizer in choosing an execution plan?
• What is the significance of having storage clause?
• How can a cross product be created?
• What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?
• Describe two phases of Two-phase commit?
• Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?
• More...