Answer / Sonoo Kumar Kasaudhan

No, you cannot perform DML (Data Manipulation Language) operations such as INSERT, UPDATE, or DELETE on a View. These operations can only be performed on base tables.

Explain the difference in execution of triggers and stored procedures?

1 Answers  

---

what is the stuff function and how does it differ from the replace function? : Sql dba

1 Answers  

---

What makes a good primary key?

1 Answers  

---

What are the types of functions in sql?

1 Answers  

---

What is the difference between local and global temporary table?

1 Answers  

---

Is sql a oracle?

1 Answers  

---

What is difference between hql and sql?

1 Answers  

---

HP Interview -2016 Unix 1) grep command in unix 2) what is set command

1 Answers   HCL,

---

What is $$ in sql?

1 Answers  

---

When would you denormalize?

8 Answers   MBT, Microsoft, MMU,

---

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

1 Answers   Prodapt,

---

Is not null in sql?

1 Answers  

---