What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
No Answer is Posted For this Question
Be the First to Post Answer
What are statistics, under what circumstances they go out of date, how do you update them?
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?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
what is the use of recording information about current session?
what is grd?
Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?
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 would you determine what sessions are connected and what resources they are waiting for?
Can you redefine a table online?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
WHEN DOWN TIME WHAT CAN U DO?
How do you resize a data file?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)