what is the difference between db2start command and start
database manager command?
Answer / deva
db2 start is for ibm database and
database start or start database open are for oracle d.b
Is This Answer Correct ? | 2 Yes | 2 No |
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What type of index should you use on a fact table?
What is dbcc? : sql server DBA
How can you enable a trace for a session?
Explain the difference between a data block, an extent and a segment.
Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?
11 Answers FA, GE, Wipro,
what are the performance views in an oracle rac environment?
What are the recovery models for a database? : 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.
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
suppose you want to audit specific activities on sensitive data. How can you achieve that?