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

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..

1996

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?

9 8746

What is the difference between UNIQUE KEY and UNIQUE INDEX?

3 7506

What is the differnce between view and materialized view

4 7514

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

2 6307

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

8 10873

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

1 4722

What is the difference between SQL and PLSQL

4 8581

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

10 12216

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

3 5077

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

21 21791

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is database migration?

506

what is sp_pkeys? : Transact sql

686

Can we perform dml on view?

544

What is data manipulation language?

682

What is sql query limit?

499

Explain what is a subquery ?

644

How does sql store data?

477

How do I view stored procedures?

532

When sql appeared?

606

What is package in pl sql with an examples?

530

What is vector point function?

553

How can I tell if sql is running?

573

how to add a new column to an existing table in mysql? : Sql dba

573

What is latest version of sql?

513

What is pl sql in oracle?

565

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