Programmatic Constructs Interview Questions
How to declare a variable with float (2 decimal places) in table creation in Oracle?
How to declare a variable with float (2 decimal places) in table creation in Oracle?
use interfaces
If the procedure doing one part of your procedure then you can always use that procedure into the packages, and if you want to do the singal opration you can use procedure only.
If you call procedure from package, package get load into the memory. We can use pragma to overcome from same.
What are the differences between database trigger and integrity constraints ?
A declarative integrity constraint is a statement about the database that is always true. A constraint applies to existing data in the table and any statement that manipulates the table. a trigger does not apply to data loaded before the definition of the...
An integrity constraint defines a business rule for a table column which automatically takes care by Oracle internally. Intefrity Constraints are NOT NULL, UNIQUE, CHECK, PRIMARY KEY, FOREIGN KEY. ...
A trigger is a piece of code which gets automatically executed upon occurrence of an event. It may not be meant for enforcing integrity. For example you may want to save the user info as soon as he ma...
What is difference between procedures and functions ?
A function returns a value to the caller where as a procedure does not.
Procedure executes as a part of PL/SQL block wherein Function invoked as part of expression.Function must have RETURN keyword in the header , which is not applicable for Procedure.Function must return...
Procedure is to do specific task where as function is to compute values.
Procedure may or may not return value at all, but function must return value.
Function can be used in SQL statement but Procedure is not used.
You can check this by using translate function. If the return value is NULL then the input is a number else it is character or alpha numeric.Ex:select ('abcd', '~0123456789', ...
You can use translate function.translate(
What are the advantages of having a package ?
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...
pakage having more advantages
1)Modularity
2)Easily application dision
Main advantage is OVERLOADING of function and procedures
A procedure consist of a set of SQL and PL/SQL statements that are grouped together as a unit to solve a specific problem or perform a set of related tasks.
Procedure is a named PL/SQL block and a reusable database object which can accept multiple arguments, execute PL/SQL statements, do exception handling and return multiple results. Procedures are stored and executed in the database.
A forms trigger may do nothing more than change the focus to a new item or show a new canvas
What are the contents and components of supplied packages?
Procedures and functions,packages and database triggers.
A package is a collection of related procedures, functions, variables and other package constructs together as a unit in the database.
A database trigger is procedure (set of SQL and PL/SQL statements) that is automatically executed as a result of an insert in,update to, or delete from a table.
What are the uses of database trigger ?
Database triggers can be used to automatic data generation, audit data modifications, enforce complex integrity constraints, and customize complex security authorizations.
User Panel
Categories
Interview Coaching
Ads
Connect
Ads
Interview Question
Latest Questions
Ads
Interview & Career Tips
Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.
NH
