What is OERR Utility
How many max datafiles can there be in an Oracle Database.
How do you control No. of Datafiles one can have in an Oracle Database.
How to write script for export backup in shell.
You have a database. You have a datafile and some blocks are corrupted in the datafile. What statement will you issue to know how many blocks are corrupted?
Latest Answer: you can use the DBVERIFY utility to check the corruption in datafiles so that you can now number of blocks corrupted.Here is the procedure :On o/s prompt login as oracle user : $ dbv file= 'datafile name'now in the output check for the ...
What is standby databases? Difference between Physical and logical standby databases
Latest Answer: A standby database is a transactionally consistent copy of the primary database. Using a backup copy of the primary database, you can create up to nine standby databases.A standby database can be either a physical standby database or a logical standby ...
What is a flash back query? This feature is also available in 9i. whats the difference between 9i and 10g (related to flash back query).
Latest Answer: Oracle 10g offers significant enhancements that help insure the high availability of any Oracle database, as well as improvements in the database disaster recovery arena. This paper explores one of the most intriguing new features of Oracle 10g: Flashback ...
Tell me any instance when your database encountered any problem. How you dealt with that problem.
Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.
Latest Answer: Hi,Oracle write error in alert log file. Depending upon the error corrective action needs to be taken.1) DeadLock Error : Take the trace file in user dump destination and analysis it for the error.2) ORA-01555 Snapshot error. Check the query try to fine ...
Describe four properties of database isolation. In which situation lock contention will happen. What is transaction lock?
View page << Previous 3 4 5 6 [7] 8 9 10 11 12 Next >>
Go Top
