SQL PLSQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

What is the Query to print out the individual total number of duplicate row in sql.

TCS,

5 11682

what is pragma ?

Polaris,

1 7056

is it necessary to write group by and order by clause together

HCL, Wipro,

3 10807

how to calcuate the second highest salary of he employee

Synechron,

13 18508

what is outer join? what is selef join? what is difference between them? what is cartecion join?

Fiserv, Herbinger, Synechron,

1 11339

i need department wise top 2 employees salary.which logic i will use

17 32147

If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??

3 7394

What are Nested Tables? How will u delete 5 rows from Nested Tables

IBM,

3 10087

What are Global Temporary tables

IBM, TCS,

3 11010

What are Anti joins

IBM,

1 10337

Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..

8 9248

If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?

JPMorgan Chase,

9 16138

What is bulk collections?

2 7855

what is External tables? explain with examples

TCS,

2 13812

what is difference between decode and case function?

2 10140

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How to get unique records from a table?

959

What is the use of procedures?

971

What are the subsets of sql?

1127

What is cursor in pl sql with examples?

1033

How many triggers can be applied to a table?

1056

how to use like conditions? : Sql dba

1103

What is group function in sql?

1014

What are the types of keys?

989

What are the advantages of stored procedure?

1003

What jobs use sql?

978

Is left join inner or outer by default?

1014

Are stored procedures compiled?

915

what is the different between now() and current_date()? : Sql dba

1012

What is acid property in a database?

1031

How do I find sql profiler?

933

For More Un-Answered { SQL PLSQL } Questions Click Here