What type of index should you use on a fact table?
Answer / monal
IN SQL SERVER 2005 USING NON CLUSTERED INDEX WOULD BE BETTER.
Is This Answer Correct ? | 3 Yes | 0 No |
What questions might be they ask in managerial round in capgemini.
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 do you open a cluster administrator? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
what are the differences of where and if in SAS?
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
wat is global index and local indes
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What is blocking and how would you troubleshoot it?
What are the different types of upgrades that can be performed in sql server? : 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.