1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Are there any features that are decommissioned in 11g that are not present in 11g?

 1576

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

Wipro,

1994

If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?

 2 5978

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

TCS,

9 8741

What is the difference between UNIQUE KEY and UNIQUE INDEX?

TCS,

3 7506

What is the differnce between view and materialized view

TCS,

4 7512

What is dynamic SQl and how you will create and execute dynamic sql?

TCS,

2 6306

Query for second maximum salary in each in each department

DST Global Solutions, TCS,

15 34234

How many null values can be inserted in a coulmn whihc is unique constraint

Flextronics,

8 10870

How is Oracle 10g helpful when compared to oracle 9i and what is grid computing

Flextronics,

1 4722

What is the difference between SQL and PLSQL

IBM,

4 8581

query to retrive the employees whose sal is greater than avg sal

TCS,

10 12213

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?

Cap Gemini, TCS,

13 19669

select sal from emp group by sal

TCS,

3 5077

A table has 150 records. How do you retrieve 100th row to 120th row from that table ?

IBM,

21 21788

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is the use of sql trace?

464

Define the select into statement.

558

What are the advantages of pl sql over sql?

533

What is package in pl sql with an examples?

530

what are the different tables present in mysql? : Sql dba

491




What are sql injection vulnerabilities?

491

Explain the the delete statements in sql?

569

What is scalar data type in pl sql?

542

What are the sql commands?

598

Can you load data into multiple tables at once? : aql loader

589

Is it possible to include an insert statement on the same table to which the trigger is assigned?

549

What is update query?

535

Can a table have no primary key?

543

Is inner join faster than left join?

619

What is dml statement?

505

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