Answer / Chhavi Singh

Structural Independence in SQL refers to the ability of a table or database to be understood without referring to other tables. It means that each table should have all the necessary information for its own integrity, and any foreign keys referencing other tables should have defined relationships. Structural Independence is important because it helps ensure data consistency and makes the database easier to understand, manage, and maintain.

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,

---

Can we use ddl commands in pl sql?

1 Answers  

---

Can we insert in sql function?

1 Answers  

---

what are string data types? : Sql dba

1 Answers  

---

Define implicit and explicit cursors.

1 Answers  

---

What do you mean by “trigger” in sql?

1 Answers  

---

explain commit and rollback in mysql : sql dba

1 Answers  

---

explain the advantages and disadvantages of stored procedure? : Sql dba

1 Answers  

---

I need to write a simple query,which one is better select statement or stored procedure?and why?

2 Answers   iGate,

---

What is sql constant?

1 Answers  

---

How do you declare a user-defined exception?

1 Answers  

---

what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?

3 Answers   HCL,

---