Answer Posted / guest
alter system switch logfile
Regards
Abhinav Phadnis
| Is This Answer Correct ? | 19 Yes | 2 No |
Post New Answer View All Answers
Where would you look for errors from the database engine?
Why would you use sql agent? : sql server DBA
how can you find out if a table can be redefined?
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
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
when does an alert gets signaled?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
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.
what do you understand by fine-grained auditing?
what is the diffrence between core dba and apps dba?
what is asm?
What is replication? : sql server DBA
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.
How would you best determine why your MVIEW couldn't FAST REFRESH?
how can you process messages in order asynchronously?