Answer Posted / rajesh naidu
ALTER SYSTEM SWITCH LOGFILE BY THIS WAY U CAN FORCE TO LOG
SWITCH
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What happens on checkpoint? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
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 is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
internal architecture
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
What are the different ways you can create databases in sql server? : sql server DBA
how does an oracle clusterware manage crs resources?
What authentication modes does sql server support? : sql server DBA
what functionality does oracle provide to secure sensitive information?
Explain about your sql server dba experience? : sql server DBA
What is fill factor? : sql server DBA
Where would you look for errors from the database engine?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
