Explain materialized views and how they are used.


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

Post New Answer

More DB Administration Interview Questions

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  


Why would you use sql agent? : sql server DBA

0 Answers  


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  


How would you go about increasing the buffer cache hit ratio?

2 Answers  


What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers  






How can you gather statistics on a table?

3 Answers  


You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers  


Give two methods you could use to determine what DDL changes have been made.

2 Answers  


What is the importance of a recovery model? : sql server DBA

0 Answers  


If CPU is very slow What can u do to speed up?

1 Answers  


If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers  


What command would you use to encrypt a PL/SQL application?

1 Answers  


Categories