What is materialized view. What are different methods of refresh?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

What is pessimistic concurrency control? : Transact sql

0 Answers  


Why do we need a foreign key?

0 Answers  


what is self join and why is it required? : Sql dba

1 Answers  


what is bdb (berkeleydb)? : Sql dba

0 Answers  


What does data normalization mean?

0 Answers  






i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 Answers   IBM, Loginworks, OFSS,


how is exception handling handled in mysql? : Sql dba

0 Answers  


How to rename a table?

0 Answers  


What is the purpose of the primary key?

0 Answers  


What is sql and also describe types of sql statements?

0 Answers  


Can we use two order by clause in query?

0 Answers  


How many types of keys are there in sql?

0 Answers  


Categories