Describe what redo logs are.
Answer / gogune suresh kumar
All data changes to the database are stored in redo-log
buffers.
Is This Answer Correct ? | 4 Yes | 0 No |
How to make a replica of existing oracle server to another server?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What are the commands used in dcl? : sql server DBA
Query processing is slow(eg select query)how will u solve that
WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
what do you understand by flashback feature of oracle?
Give two examples of referential integrity constraints.
What is the difference between the SQL Loader and IMPORT utilities?
What are the commands you'd issue to show the explain plan for "select * from dual"?
What is replication? : sql server DBA
Explain the use of table functions.