Taking backup of archive log files when database is open. For this the ARCHIVELOG mode should be enabled. The following files need to be backed up. All data files. All Archive log, redo log files. All control files.
If a user executes a query which is already being used by a view exactly will oracle use already existing view to retrieve data or use the query executed by user?
What is Private Database Link in Oracle?
What is Data Block in Oracle Architecture?
Explain can objects of the same Schema reside in different tablespaces?
What is Table in Oracle Architecture?
What is a View in Oracle?
From where does PMON gets the conformance about failure? How is the user process terminated?
What is SID (System Identifier)?
What is Global Database Name?
What are synonyms used for in Oracle?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
