How many sql statements are used? Define them.

0 Answers  

---

When are we going to use truncate and delete?

0 Answers  

---

define primary key & secondary key?

2 Answers  

---

Write a simple program on cursors

2 Answers   BirlaSoft,

---

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.

0 Answers   Prodapt,

---

Is sql a microsoft product?

0 Answers  

---

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

4 Answers   GE,

---

can i create trigger on synonym is it possible or not please help me

4 Answers   CGI,

---

How do you declare a user-defined exception?

0 Answers  

---

How exception handling is done in advance pl/sql?

0 Answers  

---

What are pl/sql cursor exceptions?

0 Answers  

---

What is the use of triggers?

0 Answers  

---