Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
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

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