Answer Posted / ravikiran koppisetty
ALTER INDEX INDEXNAME REBUILD
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
what is a crs resource?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How would you go about verifying the network name that the local_listener is currently using?
Explain materialized views and how they are used.
What the different components in replication and what is their use? : sql server DBA
what are the types of connection load-balancing?
how can you implement fine-grained auditing?
What is fill factor? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
what are the differences of where and if in SAS?
what is the role of dip user in our database?
how can a session indicate its interest in receiving alerts?
How would you extract DDL of a table without using a GUI tool?
What is transparent data encryption? : sql server DBA