Answer Posted / ravikiran koppisetty
ALTER INDEX INDEXNAME REBUILD
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
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.
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
how can a session indicate its interest in receiving alerts?
how can you schedule a job in database?
What happens on checkpoint? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
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 is the difference between dropping a database and taking a database offline? : sql server DBA
what is the diffrence between core dba and apps dba?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.