Answer / Rizwan Ahmad

No, views do not necessarily execute faster than queries. A view is a virtual table based on the result-set of an SQL statement, whereas a query directly accesses the database tables. The performance can depend on various factors such as the complexity of the view definition, the number and type of joins involved, indexing, etc. However, views can improve application portability, simplify complex queries, enforce data security, and reduce redundant data.

What is cte sql?

1 Answers  

---

Do ddl statements need commit?

1 Answers  

---

How can we implement rollback or commit statement in a trigger?

1 Answers  

---

Is natural join same as inner join?

1 Answers  

---

How can you create Cursor with parametres ?

3 Answers  

---

suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??

5 Answers   Keane India Ltd,

---

What is the difference between SQL table and the PLSQL table?

3 Answers   Mastek,

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1 Answers  

---

What is the difference between a primary key and a clustered index?

1 Answers  

---

Which are the most commonly used sql joins?

1 Answers  

---

What are the 3 types of behavioral triggers?

1 Answers  

---

what is Hash join?how it is different from inner join?what is the sign used for inner join?(eg: like the (+) sign used for outer join)?

3 Answers   TCS,

---