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

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

1119

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,

1566

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 5171

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 6331

What is the difference between UNIQUE KEY and UNIQUE INDEX?

TCS,

3 6385

What is the differnce between view and materialized view

TCS,

4 6178

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

TCS,

2 5377

Query for second maximum salary in each in each department

DST Global Solutions, TCS,

15 30274

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

Flextronics,

7 8025

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

Flextronics,

1 4150

What is the difference between SQL and PLSQL

IBM,

4 7488

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

TCS,

10 9859

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 15334

select sal from emp group by sal

TCS,

3 4109

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

IBM,

21 17178


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

225


How do you run a query?

215


What is an implicit commit?

179


How do I view tables in mysql?

188


Is record in pl sql?

191






What is Materialized View? In What Scenario we Use Materialized View?

7646


What are the advantages of sql? Explain

232


What are schema-level triggers?

238


What has stored procedures in sql and how we can use it?

215


Explain the commit statement.

234


What type of database is cloud sql?

176


What is the primary key?

228


how can we know the number of days between two given dates using mysql? : Sql dba

198


Write an sql query to select all records from the table?

207


What is pl sql architecture?

185