Answer Posted / ravikiran koppisetty
ALTER INDEX INDEXNAME REBUILD
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the different types of upgrades that can be performed in sql server? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
how can you implement fine-grained auditing?
How would you extract DDL of a table without using a GUI tool?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is a correlated sub-query? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
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?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
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?
What is replication? : sql server DBA