Overblog All blogs Top blogs Jobs, Education & Studies
Follow this blog Administration + Create my blog
MENU
Advertising

Tech Mahindra PL/SQL Interview Questions

Tech Mahindra PL/SQL Interview Questions Introduce yourself Tell me your project What are the packages, functions, procedures you developed in your project what are their Functionality? Difference between loop and bulk collect which is the faster way...

Read more

Advertising

Polaris PL/SQL Interview Questions

Polaris PL/SQL Interview Questions Tell me about yourself What is your front end How to pass data to java Diff b/w procedure and function Can we use all kind of function in function What is trigger and trigger types Do you know about analytical queries...

Read more

Oracle Hints

Optimizer hints can be used with SQL statements to alter execution plans Hints let you make decisions usually made by the optimizer. As an application designer, you might know information about your data that the optimizer does not know. Hints provide...

Read more

PRAGMA INLINE IN ORACLE

The INLINE pragma specify that a sub program call is, or is not, to be inlined. Inlining replaces a sub program call (to a sub program in the same program unit) with a copy of the called sub program. To reiterate, with sub program inlining, Oracle will...

Read more

Advertising

Oracle PRAGMA TYPES

Pragma compiler directives instructs compiler with certain information. It is Processed at compile time not at run time. The directive restricts member sub programs to query or modify database tables and packaged variables. PRAGMA directive should be...

Read more

What is normalization ?

Defination : Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies...

Read more

SQL*Loader : bad file vs discard file

SQL*Loader : bad file vs discard file What is the difference between the bad file and the discard file in SQL*Loader. The bad file and discard files both contain rejected rows, but they are rejected for different reasons: Bad file: The bad file contains...

Read more

Advertising

Difference Between Cursor And Ref Cursor

Difference Between Cursor And Ref Cursor In this post I am trying to detail out the differences between Cursor and Ref Cursors. I am sure, this question has been asked in many interviews to many of us and it also has its own technical weightage. Lets...

Read more

<< < 1 2 3 4 5 6 7 > >>