If the base table structure is changed what will happen to join index????

2 Answers  

---

What is foreign key and example?

0 Answers  

---

What is sqlexception in java?

0 Answers  

---

Show the two pl/sql cursor exceptions.

0 Answers  

---

Can a table have two primary keys?

44 Answers   HCL, MetaCube,

---

---

How to get list of all tables from a database?

0 Answers  

---

What are the differences between Database Trigger and Integrity constraints ?

4 Answers  

---

How do you clear the screen in sql?

0 Answers  

---

How to execute OS(operating system) command from pl/sql?

3 Answers  

---

In testing where do we use sql language and how it helps in testing?

2 Answers  

---

What are actual parameters and formal parameters?

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,

---