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 11885

what is pragma ?

Polaris,

1 7129

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

HCL, Wipro,

3 10961

how to calcuate the second highest salary of he employee

Synechron,

13 18951

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

Fiserv, Herbinger, Synechron,

1 11453

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

17 32682

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 7517

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

IBM,

3 10255

What are Global Temporary tables

IBM, TCS,

3 11177

What are Anti joins

IBM,

1 10443

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 9506

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 16483

What is bulk collections?

2 7970

what is External tables? explain with examples

TCS,

2 13942

what is difference between decode and case function?

2 10248

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Should I use mbr or gpt?

1061

What does select count (*) mean in sql?

1073

Write a sql query to convert all character to uppercase after hypen.

1484

what is self-join? : Sql dba

1235

What do you mean by “trigger” in sql?

1126

What are system versioned tables?

1069

What kind of join is join?

1007

What do you mean by table in sql?

1045

What is difference between pls_integer and integer?

1009

Enlist the advantages of sql.

1052

What does pragma mean?

1128

What is view? Can we update view

1518

Can you selectively load only those records that you need? : aql loader

1092

How to run sql functions in pl/sql?

1119

What is compound trigger?

1097

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