Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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.

Question Posted / palanivel

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

How do I order by ascending in sql?

0 Answers  

what are enums used for in mysql? : Sql dba

0 Answers  

What is string data type in sql?

0 Answers  

What are system versioned tables?

0 Answers  

What is mutating trigger?

0 Answers  




What is the difference between numeric and autonumber?

0 Answers  

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

0 Answers   CTS,

How do you create a unique index?

0 Answers  

How to fetch records from a partitioned table?

2 Answers   HSBC,

what are tables and fields? : Sql dba

0 Answers  

Is sql harder than python?

0 Answers  

What are inner and outer joins examples of both?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories