Logo F2FInterview

Oracle Programmatic Interview Questions

Q   |   QA
‹‹ previous123

Increased functionality (for example,global package variables can be declared and used by any proecdure in the package) and performance (for example all objects of the package are parsed compiled, and loaded into memory once) 

A Function returns a value to the caller where as a Procedure does not. 

Schema objects are the logical structures that directly refer to the databases data.
Schema objects include tables, views, sequences, synonyms, indexes, clusters, database triggers, procedures, functions packages and database links. 

Database triggers can be used to automatic data generation, audit data modifications, enforce complex Integrity constraints, and customize complex security authorizations. 

A Package is a collection of related procedures, functions, variables and other package constructs together as a unit in the database.

package is collection of logicaly related procedure,funtion,varialbles
wich are stored all togther.Package implemnt the concept of Object orintation Encalsulatio,Datahiding andd polymorphism disadvantage of the package when a single function or procedure is called from package it also compiles all its related obejcts and get it store in SGA. 

‹‹ previous123

In order to link this F2FInterview's page as Reference on your website or Blog, click on below text area and pres (CTRL-C) to copy the code in clipboard or right click then copy the following lines after that paste into your website or Blog.

Get Reference Link To This Page: (copy below code by (CTRL-C) and paste into your website or Blog)
HTML Rendering of above code: