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 1780

what are sequences

1316

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

1000

What is Difference Between Unique and Primary Key Constraints?

Wipro,

827

What is a Mapplet?

Informatica,

826

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

MCN Solutions,

792

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

MCN Solutions,

771

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

MCN Solutions,

872

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

MCN Solutions,

814

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

MCN Solutions,

944

Can a procedure in a package be overloaded?

EXL,

754

Can procedure in package be overloaded?

EXL,

841

Can procedure in a package be overloaded?

HCL,

1 1123

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

MCN Solutions,

857

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

MCN Solutions,

887


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is not null in sql?

783


Can you have more than one key in a database?

690


Explain some predefined exceptions.

780


How do I create a memory optimized filegroup?

699


What is difference between hql and native sql?

778






What is the use of desc in sql?

698


What are all the different normalizations?

745


Is primary key a clustered index?

710


Which tcp/ip port does sql server run?

717


What are the string functions in sql?

720


Why do you partition data?

727


Is pl sql and postgresql same?

771


What is normalisation in sql?

781


Can we use two order by clause in query?

738


Which normal form is best?

675