Interested to Buy Any Domain ? << Click Here >> for more details...
Name three advisory statistics you can collect.
- 1 Answers
- 5499 Views
- I also Faced
- E-Mail Answers
Answer / chowdary
Buffer Cache Advice, Segment Level Statistics and Timed
Statistics
| Is This Answer Correct ? | 4 Yes | 0 No |
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Explain what partitioning is and what its benefit is.
why do we give pctfree and pctused in create table statement?
how can you implement fine-grained auditing?
how can you initialize log miner?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
When a user process fails, what background process cleans up after it?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What command would you use to create a backup control file?
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.
Can we take incremental backups in datapump?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
