1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
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 10108

what is pragma ?

Polaris,

1 6346

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

HCL, Wipro,

3 9569

how to calcuate the second highest salary of he employee

Synechron,

13 15095

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

Fiserv, Herbinger, Synechron,

1 10489

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

 17 27821

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 6326

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

IBM,

3 8587

What are Global Temporary tables

IBM, TCS,

3 9596

What are Anti joins

IBM,

1 9013

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 7026

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 13457

What is bulk collections?

 2 6391

what is External tables? explain with examples

TCS,

2 12531

what is difference between decode and case function?

 2 8982

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Is it possible to update views?

532

What is oracle pl sql developer?

528

What is trigger in sql?

574

What is the difference between alter trigger and drop trigger statements?

599

what are the disadvantages of mysql? : Sql dba

568




Is record in oracle pl sql?

525

Is sql the best database?

496

Explain the difference between rename and alias?

543

What is rowid in sql?

504

Is sqlite thread safe?

598

What is benefit of creating memory optimized table?

535

What is sql and also describe types of sql statements?

558

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

612

Which is faster joins or subqueries?

547

what are all the different types of indexes? : Sql dba

524

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