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

About partions and pivot operator

Pivot queries involve transposing rows into columns (pivot) or columns into rows (unpivot) to generate results in crosstab format. Pivoting is a common technique, especially for reporting, and it has been possible to generate pivoted resultsets with sql for many years and oracle versions. However, the release of 11g includes explicit pivot-query support for the first time with the introduction of the new pivot and unpivot keywords. These are extensions to the select statement and we will explore the syntax and application of these new features in this article.

Pivot

We will begin with the new pivot operation. Most developers will be familiar with pivoting data: it is where multiple rows are aggregated and transposed into columns, with each column representing a different range of aggregate data. An overview of the new syntax is as follows:

What are joins

Can we use join more than one table

Diff b/w implicit and explicit

What is materialized view

I want to create a mv on another database and refresh periodically it is possible

What is tunning

What is hint

Do you know sql *loader

What is your roles and responsibility?

How to communicate to your pm?

Select count(1) from dual;,what is output?

How to delete duplicate record's from table without distinct clause?

How to retrieve second height salary from table?

Diff b/w primary key & unique key?

Diff b/w procedure & package?

Which is better procedure or package?

What is cursor?types of cursor? And diff b/w cursors?

What is exception? Types of exceptions?

Tell me some user_defined exceptions with error codes?

What is sqlcode and sqlerr?

What is ref_cursor? Type of ref_cursors and diff b/w?

How give privilege a one procedure in package?

What is %type & %rowtype? What is main use?

How to improvee performence?

What is bulk collect? What is use of limit clause in bulk collect?

What is forall?

What is merge statement? Give me syntax?

What is view? Use of view's?

What is nocopy clause?where it is used?

What are the environments are there in your company?

How to connect your database?

What are the shartcut of compile & execution of programes in sql developer tool?

Are faced any trouble in your project?

What are the module's , you are working?

Which will fire default first statement level or row level trigger?

What is bulkcollect? And any restrictions in bulkcollect?

What is the use of limit clause in bulkcollect?

How to debugg your code?

How to trace error handling?

How to find which line error was raised?

What are the methods there in save exceptions?

What is functional based index? Write syntax?

How to update complex view?

Can you alter procedure with in package?

Is it possible to open cursor which is in package in another procrdure?

What is substr()&instr()?

Difference between case and decode?

Can you use sysdate in check constraints? If no, why?

Difference between column level constraints & table level constraints?

What is optimizer?

What is nested_loop join?

What is pivot operater?

Tell me some oracle 10g features?

What is m_view?

What is master & detail tables?

What is sqlcode and sqlerrm?

Diff b/w procedure & packages?