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...
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...
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...
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...
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...
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...
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...
How to display even records in a table? SELECT * FROM emp WHERE (rowid,0) IN (SELECT rowid, mod(rownum,2) FROM emp );
How to print the even and odd numbers from 1 to 10? BEGIN FOR i IN 1..10 LOOP IF mod(i,2) = 0 THEN dbms_output.put_line(i||' is an even number'); END IF; END LOOP; FOR i IN 1..10 LOOP IF mod(i,2)!= 0 THEN dbms_output.put_line(i||' is an odd number');...
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...
