What needs to be done when the database is shutdown?



What needs to be done when the database is shutdown?..

Answer / Dhiraj Singh Garbyal

When a database is shut down, it's essential to ensure that all active transactions are committed or rolled back to maintain data consistency. If there are any long-running transactions that haven't been completed yet, they may need to be terminated forcefully. Additionally, depending on the database configuration, you might need to perform backup operations before shutting down.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

What is recovering sessions?

1 Answers  


what is parallelism?

2 Answers  


What are the methodologies of data warehousing?

1 Answers  


What is hash partition?

3 Answers   TCS,


Explain a mapping, session, worklet, workflow, mapplet?

1 Answers  


Explain what are the various methods of getting incremental records or delta records from the source systems?

1 Answers  


What is a real-time data warehouse?

1 Answers  


Is there any default username & pwd for bo designer & supervisor?

1 Answers  


waht is the advantage of infoset query

0 Answers   iGate,


Hierarchy of DWH?

2 Answers   Accenture, EDS, IBM, iFlex, TCS,


What is Bulk Insert?

3 Answers  


What is the difference between power center & power mart?

1 Answers  


Categories