Answer Posted / deepak
alter index <indexname> rebulid;
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All 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
What are the different sql server versions you have worked on? : sql server DBA
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.
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
how can you get actual data change values from previous transactions in oracle?
What the different types of replication and why are they used? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
how can you connect from 10g user to 11g user??
Explain about your sql server dba experience? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What are the recovery models for a database? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What is replication? : sql server DBA