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,

---

why sql is used as interpreter frequently rather than a compile?

1 Answers  

---

Describe different types of general function used in sql?

0 Answers  

---

In a Distributed Database System Can we execute two queries simultaneously ? Justify ?

3 Answers  

---

What is sqlite format?

0 Answers  

---

How to copy a table in another table with datas?

9 Answers  

---

How to retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000

10 Answers   Mind Tree, Polaris, Sonata,

---

Are left and right joins the same?

0 Answers  

---

What is procedure function?

0 Answers  

---

Is not equal in sql?

0 Answers  

---

How does left join work in sql?

0 Answers  

---

What is an Exception ? What are types of Exception ?

2 Answers  

---