Answer / ankush seth

three types of refreshment techniques for materialised
view
1)Fast refresh
2)Force refresh
3)Complete refresh

Answer / rajesh venati

The above one good,
There are Three Types of Refreshment Techniques in
Materialized View.
They are,

1. Fast Refresh
2. Force Refresh
3. Complete Refresh

What is your daily office routine?

0 Answers   Data Vision,

---

How many types of keys are there in sql?

0 Answers  

---

Explian rowid, rownum?

0 Answers  

---

What is crud diagram?

0 Answers  

---

Why is sharding used?

0 Answers  

---

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

2 Answers   CG,

---

how to convert character strings to numeric values? : Sql dba

0 Answers  

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

What is sql*loader and what is it used for?

0 Answers  

---

mail-id table contains two columns(email_id,userid) it contains different types of mail-ids,and no of users. here username length is differ na,(ex- tamil@yahoo.com,joshua@hotmail.com like) now i want to fetch the email-ids only starting from '@' (ex-@gmail.com,@yahoo.com,@hotmail.com

5 Answers  

---

Is sql a case sensitive language?

0 Answers  

---

What is the difference between DELETE, TRUNCATE, and DROP?

3 Answers  

---