Answer Posted / ehtesham malik
Alter index index_name REBUILD COPMUTE STATISTICS
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
what is the role of dip user in our database?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
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 can you find out if a table can be redefined?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is dbcc? : sql server DBA
What is dcl? : sql server DBA
how can you record information about current session?
Explain materialized views and how they are used.
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
how can you schedule a job in database?
How would you go about verifying the network name that the local_listener is currently using?
what is a crs resource?
What is the default port no on which sql server listens? : sql server DBA