Answer / Chandra Prakash

"Advantages of Views:n- Simplifies complex queries for end users.n- Improves data security by limiting access to sensitive data.n- Provides virtual tables based on existing tables.nnDisadvantages of Views:n- Reduces performance due to the additional layer of abstraction.n- Limits the ability to modify data directly.n- Dependent on underlying tables, and errors in those tables may affect the view."n

What is the purpose of a sql?

1 Answers  

---

How do I create a memory optimized filegroup?

1 Answers  

---

Can you have more than one key in a database?

1 Answers  

---

What are Global Temporary tables

3 Answers   IBM, TCS,

---

Which operator is used in query for pattern matching?

1 Answers  

---

If we have n no of columns in a table, can we add new column in that table with not null constraint?

2 Answers  

---

how to connect oracle in unix prompt?

4 Answers   Polaris,

---

What is sql and how does it work?

1 Answers  

---

What is pl sql architecture?

1 Answers  

---

What are the different datatypes available in PL/SQL?

1 Answers  

---

what is meant by urlencode and urldocode? : Sql dba

1 Answers  

---

What is type and rowtype in pl sql?

1 Answers  

---