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
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
Why would you call update statistics? : sql server DBA
how to restore files with rman?
Why does Oracle not permit the use of PCTUSED with indexes?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what is the use of ocr?
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 recovery models for a database? : sql server DBA
What is transparent data encryption? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What is fill factor? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
What are the different types of indexes available in sql server? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA