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

Give an example of any procedure.

5 Answers   Accenture, iFlex, Wipro,

What is error ora-12154: tns:could not resolve the connect identifier specified?

0 Answers  

How do you write a subquery?

0 Answers  

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

0 Answers  

what are date and time functions in mysql? : Sql dba

0 Answers  




How can you view the errors encountered in a trigger?

0 Answers  

What are the basic sql commands?

0 Answers  

What is user define exception and example

1 Answers   HP, KP,

What is the difference between delete and truncate commands?

0 Answers  

what is the difference between trigger and storedprocedures

16 Answers   Tech Mahindra,

what are the advantages and disadvantages of cascading style sheets? : Sql dba

0 Answers  

Is it possible to link two groups inside a cross products after the cross products group has been created?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories