SQL PLSQL Interview Questions
Questions Answers Views Company eMail

How to display all Friday's in a year with date?

Flipkart,

3 2810

display null value rows with out using null function?

Infosys,

8 3724

HP Interview -2016 Unix 1) grep command in unix 2) what is set command

HCL,

1 2068




How to find the count of letter "L" in HELLO

HP,

6 3211

What is Temp Table and type of temp table?

HP, SLK,

677

What is user define exception and example

HP, KP,

1 1729

What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..

Polaris, Metric Stream,

1 1870

How collections are improve the performance?

Polaris,

1 1925




If we update a complex view, is base table will get update ?

HCL, Ardee Technologies,

2 2630

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

CTS,

533

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.

Prodapt,

497

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

CTS,

528

display your age in months?

2 1822

how to insert the records in particular position

1 863

what is try_catch block in procedure

519


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

How do you use collections in procedure to return the resultset?

1147


what is the bond code in materialized view?

1705


What are code pages ?

1074


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

955


table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2167






What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?

1223


write a query that returns first characters of each word in Oracel/Sql pl sql

6122


How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from ; except this you can't use another select statement. You can use no of variables as per requirement.

337


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

1180


What packages(if any) has oracle provided for use by developers?

3855


i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

2262


Could you please provide oca (oracle 10g) dumps for my certification ?

3456


in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

1031


1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

533


Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

2456