Interested to Buy Any Domain ? << Click Here >> for more details...
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
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
How to start SQL Server in minimal configuration mode?
what is a user-defined lock?
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.
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What are the different types of indexes available in sql server? : sql server DBA
what do you understand by fine-grained auditing?
What is transparent data encryption? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What are the commands used in dcl? : sql server DBA
how can you enable flashback feature?
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.
What are statistics, under what circumstances they go out of date, how do you update them?
