Explain materialized views and how they are used.
No Answer is Posted For this Question
Be the First to Post Answer
Where in the Oracle directory tree structure are audit traces placed?
Why would you use sql agent? : sql server DBA
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.
How would you go about increasing the buffer cache hit ratio?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
How can you gather statistics on a table?
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?
Give two methods you could use to determine what DDL changes have been made.
What is the importance of a recovery model? : sql server DBA
If CPU is very slow What can u do to speed up?
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
What command would you use to encrypt a PL/SQL application?