SQL PLSQL Interview Questions
Questions Answers Views Company eMail

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

Cap Gemini, MTS,

3 6654

How to find only %th Highest Sal

Symphony, Infogain,

6 7530

How will you make performance better for application including front end and back

Metric Stream,

2 7505




Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?

CTS,

2 7910

What are the Diff B/W Cursor and REF Cursor

CTS,

3 9611

difference between table level constraint and column level and advantages of table level constraint

Doyensys,

4 7310

I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL

Metric Stream, Doyensys, Infosys,

5 13483

I have a table .in the table 100 recored is there .we have get the single row with out using clause..

3 6047




In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

GE,

2 2774

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

GE,

4 6689

if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 2064

.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 3703

when normalization is required

HCL,

3 4751

can i create trigger on synonym is it possible or not please help me

CGI,

4 7128

I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????

Infosys,

3 8206


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

Explain spool.

3


Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

12


Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

1137


What is Histogram?

425


1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

1201






What is AUTH_ID and AUTH_USER in pl/sql ?

850


Show code of a cursor for loop.

1


Can we use the cursor's to create the collection in PL/SQL?

10


How to change the order of columns in Oracle SQL Plus ?

10


First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

549


how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

2256


what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

1421


Differentiate between syntax and runtime errors.

1


What is a database event trigger?

1


How would you reference column values before and after you have inserted and deleted triggers?

1