Name three advisory statistics you can collect.
Answer / chowdary
Buffer Cache Advice, Segment Level Statistics and Timed
Statistics
| Is This Answer Correct ? | 4 Yes | 0 No |
I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What are the different ways you can create databases in sql server? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
how can you initialize log miner?
Explain how you would restore a database using RMAN to Point in Time?
What are the operating modes in which database mirroring runs? : sql server DBA
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 command would you use to encrypt a PL/SQL application?
Can you redefine a table online?
If CPU is very slow What can u do to speed up?
how can you connect from 10g user to 11g user??
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)