What is RAC in oracle?

7 Answers   MCN Solutions,

---

How much ram can sql express use?

0 Answers  

---

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

0 Answers  

---

What is compilation error in pl sql?

0 Answers  

---

How is debugging done?

0 Answers  

---

What is function and procedure?

0 Answers  

---

What is view explain with example?

0 Answers  

---

can we delete the trigger in a view? if yes why if not why?

5 Answers   Tech Mahindra,

---

what is the purpose of update command in oracle?

7 Answers   MBT,

---

what is self-join? : Sql dba

0 Answers  

---

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---