Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 9358

what is pragma ?

Polaris,

1 6030

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

HCL, Wipro,

3 9144

how to calcuate the second highest salary of he employee

Synechron,

13 13704

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

Fiserv, Herbinger, Synechron,

1 10123

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

17 26328

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 5959

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

IBM,

3 8081

What are Global Temporary tables

IBM, TCS,

3 9125

What are Anti joins

IBM,

1 8577

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 6262

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,

8 11253

What is bulk collections?

2 5939

what is External tables? explain with examples

TCS,

2 11982

what is difference between decode and case function?

2 8656


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what are all the common sql function? : Sql dba

398


How do I pipe the output of one isql to another?

356


What is the syntax to add a record to a table?

424


Explain the purpose of %type and %rowtype data types with the example?

390


how to do backup entire database? : Transact sql

417






How is a process of pl/sql compiled?

435


What is difference between cursor and trigger?

359


what is the difference between myisam static and myisam dynamic? : Sql dba

422


why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

402


what is the difference between char_length and length? : Sql dba

386


What are the types of queries in sql?

367


How is a PL/SQL code compiled?

507


What does t sql mean?

392


Does sql use python?

376


How do temporal tables work?

365