Answer Posted / chowdary
Buffer Cache Advice, Segment Level Statistics and Timed
Statistics
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Why does Oracle not permit the use of PCTUSED with indexes?
how to restore files with rman?
What is the difference between clustered and non-clustered index? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
Query processing is slow(eg select query)how will u solve that
What is transparent data encryption? : sql server DBA
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
What are the recovery models for a database? : sql server DBA
What authentication modes does sql server support? : sql server DBA
how can you record information about current session?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What are the operating modes in which database mirroring runs? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
What is replication? : sql server DBA
What types of replication are supported in sql server? : sql server DBA