what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
2 14323Post New Oracle General Questions
What are the different types of record groups in oracle? Explain each of them
What are the execution control statements in oracle?
Explain the use of control file?
How is it different from a normal table?
Can we protect our pl/sql source code?
What happens if variable names collide with table/column names?
Explain an exception and its types?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
Why do you create or replace procedures rather that drop and recreate.
How many types of tables are there in oracle?
What is a snapshot in oracle database?
State the various uses of dbcc command?
How to establish administrator authentication to the server?
How to call a stored function with parameters?
What is save point in oracle database?