Answer Posted / b.r.reddy
We can manually set the statistical values.
We can gather statistics in parallel mode.
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Where would you look for errors from the database engine?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
what is a user-defined lock?
What is the default fill factor value? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
what are the types of connection load-balancing?
What are the different sql server versions you have worked on? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
What is dbcc? : sql server DBA
how can you schedule a job in database?
Why does Oracle not permit the use of PCTUSED with indexes?
What are statistics, under what circumstances they go out of date, how do you update them?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
what are the performance views in an oracle rac environment?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?