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

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

Flipkart,

3 3522

display null value rows with out using null function?

Infosys,

8 4816

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

HCL,

1 2578

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

HP,

6 4140

What is Temp Table and type of temp table?

HP, SLK,

1 1112

What is user define exception and example

HP, KP,

1 2118

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

Metric Stream, Polaris,

1 2278

How collections are improve the performance?

Polaris,

1 2502

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

Ardee Technologies, HCL,

2 3229

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,

749

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,

745

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

939

display your age in months?

2 2428

how to insert the records in particular position

1 1235

what is try_catch block in procedure

747


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

how to create a test table in your mysql server? : Sql dba

144


What is view explain with example?

124


Why we use joins in sql?

129


What are sql functions? Describe the different types of sql functions?

148


Is pl sql and postgresql same?

116






Does google use sql?

126


Which certification is best for sql?

125


What is the default isolation level in sql server? : Transact sql

144


How to check if a column is nullable before setting to nullable?

156


How many types of triggers are there in pl sql?

119


Can procedure in package be overloaded?

186


What are the different dml commands in sql?

155


Explain table and field in sql?

166


What is vector point function?

129


Is mariadb a nosql database?

120