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
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
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
what functionality does oracle provide to secure sensitive information?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Where do you find the default index fill factor and how to change it? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
what is grd?
What the different types of replication and why are they used? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What is the importance of a recovery model? : 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
How do you trace the traffic hitting a sql server? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What authentication modes does sql server support? : sql server DBA
how can you find out if a table can be redefined?
