SQL PLSQL Interview Questions
Questions Answers Views Company eMail

how are rank and dense rank being alloted for column with same values over a particular column

1 288

what are sequences

276

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

147




What is Difference Between Unique and Primary Key Constraints?

Wipro,

9

What is a Mapplet?

Informatica,

9

How to change the order of columns in Oracle SQL Plus ?

MCN Solutions,

10

How to display Row Number with Records in Oracle SQL Plus?

MCN Solutions,

10

How to display the records between two range in Oracle SQL Plus?

MCN Solutions,

15




How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

MCN Solutions,

12

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

MCN Solutions,

12

Can a procedure in a package be overloaded?

EXL,

13

Can procedure in package be overloaded?

EXL,

12

Can procedure in a package be overloaded?

HCL,

7

Inline the values in PL/SQL, what does it mean.?

MCN Solutions,

13

How can we store rows in PL/SQL using array?

MCN Solutions,

13


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

How to display Row Number with Records in Oracle SQL Plus?

10


what is the bond code in materialized view?

1795


What are the two types of exceptions.

1


Explain polymorphism in pl/sql.

3


What is an intersect?

4






Show the cursor attributes of pl/sql.

3


When is a declare statement required?

3


What action do you have to perform before retrieving data from the next result set of a stored procedure ?

1532


ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

1242


What operators deal with null?

3


what is single byte over head in oracle..?

1312


Can a commit statement be executed as part of a trigger?

1


How is a PL/SQL code compiled?

16


What are the key differences between SQL and PL SQL?

13


Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1