Answer / m.m

You can go through the Oracle press book for sql and pl/sql.
To get an idea on the type of qs asked in the exam, surf
and run through the dumps.

Answer / somashekhar m

Better U join ucertigy.com MS PL/SQL on line course where
they will even teach you how to appear for exam, where and
when. Once if you become a member to ucertify pl. notify me
on msomashekhar@rediffmail.com

What is trigger in sql?

0 Answers  

---

What is the difference between DELETE, TRUNCATE, and DROP?

3 Answers  

---

What is a call statement? Explain with an example.

0 Answers  

---

What is a constraint. Types of constraints ?

5 Answers   Accenture, BirlaSoft,

---

What is sql*plus?

0 Answers  

---

what is collation? : Sql dba

0 Answers  

---

what is the difference between cluster and non cluster index? : Sql dba

0 Answers  

---

How do you write an inner join query?

0 Answers  

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

0 Answers  

---

What are the possible values for the boolean data field?

0 Answers  

---

What is the importance of sqlcode and sqlerrm?

0 Answers  

---

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

---