Oracle Functions, Procedures, packages

Oracle function, procedure and package related Interview questions

<<Previous  Next>>     

Explain IN, OUT and INOUT in procedures.    IN, OUT and INOUT are the arguments that are passed to the procedures................ Read answer Explain the rules for writing a package. Packeges are PL/SQl constructs that allow related data to be stored together. A package has two parts: specification and a body.................. Read answer Oracle index What is an Index?, What are the objects in oracle?, What is INDEX_BY_BINARY_INTEGER?, What is index and explain its purpose, What are the guidelines to decide which table s to index?.................. Read answer Oracle nested table and varrays A nested table is an unordered set of data elements. These data elements are all of the same datatype. It has a single column whose type is either built in or an object type. It is a table stored within the structure of another table............. Read answer Oracle optimizer Explain how oracle optimizer works, Describe optimization methods, i.e. cost-based approach and role-based optimization.......... Read answer Oracle procedures Using SQL statements, remote tables can be accessed in procedures. Database links are specifically used for this purpose. They connect one oracle database to another................ Read answer Oracle transaction The parser scans the statement and breaks it into logical units such as keywords, identifiers and operators, A query or a sequence tree is built using the units above. This is done to transform the source data into the format required by the result set............. Read answer  <<Previous  Next>>