What would you do if a database crashes in production?
• Identify the issue using database logs.
• Restore from the latest backup.
• If replication is enabled, switch to a replica database.
• Check for corrupt data and perform integrity checks.
• Implement monitoring tools to prevent future crashes.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is blob datatype?
List the parts of a database trigger.
How to convert a date to char in oracle? Give one example.
Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.
What are the roles of dba?
Why is oracle database so popular?
how to get count of tables in particular database in Oracle?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
How to rollback the current transaction in oracle?
14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth
Please explain compound trigger in oracle?
How you find out version of installed workflow?