As a part of your job, what are the DBCC commands that you
commonly use for database maintenance?
- 1 Answers
- 3729 Views
- IBM, I also Faced
- E-Mail Answers
What is dcl? : sql server DBA
How would you force a log switch?
Can you redefine a table online?
What are the steps you will take to improve performance of a poor performing query?
. 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?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?
How does Oracle guarantee data integrity of data changes?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
What is checkpoint?
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
what is rebuild index??
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
