Answer Posted / monal
IN SQL SERVER 2005 USING NON CLUSTERED INDEX WOULD BE BETTER.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
how can you enable flashback feature?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
How do you open a cluster administrator? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Why would you use sql agent? : sql server DBA
Can you redefine a table online?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What authentication modes does sql server support? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?