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,

---

what are the types of join and explain each? : Sql dba

0 Answers  

---

How to process query result in pl/sql?

0 Answers  

---

What is cte sql?

0 Answers  

---

What is the left table in sql?

0 Answers  

---

How does pl sql work?

0 Answers  

---

What is a merge query?

1 Answers  

---

what is a database transaction? : Sql dba

0 Answers  

---

Is left join same as join?

0 Answers  

---

What is pl sql collection?

0 Answers  

---

What is nvarchar max in sql?

0 Answers  

---

Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

---