Interested to Buy Any Domain ? << Click Here >> for more details...
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 do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
Where would you look for errors from the database engine?
What are the commands you'd issue to show the explain plan for "select * from dual"?
What the different components in replication and what is their use? : sql server DBA
how can you record information about current session?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
What is dbcc? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are the operating modes in which database mirroring runs? : sql server DBA
what is a user-defined lock?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
what is grd?
